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