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