ASP with LINQ to SQL

Using LINQ to SQL to Add/Delete from SQL Database in C#

http://www.programminghelp.com/web-development/asp-net/using-linq-to-sql-to-add-delete-from-sql-database-in-c/






Layered Structure






Client Page Customer

protected void Page_Load(object sender, EventArgs e)
{
RefreshGrid();

}

protected void ButtonSubmit_Click(object sender, EventArgs e)
{
Objects.CustomerObj customerObj = new Objects.CustomerObj() { ID =Convert.ToInt16( TextBoxCustNumber.Text), Name = TextBoxCustName.Text };
new CustomerBusinessFlow().Add(customerObj);
RefreshGrid();
}

private void RefreshGrid()
{
GridView1.DataSource = new CustomerBusinessFlow().RetrieveAllRecords();
GridView1.DataBind();

}

protected void ButtonUpdate_Click(object sender, EventArgs e)
{
Objects.CustomerObj customerObj = new Objects.CustomerObj() { ID = Convert.ToInt16(TextBoxUpdateOrRemove.Text),Name = TextBoxCustName.Text };
new CustomerBusinessFlow().Update(customerObj);
RefreshGrid();
}

protected void ButtonRemove_Click(object sender, EventArgs e)
{
new CustomerBusinessFlow().Remove(Convert.ToInt16(TextBoxUpdateOrRemove.Text));
RefreshGrid();
}






Customer Business Flow




public class CustomerBusinessFlow
{
public List RetrieveAllRecords()
{
return new CustomerFacade().GetAll();
}

public Objects.CustomerObj Add(Objects.CustomerObj entity)
{
return new CustomerFacade().Add(entity);
}

public void Remove(int ID)
{
new CustomerFacade().Remove(ID);
}

public void Update(Objects.CustomerObj entity)
{
new CustomerFacade().Update(entity);
}


}



Customer Facade Flow



public class CustomerFacade
{
public List GetAll()
{
return new CustomerDataAccess().GetAll();
}

public Objects.CustomerObj Add(Objects.CustomerObj entity)
{
return new CustomerDataAccess().Add(entity);
}

public void Remove(int ID)
{
new CustomerDataAccess().Remove(ID);
}

public void Update(Objects.CustomerObj entity)
{
new CustomerDataAccess().Update(entity);
}
}



Customer Data Access



public class CustomerDataAccess : ICustomerRepository
{
private DataDef.OrdersDataContext orderdataContext;

public CustomerDataAccess()
{
orderdataContext = new DataDef.OrdersDataContext();
}

public List GetAll()
{
List CustomerList = (from CustomerSQLObj in orderdataContext.Customers
select new Objects.CustomerObj
{
ID = CustomerSQLObj.CustomerID,
Name = CustomerSQLObj.FirstName,
}).ToList();
return CustomerList;
}

public Objects.CustomerObj GetByID(int ID)
{
Objects.CustomerObj customeObj = (from CustomerSQLObj in orderdataContext.Customers
where CustomerSQLObj.CustomerID == ID
select new Objects.CustomerObj
{
ID = CustomerSQLObj.CustomerID,
Name = CustomerSQLObj.FirstName,
}).FirstOrDefault();
return customeObj;
}

public Objects.CustomerObj Add(Objects.CustomerObj entity)
{
DataDef.Customer customer = new DataDef.Customer()
{PasswordHash = "asdfefwe",PasswordSalt = "fasdfasj", CustomerID = entity.ID , FirstName = entity.Name ,LastName = "rand",NameStyle = false ,rowguid = Guid.NewGuid(), ModifiedDate = DateTime.Now};
orderdataContext.Customers.InsertOnSubmit(customer);
orderdataContext.SubmitChanges();
Objects.CustomerObj entityReturn = new Objects.CustomerObj { ID = customer.CustomerID};
return entityReturn;
}

public void Remove(int ID)
{

DataDef.Customer customer = orderdataContext.Customers.Single(p => p.CustomerID == ID);
orderdataContext.Customers.DeleteOnSubmit(customer);
orderdataContext.SubmitChanges();

}

public void Update(Objects.CustomerObj entity)
{

DataDef.Customer customer = (from customerSQLObj in orderdataContext.Customers
where customerSQLObj.CustomerID == entity.ID
select customerSQLObj).FirstOrDefault();

customer.FirstName = entity.Name;

orderdataContext.SubmitChanges();
}
}



Customer Data Objects


public class CustomerObj
{
public int ID { get; set; }
public string Name { get; set; }
}



IRepository


public interface IRepository
{
List GetAll();
T GetByID(int ID);
T Add(T entity);
void Remove(int ID);
void Update(T entity);
}


ICustomerRepository


public interface ICustomerRepository : IRepository
{

}