public SYS_Config SelectSYS_Config(int ID)
{
SYS_Config sys_config = new SYS_Config();
DbDataReader reader = null;
DbConnection connection = _DbHelper.CreateConnection(Common.ConnectionString);
connection.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false));
reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Config_SelectById]", para.ToArray());
if (reader.HasRows && reader.Read())
{
SYS_ConfigDataAccess.SetSYS_ConfigInfo(reader, ref sys_config);
}
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_ConfigDataAccess.SelectById: {0}", ex.Message));
}
finally
{
if (reader != null)
{
reader.Close();
}
connection.Open();
}
return(sys_config);
}
public static String SendEmail(string to_mail_address, string subject, string body, List <Attachment> the_attachments, string bcc)
{
try
{
LINQ_SystemDataContext dc = new LINQ_SystemDataContext();
SYS_Config the_config = (from c in dc.SYS_Configs select c).FirstOrDefault();
if (the_config == null)
{
return("Error: No Config.");
}
string Smtp_ClientValue = the_config.DefaultEmailClient;
string Smtp_Credential_Password = the_config.DefaultEmailPassword;
string Smtp_Credential_UserName = the_config.DefaultEmailAddress;
MailMessage mailObj = new MailMessage(Smtp_Credential_UserName, to_mail_address, subject, body);
if (!string.IsNullOrEmpty(bcc))
{
mailObj.Bcc.Add(bcc);
}
mailObj.Priority = MailPriority.High;
mailObj.BodyEncoding = System.Text.Encoding.UTF8;
if (the_attachments != null)
{
foreach (Attachment the_attachment in the_attachments)
{
mailObj.Attachments.Add(the_attachment);
}
}
mailObj.IsBodyHtml = true;
SmtpClient SMTPServer = new SmtpClient(Smtp_ClientValue);
SMTPServer.Port = 587;
SMTPServer.EnableSsl = true;
SMTPServer.Timeout = 10000;
SMTPServer.DeliveryMethod = SmtpDeliveryMethod.Network;
SMTPServer.UseDefaultCredentials = true;
SMTPServer.Credentials = new NetworkCredential(Smtp_Credential_UserName, Smtp_Credential_Password);
try
{
SMTPServer.Send(mailObj);
return("success");
}
catch (Exception ex)
{
return(ex.Message);
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
private static void SetListSYS_ConfigInfo(ref DbDataReader reader, ref List <SYS_Config> sys_configs)
{
SYS_Config sys_config = null;
while (reader.Read())
{
sys_config = new SYS_Config();
SYS_ConfigDataAccess.SetSYS_ConfigInfo(reader, ref sys_config);
sys_configs.Add(sys_config);
}
}
public void UpdateSYS_Config(DbTransaction transaction, SYS_Config sys_config)
{
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_config.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_config.Name, false));
para.Add(_DbHelper.CreateParameter(FIELD_VALUE, sys_config.Value, false));
_DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_Config_Update]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_ConfigDataAccess.Update: {0}", ex.Message));
}
}
public void DeleteSYS_Config(SYS_Config sys_config)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_config.ID, false));
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Config_Delete]", para.ToArray());
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
public int InsertSYS_Config(DbTransaction transaction, SYS_Config sys_config)
{
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_config.Name, false));
para.Add(_DbHelper.CreateParameter(FIELD_VALUE, sys_config.Value, false));
para.Add(ouput);
_DbHelper.ExecuteNonQuery(transaction, Common.DatabaseSchema + "[SYS_Config_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_ConfigDataAccess.Insert: {0}", ex.Message));
}
}
public int InsertSYS_Config(SYS_Config sys_config)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_config.Name, false));
para.Add(_DbHelper.CreateParameter(FIELD_VALUE, sys_config.Value, false));
para.Add(ouput);
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Config_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_ConfigDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public void UpdateSYS_Config(SYS_Config sys_config)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_config.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_config.Name, false));
para.Add(_DbHelper.CreateParameter(FIELD_VALUE, sys_config.Value, false));
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Config_Update]", para.ToArray());
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_ConfigDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public void DeleteSYS_Config(SYS_Config sys_configs)
{
_sys_configDataAccess.DeleteSYS_Config(sys_configs);
}
public void UpdateSYS_Config(SYS_Config sys_config)
{
_sys_configDataAccess.UpdateSYS_Config(sys_config);
}
public int InsertSYS_Config(SYS_Config sys_config)
{
return(_sys_configDataAccess.InsertSYS_Config(sys_config));
}
private static void SetSYS_ConfigInfo(DbDataReader reader, ref SYS_Config sys_config)
{
sys_config.ID = int.Parse("0" + reader[FIELD_ID]);
sys_config.Name = "" + reader[FIELD_NAME];
sys_config.Value = "" + reader[FIELD_VALUE];
}
public static String SendEmailToMultipleCC(List <string> to_mail_address_List, string subject, string body, List <Attachment> the_attachments, string bcc)
{
try
{
LINQ_SystemDataContext dc = new LINQ_SystemDataContext();
SYS_Config the_config = (from c in dc.SYS_Configs select c).FirstOrDefault();
if (the_config == null)
{
return("Error: No Config.");
}
string Smtp_ClientValue = the_config.DefaultEmailClient;
string Smtp_Credential_Password = the_config.DefaultEmailPassword;
string Smtp_Credential_from_UserName = the_config.DefaultEmailAddress;
MailMessage mailMessage = new MailMessage();
mailMessage.From = new MailAddress(Smtp_Credential_from_UserName); //From Email Id
mailMessage.Subject = subject; // //Subject of Email
mailMessage.Body = body; //body or message of Email
mailMessage.IsBodyHtml = true;
if (!string.IsNullOrEmpty(bcc))
{
mailMessage.Bcc.Add(bcc);
}
foreach (string CCEmail in to_mail_address_List)
{
mailMessage.CC.Add(new MailAddress(CCEmail)); //Adding Multiple CC email Id
}
mailMessage.Priority = MailPriority.High;
mailMessage.BodyEncoding = System.Text.Encoding.UTF8;
if (the_attachments != null)
{
foreach (Attachment the_attachment in the_attachments)
{
mailMessage.Attachments.Add(the_attachment);
}
}
SmtpClient SMTPServer = new SmtpClient(Smtp_ClientValue);
SMTPServer.Port = 587;
SMTPServer.EnableSsl = true;
SMTPServer.Timeout = 10000;
SMTPServer.DeliveryMethod = SmtpDeliveryMethod.Network;
SMTPServer.UseDefaultCredentials = true;
SMTPServer.Credentials = new NetworkCredential(Smtp_Credential_from_UserName, Smtp_Credential_Password);
try
{
SMTPServer.Send(mailMessage);
return("success");
}
catch (Exception ex)
{
return(ex.Message);
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
