//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);
}
