public void UpdateSalesJobMasterListCustomerID(int jcID) { var jc = _db.Sales_JobMasterList_Customer.Find(jcID); PostBackProjectID = jc.jobID; jc.cID = RowID; _db.Entry(jc).State = EntityState.Modified; _db.SaveChanges(); }
public IHttpActionResult PutOrder(int id, Order order) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != order.OrderId) { return(BadRequest()); } db.Entry(order).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!OrderExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutRestaurant(int id, Restaurant restaurant) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != restaurant.ResId) { return(BadRequest()); } db.Entry(restaurant).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!RestaurantExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutAdmin_Table(int id, Admin_Table admin_Table) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != admin_Table.AminId) { return(BadRequest()); } db.Entry(admin_Table).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!Admin_TableExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
/// <summary> /// Edit an existing lead /// </summary> /// <param name="createViewModel"></param> /// <param name="username"></param> public void EditLead(LeadModifyViewMode createViewModel, string username) { var lead = createViewModel.Lead; var emp = new CrmEmployee(username); lead.LastUpdatedBy = emp.UserEmployeeID; lead.LastUpdatedAt = DateTime.Now; var cdt = lead.CriticalDeadline; lead.CriticalDeadline = cdt; try { _db.Entry(lead).State = EntityState.Modified; createViewModel.Address.AddressID = lead.AddressID; _db.Entry(createViewModel.Address).State = EntityState.Modified; _db.SaveChanges(); RecordLeadStatusChangdTime(lead); RecordLeadAeChangdTime(lead); LogMethods.Log.Debug("EditLead:Debug:" + "Done"); } catch (Exception ex) { LogMethods.Log.Error("EditLead:Error:" + ex.Message); } }
//update customer public HttpResponseMessage Put(int id, Customer customer) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } if (id != customer.CustomerID) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } db.Entry(customer).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } return(Request.CreateResponse(HttpStatusCode.OK)); }
private void UpdateSales_JobMasterList_Customer(int jcID, int jobID, int contactID, int customerID, int type) { try { var sales_JobMasterList_Customers = _db.Sales_JobMasterList_Customer.Where(x => x.jobID == jobID).ToList(); if (sales_JobMasterList_Customers.Any()) { foreach (var element in sales_JobMasterList_Customers) { switch (type) { case 1: element.isBillTo = false; break; case 2: element.isQuoteTo = false; break; case 3: element.isInstallOrShipTo = false; break; default: break; } _db.Entry(element).State = EntityState.Modified; } _db.SaveChanges(); } Sales_JobMasterList_Customer sales_JobMasterList_Customer = _db.Sales_JobMasterList_Customer.FirstOrDefault(x => x.jcID == jcID); if (sales_JobMasterList_Customer != null) { switch (type) { case 1: sales_JobMasterList_Customer.isBillTo = true; break; case 2: sales_JobMasterList_Customer.isQuoteTo = true; break; case 3: sales_JobMasterList_Customer.isInstallOrShipTo = true; break; default: break; } sales_JobMasterList_Customer.contactName = contactID; sales_JobMasterList_Customer.cID = customerID; _db.Entry(sales_JobMasterList_Customer).State = EntityState.Modified; _db.SaveChanges(); } LogMethods.Log.Debug("UpdateSales_JobMasterList_Customer:Debug:" + "Done"); } catch (Exception e) { LogMethods.Log.Error("UpdateSales_JobMasterList_Customer:Error:" + e.Message); } }