public string InsertEmail(string Template, string MailFrom, string MailTo, string ResentCount, string SendingDate, string Subject, string Content, string MailCC, string SentStatus, string Record,Controller Ctrl) { string status = "Success"; DBEntities insertentity = new DBEntities(); BizTbl_MailQueue MsgObj = new BizTbl_MailQueue(); MsgObj.MailTemplateID = Convert.ToInt32(Template); MsgObj.MailFrom = MailFrom; MsgObj.MailTo = MailTo; MsgObj.MailCC = MailCC; MsgObj.Subject = Subject; MsgObj.Body = Content; MsgObj.IsSent = Convert.ToBoolean(SentStatus); if (ResentCount == "") { MsgObj.ResentCount = 0; } else { MsgObj.ResentCount = Convert.ToInt32(ResentCount); } MsgObj.SendingDateTime = DateTime.Now; if (Record == "") { MsgObj.RecordID = null; } else { MsgObj.RecordID = Convert.ToInt64(Record); } MsgObj.OpDateTime = DateTime.Now; MsgObj.OpUserID = Convert.ToInt64(Ctrl.Session["UserID"]); insertentity.BizTbl_MailQueue.Add(MsgObj); insertentity.SaveChanges(); return status; }
public bool Create(EmailExt model, ref string Msg, Controller ctrl) { bool status = true; DBEntities insertentity = new DBEntities(); BizTbl_MailQueue MsgObj = new BizTbl_MailQueue(); MsgObj.ID = model.ID; MsgObj.MailTemplateID = model.MailTemplateID; MsgObj.MailFrom = model.MailFrom; MsgObj.MailTo = model.MailTo; MsgObj.MailCC = model.MailCC; MsgObj.Subject = model.Subject; MsgObj.Body = model.Content; MsgObj.IsSent = Convert.ToBoolean(model.SentStatus); MsgObj.ResentCount = model.ResentCount; MsgObj.SendingDateTime = DateTime.Now; MsgObj.RecordID = Convert.ToInt64(model.Record); MsgObj.OpDateTime = DateTime.Now; MsgObj.OpUserID = Convert.ToInt64(ctrl.Session["UserID"]); insertentity.BizTbl_MailQueue.Add(MsgObj); insertentity.SaveChanges(); return status; }