// POST api/CRMCusContact?tblCuscontact public void Post([FromBody] tblCusContact cc) { using (var ctx = new CRMModel()) { var cuscon = ctx.Set <tblCusContact>(); cuscon.Add(new tblCusContact { CusId = cc.CusId, ContactId = cc.ContactId, ContactName = cc.ContactName, ContactPhoneH = cc.ContactPhoneH, ContactPhoneO = cc.ContactPhoneO, ContactPhoneM = cc.ContactPhoneM, ContactFax = cc.ContactFax, ContactEmail = cc.ContactEmail, EmId = cc.EmId, AddPerson = cc.AddPerson, Department = cc.Department }); ctx.SaveChanges(); } }
// PUT api/CRMCusContact?CusId,ContactId,tblCuscontact public void Put(string CusId, string ContactId, [FromBody] tblCusContact cc) { using (var ctx = new CRMModel()) { // Update Statement var update = ctx.tblCusContacts.Where(ci => ci.CusId == CusId).FirstOrDefault(); if (update != null) { update.CusId = cc.CusId; update.ContactId = cc.ContactId; update.ContactName = cc.ContactName; update.ContactPhoneH = cc.ContactPhoneH; update.ContactPhoneO = cc.ContactPhoneO; update.ContactPhoneM = cc.ContactPhoneM; update.ContactFax = cc.ContactFax; update.ContactEmail = cc.ContactEmail; update.EmId = cc.EmId; update.AddPerson = cc.AddPerson; update.Department = cc.Department; } ctx.SaveChanges(); } }