/// <summary>
/// Save Email
/// </summary>
/// <returns></returns>
public string SaveEmail(AcceptEmail email, string userUuid, out long emailId)
{
using (itjob_mainEntities db = new itjob_mainEntities())
{
tbl_company_has_accept_email tblModel = new tbl_company_has_accept_email()
{
id = 0,
company_id = email.CompanyId,
accept_email = email.EmailAddress,
system_comment = "Save",
added_by = userUuid,
update_by = userUuid,
added_date = DateTime.Now,
update_date = DateTime.Now,
is_active = true,
};
db.tbl_company_has_accept_email.Add(tblModel);
try
{
db.SaveChanges();
emailId = tblModel.id;
return(null);
}
catch (Exception ex)
{
emailId = 0;
return(ex.Message.ToString());
}
}
}
/// <summary>
/// Save Email
/// </summary>
/// <returns></returns>
public string EditEmail(AcceptEmail email, string userUuid)
{
using (itjob_mainEntities db = new itjob_mainEntities())
{
var dbobj = db.tbl_company_has_accept_email.Where(d => d.id == email.AcceptEmailId).FirstOrDefault();
if (dbobj == null)
{
return("Table is empty");
}
dbobj.company_id = email.CompanyId;
dbobj.accept_email = email.EmailAddress;
dbobj.update_by = userUuid;
dbobj.system_comment = "Update";
dbobj.update_date = DateTime.Now;
db.Entry(dbobj).State = EntityState.Modified;
try
{
db.SaveChanges();
return(null);
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
}
/// <summary>
/// Save Email
/// </summary>
/// <returns></returns>
public string SaveEmail(AcceptEmail email, string userUuid, out long emailIds)
{
var error = _emailRepo.SaveEmail(email, userUuid, out long emailId);
emailIds = emailId;
return(error);
}
/// <summary>
/// Save Email
/// </summary>
/// <returns></returns>
public string EditEmail(AcceptEmail email, string userUuid)
{
return(_emailRepo.EditEmail(email, userUuid));
}
