public ActionResult AddCustomer(CustTable emp)
{
var context = new MyDatabase();
context.CustTables.Add(Customer);
context.SaveChanges();
return(RedirectToAction("Display"));
}
public ActionResult NewCustomer(CustTable cus)
{
var context = new Mydb();
context.CustTables.Add(cus);
context.SaveChanges();
return(RedirectToAction("AllCustomers"));
}
public ActionResult Find(CustTable customer)
{
var context = new MyDatabase();
var model = context.custTables.FirstOrDefault((e) => e.CustId == Customer.CustId);
model.CustName = customer.EmpName;
model.CustAddress = customer.EmpAddress;
model.CustSalary = customer.EmpSalary;
context.SaveChanges();
return(RedirectToAction("Display"));
}
public ActionResult Find(CustTable cus)
{
var context = new Mydb();
var model = context.CustTables.FirstOrDefault((e) => e.CustId == cus.CustId);
model.CustName = cus.CustName;
model.CustAddress = cus.CustAddress;
model.CustSalary = cus.CustSalary;
context.SaveChanges();
return(RedirectToAction("AllCustomers"));
}
private void ShowDb()
{
CustTable.Rows.Clear();
CustTable.Columns.Clear();
CustTable.Refresh();
for (int i = 0; i < checkColls.Count; i++)
{
if (checkColls[i].Checked)
{
CustTable.Columns.Add(coll[i], coll[i]);
}
}
Table <User> users = db.GetTable <User>();
foreach (var user in users)
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(CustTable);
int j = 0;
for (int i = 0; i < checkColls.Count; i++)
{
if (checkColls[i].Checked)
{
if (i == 8)
{
row.Cells[j].Value = mnr.GetItem(int.Parse(user.GetCell(i))).FullName;
}
else
{
row.Cells[j].Value = user.GetCell(i);
}
j++;
}
}
CustTable.Rows.Add(row);
}
CustTable.Refresh();
}
public ViewResult AddCustomer()
{
var model = new CustTable();
return(View(model));
}
