public int Insert_EmailConfiguration(EmailBE.EmailConfigurationBE _objBE) { try { EmailConfiguration _ObjEmail = new EmailConfiguration(); _ObjEmail.eC_SMTPServerName = _objBE.eC_SMTPServerName; _ObjEmail.eC_UserName = _objBE.eC_UserName; _ObjEmail.eC_Password = _objBE.eC_Password; _ObjEmail.eC_SMTPPort = _objBE.eC_SMTPPort; _ObjEmail.eC_IsSSLEnabled = _objBE.eC_IsSSLEnabled; _ObjEmail.CompanyId = _objBE.CompanyId; _ObjEmail.LocationId = _objBE.LocationId; _ObjEmail.eC_status = true; _ObjEmail.eC_IsDefault = _objBE.eC_IsDefault; _ObjEmail.eC_IsActive = _objBE.eC_IsActive; _ObjEmail.eC_signature = _objBE.eC_signature; _ObjEmail.eC_Pop3Server = _objBE.eC_Pop3Server; _ObjEmail.ec_Pop3Portno = _objBE.ec_Pop3Portno; _ObjEmail.DisplayName = _objBE.DisplayName; _ObjEmail.AddedBy = _objBE.AddedBy; _ObjEmail.AddedOn = DateTime.Now; _ObjEmail.eC_signature = ""; _ObjEmail.LastModifiedBy = null; _ObjEmail.LastModifiedOn = null; _ObjEmailEntity.AddToEmailConfigurations(_ObjEmail); _ObjEmailEntity.SaveChanges(); return(_ObjEmail.eC_Id); } catch (Exception ex) { return(0); } }
public int Update_EmailConfiguration(EmailBE.EmailConfigurationBE _objBE) { EmailConfiguration _ObjEmail = _ObjEmailEntity.EmailConfigurations.Where(x => x.eC_Id == _objBE.eC_Id).FirstOrDefault(); _ObjEmail.eC_SMTPServerName = _objBE.eC_SMTPServerName; _ObjEmail.eC_UserName = _objBE.eC_UserName; _ObjEmail.eC_Password = _objBE.eC_Password; _ObjEmail.eC_SMTPPort = _objBE.eC_SMTPPort; _ObjEmail.eC_IsSSLEnabled = _objBE.eC_IsSSLEnabled; _ObjEmail.CompanyId = _objBE.CompanyId; _ObjEmail.LocationId = _objBE.LocationId; _ObjEmail.eC_status = true; _ObjEmail.eC_IsDefault = _objBE.eC_IsDefault; _ObjEmail.eC_IsActive = _objBE.eC_IsActive; _ObjEmail.eC_signature = _objBE.eC_signature; _ObjEmail.eC_Pop3Server = _objBE.eC_Pop3Server; _ObjEmail.ec_Pop3Portno = _objBE.ec_Pop3Portno; _ObjEmail.DisplayName = _objBE.DisplayName; _ObjEmail.LastModifiedBy = _objBE.ModifyBy; _ObjEmail.LastModifiedOn = _objBE.LastModifiedOn; _ObjEmailEntity.SaveChanges(); return(_ObjEmail.eC_Id); }
public long InsertUpdateEmailConfigDetails(EmailBE.EmailConfigurationBE _objEmailBE) { try { long returnValue = 0; SqlParameter ParamEmailId = new SqlParameter("@eC_Id", SqlDbType.Int); ParamEmailId.Value = _objEmailBE.eC_Id; SqlParameter ParameSMTPServerName = new SqlParameter("@eC_SMTPServerName", SqlDbType.NVarChar); ParameSMTPServerName.Value = _objEmailBE.eC_SMTPServerName; SqlParameter ParamUserName = new SqlParameter("@eC_UserName", SqlDbType.NVarChar); ParamUserName.Value = _objEmailBE.eC_UserName; SqlParameter ParamPassword = new SqlParameter("@eC_Password", SqlDbType.NVarChar); ParamPassword.Value = _objEmailBE.eC_Password; SqlParameter ParamSMTPPort = new SqlParameter("@eC_SMTPPort", SqlDbType.Int); ParamSMTPPort.Value = _objEmailBE.eC_SMTPPort; SqlParameter ParamIsSSLEnabled = new SqlParameter("@eC_IsSSLEnabled", SqlDbType.Bit); ParamIsSSLEnabled.Value = _objEmailBE.eC_IsSSLEnabled; SqlParameter ParamCompanyId = new SqlParameter("@CompanyId", SqlDbType.Int); ParamCompanyId.Value = _objEmailBE.CompanyId; SqlParameter ParamLocationId = new SqlParameter("@LocationId", SqlDbType.Int); ParamLocationId.Value = _objEmailBE.LocationId; SqlParameter ParamIsDefault = new SqlParameter("@eC_IsDefault", SqlDbType.Bit); ParamIsDefault.Value = _objEmailBE.eC_IsDefault; SqlParameter ParamIsActive = new SqlParameter("@eC_IsActive", SqlDbType.Bit); ParamIsActive.Value = _objEmailBE.eC_IsActive; SqlParameter ParamDisplayName = new SqlParameter("@DisplayName", SqlDbType.NVarChar); ParamDisplayName.Value = _objEmailBE.DisplayName; SqlParameter ParamPop3Server = new SqlParameter("@eC_Pop3Server", SqlDbType.NVarChar); ParamPop3Server.Value = _objEmailBE.eC_Pop3Server; SqlParameter ParamAddedBy = new SqlParameter("@AddedBy", SqlDbType.NVarChar); ParamAddedBy.Value = _objEmailBE.AddedBy; SqlParameter ParamModifyBy = new SqlParameter("@LastModifiedBy", SqlDbType.NVarChar); ParamModifyBy.Value = _objEmailBE.ModifyBy; SqlParameter ParamPop3Portno = new SqlParameter("@ec_Pop3Portno", SqlDbType.Int); ParamPop3Portno.Value = _objEmailBE.ec_Pop3Portno; SqlParameter paramSuccess = new SqlParameter("@success", SqlDbType.Bit); paramSuccess.Value = 0; paramSuccess.Direction = ParameterDirection.Output; SqlParameter[] _parameter = { ParamEmailId, ParameSMTPServerName, ParamUserName, ParamPassword, ParamSMTPPort, ParamIsSSLEnabled, ParamCompanyId, ParamLocationId, ParamIsDefault, ParamIsActive, ParamDisplayName, ParamPop3Server, ParamAddedBy, ParamModifyBy, ParamPop3Portno, paramSuccess }; returnValue = _objComDL.executeReturnLongNonSelectQuery("EINSPRO_EMAIL.[dbo].Isp_EmailConfiguration", _parameter); return(returnValue); } catch { return(0); } }
public long Update_EmailConfiguration(EmailBE.EmailConfigurationBE _objEmailBE) { return(_objEmailDL.Update_EmailConfiguration(_objEmailBE)); }
public long Insert_EmailConfiguration(EmailBE.EmailConfigurationBE _objEmailBE) { return(_objEmailDL.Insert_EmailConfiguration(_objEmailBE)); }