public EmailEnablementBO getEmailEnablement(int TenantID, int EmailEnablementTypeID)
{
EmailEnablementBO emailEnablementBO = new EmailEnablementBO();
try
{
using (SqlConnection sqlCon = new SqlConnection(Constant.DBConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("Select * from stblEmailEnablement Where TenantID=@TenantID and EmailEnablementTypeID=@EmailEnablementTypeID", sqlCon);
{
sqlCmd.CommandType = CommandType.Text;
sqlCmd.Parameters.Add(new SqlParameter("@TenantID", TenantID));
sqlCmd.Parameters.Add(new SqlParameter("@EmailEnablementTypeID", EmailEnablementTypeID));
sqlCon.Open();
SqlDataReader reader = sqlCmd.ExecuteReader();
{
if (reader.HasRows)
{
while (reader.Read())
{
emailEnablementBO.EmailEnablementID = reader["EmailEnablementID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["EmailEnablementID"]);
emailEnablementBO.isToEndUser = reader["ToEndUser"] == DBNull.Value ? false : Convert.ToBoolean(reader["ToEndUser"]);
emailEnablementBO.isToTenant = reader["ToTenant"] == DBNull.Value ? false : Convert.ToBoolean(reader["ToTenant"]);
emailEnablementBO.ToTenantEmails = reader["ToTenantEmails"] == DBNull.Value ? String.Empty : Convert.ToString(reader["ToTenantEmails"]);
//emailEnablementBO.Add(new EmailEnablementBO()
//{
// EmailEnablementID = reader["EmailEnablementID"] == DBNull.Value?0: Convert.ToInt32(reader["EmailEnablementID"]),
// emailEnablementTypeBO=new EmailEnablementTypeBO() {
// EmailEnablementTypeID= reader["EmailEnablementtype"] == DBNull.Value ? 0 : Convert.ToInt32(reader["EmailEnablementtype"]),
// EmailEnablementType=reader["Type"]==DBNull.Value?String.Empty: Convert.ToString(reader["Type"]),
// EndUserTemplate= reader["EndUserTemplate"] == DBNull.Value ? String.Empty : Convert.ToString(reader["EndUserTemplate"]),
// },
// isToEndUser=reader["ToEndUser"]==DBNull.Value?false:Convert.ToBoolean(reader["ToEndUser"]),
// isToTenant= reader["ToEndUser"] == DBNull.Value ? false : Convert.ToBoolean(reader["ToEndUser"])
//});
}
}
reader.Close();
// reader = null;
sqlCon.Close();
}
}
}
}
catch (Exception ex)
{
_ErrMsg = ex.Message;
throw;
}
return(emailEnablementBO);
}
public List <EmailEnablementImplementationBO> emailEnableImplementation(int TenantID, int EmailEnablementTypeID)
{
List <EmailEnablementImplementationBO> emailEnableImplementationBO = new List <EmailEnablementImplementationBO>();
using (SqlConnection connect = new SqlConnection(_connectionString))
{
SqlCommand command = new SqlCommand("select * from svwEmailEnablement where TenantID = @TenantID and EmailEnablementTypeID = @EmailEnablementTypeID", connect);
{
command.Parameters.Add(new SqlParameter("@TenantID", TenantID));
command.Parameters.Add(new SqlParameter("@EmailEnablementTypeID", EmailEnablementTypeID));
command.CommandType = CommandType.Text;
connect.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
EmailEnablementBO ebo = new EmailEnablementBO();
EmailEnablementTypeBO ebto = new EmailEnablementTypeBO();
ebo.EmailEnablementID = reader["EmailEnablementID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["EmailEnablementID"]);
ebo.TenantID = reader["TenantID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["TenantID"]);
ebo.isToEndUser = reader["ToEndUser"] == DBNull.Value ? false : Convert.ToBoolean(reader["ToEndUser"]);
ebo.isToTenant = reader["ToTenant"] == DBNull.Value ? false : Convert.ToBoolean(reader["ToTenant"]);
ebo.ToTenantEmails = reader["ToTenantEmails"] == DBNull.Value ? string.Empty : Convert.ToString(reader["ToTenantEmails"]);
ebto.EmailEnablementTypeID = reader["EmailEnablementTypeID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["EmailEnablementTypeID"]);
ebto.EndUserTemplate = reader["EndUserTemplate"] == DBNull.Value ? string.Empty : Convert.ToString(reader["EndUserTemplate"]);
ebto.TenantTemplate = reader["TenantTemplate"] == DBNull.Value ? string.Empty : Convert.ToString(reader["TenantTemplate"]);
ebto.Status = reader["Status"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Status"]);
emailEnableImplementationBO.Add(new EmailEnablementImplementationBO
{
emailEnablementBO = ebo,
emailEnablementTypeBO = ebto,
type = reader["Type"] == DBNull.Value ? string.Empty : Convert.ToString(reader["Type"]),
});
}
}
reader.Close();
connect.Close();
}
}
return(emailEnableImplementationBO);
}
public int SaveEmailEnablement(EmailEnablementBO emailEnablementBO, int EmailEnablementTypeID, int TenantID)
{
int returnvalue = 0;
try
{
using (SqlConnection sqlCon = new SqlConnection(Constant.DBConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("sspSaveEmailEnablement", sqlCon);
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new SqlParameter("@EmailEnablementID", emailEnablementBO.EmailEnablementID));
sqlCmd.Parameters.Add(new SqlParameter("@EmailEnablementTypeID", EmailEnablementTypeID));
sqlCmd.Parameters.Add(new SqlParameter("@TenantID", TenantID));
sqlCmd.Parameters.Add(new SqlParameter("@ToEnduser", emailEnablementBO.isToEndUser));
sqlCmd.Parameters.Add(new SqlParameter("@ToTenant", emailEnablementBO.isToTenant));
sqlCmd.Parameters.Add(new SqlParameter("@ToTenantEmails", emailEnablementBO.ToTenantEmails));
sqlCon.Open();
SqlDataReader reader = sqlCmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
returnvalue = (reader[0] == DBNull.Value ? 0 : Convert.ToInt32(reader[0]));
}
}
reader.Close();
reader = null;
sqlCon.Close();
}
}
}
catch (Exception ex)
{
_ErrMsg = ex.Message;
throw;
}
return(returnvalue);
}
