public static int DeleteCustomer(string CusID) { var deleted = db.Customers.Where(x => x.CustomerID == CusID).FirstOrDefault(); db.Customers.Remove(deleted); return(db.SaveChanges()); }
protected void lvwDt_ItemUpdating(object sender, ListViewUpdateEventArgs e) { ListViewItem item = lvwDt.Items[e.ItemIndex]; string id = lvwDt.DataKeys[e.ItemIndex].Value.ToString(); string compantName = (item.FindControl("txtval") as TextBox).Text; Customer customer = context.Customers.Find(id); customer.CompanyName = compantName; context.SaveChanges(); lvwDt.EditIndex = -1; lvwDt.DataSource = context.Customers.ToList(); lvwDt.DataBind(); }
public static int AddCustomer(Customer customer) { Customer c = new Customer(); c.Address = customer.Address; c.City = customer.City; c.CompanyName = customer.CompanyName; c.ContactName = customer.ContactName; c.Country = customer.Country; c.Phone = customer.Phone; c.PostalCode = customer.PostalCode; c.Region = customer.Region; c.Fax = customer.Fax; c.ContactTitle = customer.ContactTitle; c.CustomerID = customer.CustomerID; db.Customers.Add(c); return(db.SaveChanges()); }
public bool Save() { return(_ctx.SaveChanges() >= 0); }
public Category Add(Category category) { _context.Categories.Add(category); _context.SaveChanges(); return(category); }
public void SaveChanges() { _context.SaveChanges(); }