//for delete public void AgentMessageDelete(int AgentMessageId) { Core_AgentMessages result = ent.Core_AgentMessages.Where(x => x.AgentMessageId == AgentMessageId).FirstOrDefault(); ent.DeleteObject(result); ent.SaveChanges(); }
//for adding into AgentMessage Table public void AgentMessageAdd(AgentMessagesModel modelToSave) { Core_AgentMessages datamodel = new Core_AgentMessages() { AgentId = modelToSave.AgentId, ProductId = modelToSave.Productid, MessageText = modelToSave.MessageText, CreatedBy = 1, CreatedDate = DateTime.Now }; ent.AddToCore_AgentMessages(datamodel); ent.SaveChanges(); }
//for edit public void AgentMessageEdit(AgentMessagesModel model) { Core_AgentMessages result = ent.Core_AgentMessages.Where(x => x.AgentMessageId == model.AgentMessageId).FirstOrDefault(); result.AgentMessageId = model.AgentMessageId; result.AgentId = model.AgentId; result.ProductId = model.Productid; result.MessageText = model.MessageText; result.UpdatedBy = 1; result.UpdatedDate = DateTime.Now; ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result); ent.SaveChanges(); }
public AgentMessagesModel GetAgentMessageDetail(int AgentMessageId) { Core_AgentMessages result = ent.Core_AgentMessages.Where(x => x.AgentMessageId == AgentMessageId).FirstOrDefault(); AgentMessagesModel model = new AgentMessagesModel(); model.AgentMessageId = result.AgentMessageId; model.AgentId = result.AgentId; model.Productid = result.ProductId; model.MessageText = result.MessageText; model.CreatedDate = result.CreatedDate; model.CreatedBy = result.CreatedBy; model.AgentName = result.Agents.AgentName; model.ProductName = result.Core_Products.ProductName; return(model); }