private bool SendEmail(EmailIdDTO emailIds, EventMessageDTO EventMessage, string UpdatedMessage)
{
SMTPDTO projectSTMPDetails = GetSMTPDetails();
if (projectSTMPDetails == null)
{
return(false);
}
SMTPDTO smtpDTO = new SMTPDTO();
smtpDTO.SMTPUserId = projectSTMPDetails.SMTPUserId;
smtpDTO.SMTPPassword = projectSTMPDetails.SMTPPassword;
smtpDTO.SMTPServer = projectSTMPDetails.SMTPServer;
smtpDTO.Port = projectSTMPDetails.Port;
smtpDTO.FromEmailId = projectSTMPDetails.FromEmailId;
smtpDTO.ReplyToId = projectSTMPDetails.ReplyToId;
smtpDTO.FromDisplayName = projectSTMPDetails.FromDisplayName;
EmailDTO emailDTO = new EmailDTO();
emailDTO.To = emailIds.TOs;
emailDTO.CC = emailIds.CCs;
emailDTO.BCC = emailIds.BCCs;
emailDTO.Body = UpdatedMessage;
emailDTO.Subject = EventMessage.EventSubject;
EMailHelper emailHelper = new EMailHelper(smtpDTO);
emailHelper.SendEmail(emailDTO);
return(true);
}
public bool Delete(SMTPDTO SMTPDTO)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_SMTPMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@SMTPID", DbType.String, SMTPDTO.SMTPId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsSMTPMaster.Delete", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool Update(SMTPDTO oSMTPData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_SMTPMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@SMTPID", DbType.String, oSMTPData.SMTPId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@SMTPServer", DbType.String, oSMTPData.SMTPServer);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@FromId", DbType.String, oSMTPData.FromEmailId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ReplyToId", DbType.String, oSMTPData.ReplyToId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@FromDisplayName", DbType.String, oSMTPData.FromDisplayName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@UserId", DbType.String, oSMTPData.SMTPUserId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Password", DbType.String, oSMTPData.SMTPPassword);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Port", DbType.Int32, oSMTPData.Port);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Active", DbType.Boolean, oSMTPData.Active);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsSMTPMaster.Update", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
private void Delete()
{
int Id = 0;
bool bActionCompleted;
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Delete))
{
return;
}
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit again.";
return;
}
if (txtSMTPServer.Text.Trim() == "")
{
lblStatus.Text = "Please enter the SMTP server.";
return;
}
SMTPMaster oSMTPMaster = new SMTPMaster();
SMTPDTO oSMTPData = MapControlsToObject();
/*
*
* CHECK IF THE MailDetails WHICH IS TO BE DELETED HAS ANY ASSOCIATED RECORDS...IF YES, MOVE OUT OF THE FUNCTION ELSE PROCEED
* IF THE OUTPUT OF sMessage IS "", THEN RECORD CAN BE DELETED, ELSE NOT
*
*/
string sMessage = "";
GF.HasRecords(Convert.ToString(Id), "MailDetails", out sMessage);
if (sMessage != "")
{
base.DisplayAlert(sMessage);
btnDelete.Enabled = true;
}
else
{
bActionCompleted = oSMTPMaster.Delete(oSMTPData);
if (bActionCompleted == true)
{
ClearPageControls();
RefreshGrid();
oSMTPData = null;
oSMTPMaster = null;
//lblStatus.Text = "Deleted";
base.DisplayAlert("The record has been deleted successfully.");
}
else
{
base.DisplayAlert("Error Occured while deletion: Please refer to the error log.");
}
//lblStatus.Text = "Error Occured while deletion: Please refer to the error log.";
}
}
protected void dgMailDetailss_DeleteCommand(object source, DataGridCommandEventArgs e)
{
int iSMTPID = Convert.ToInt32(dgMailServerDetails.DataKeys[e.Item.ItemIndex].ToString());
SMTPMaster oSMTPMaster = new SMTPMaster();
SMTPDTO oSMTPData = new SMTPDTO();
oSMTPData.SMTPId = iSMTPID;
oSMTPMaster.Delete(oSMTPData);
ClearPageControls();
RefreshGrid();
oSMTPData = null;
oSMTPMaster = null;
}
private SMTPDTO MapControlsToObject()
{
int Id = 0;
int.TryParse(hfId.Value, out Id);
SMTPDTO oSMTPData = new SMTPDTO();
oSMTPData.SMTPId = Id;
oSMTPData.SMTPServer = txtSMTPServer.Text;
oSMTPData.FromDisplayName = txtFromDisplayName.Text;
oSMTPData.FromEmailId = txtFromId.Text;
oSMTPData.SMTPPassword = txtPassword.Text;
oSMTPData.Port = Convert.ToInt32(txtPort.Text);
oSMTPData.ReplyToId = txtReplyToId.Text;
oSMTPData.SMTPUserId = txtUserId.Text;
oSMTPData.Active = chkActive.Checked;
return(oSMTPData);
}
private void Save()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add))
{
return;
}
bool bActionCompleted;
SMTPMaster oSMTPMaster = new SMTPMaster();
SMTPDTO oSMTPData = MapControlsToObject();
bActionCompleted = oSMTPMaster.Insert(oSMTPData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been inserted successfully");
ClearPageControls();
}
else
{
lblStatus.Text = "Error Occured while insertion: Please refer to the error log.";
}
}
private void Update()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update))
{
return;
}
bool bActionCompleted;
if (ValidateValues() == false)
{
return;
}
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit again.";
return;
}
SMTPMaster oSMTPMaster = new SMTPMaster();
SMTPDTO oSMTPData = MapControlsToObject();
bActionCompleted = oSMTPMaster.Update(oSMTPData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been updated successfully");
ClearPageControls();
}
else
{
lblStatus.Text = "Error Occured while updation: Please refer to the error log.";
}
}
public EMailHelper(SMTPDTO SMTPDetails)
{
emailHandler = new EMailHandler(SMTPDetails);
}
public SMTPDTO[] GetSMTPDetails(int SMTPId, bool Active)
{
DataSet ds;
SMTPDTO[] SMTPData;
SMTPData = null;
ds = null;
string sProcName;
DatabaseManager oDB;
DataRow dr;
try
{
oDB = new DatabaseManager();
sProcName = "up_Get_SMTPDetails";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@SMTPID", DbType.Int32, SMTPId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Active", DbType.Int32, Active);
ds = oDB.ExecuteDataSet(oDB.DbCmd);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
SMTPData = new SMTPDTO[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
SMTPData[i] = new SMTPDTO();
dr = ds.Tables[0].Rows[i];
if (dr[0] != DBNull.Value)
{
SMTPData[i].SMTPId = Convert.ToInt32(dr[0].ToString());
}
if (dr[1] != DBNull.Value)
{
SMTPData[i].SMTPServer = Convert.ToString(dr[1].ToString());
}
if (dr[2] != DBNull.Value)
{
SMTPData[i].FromEmailId = Convert.ToString(dr[2].ToString());
}
if (dr[3] != DBNull.Value)
{
SMTPData[i].ReplyToId = Convert.ToString(dr[3].ToString());
}
if (dr[4] != DBNull.Value)
{
SMTPData[i].FromDisplayName = Convert.ToString(dr[4].ToString());
}
if (dr[5] != DBNull.Value)
{
SMTPData[i].SMTPUserId = Convert.ToString(dr[5].ToString());
}
if (dr[6] != DBNull.Value)
{
SMTPData[i].SMTPPassword = Convert.ToString(dr[6].ToString());
}
if (dr[7] != DBNull.Value)
{
SMTPData[i].Port = Convert.ToInt32(dr[7].ToString());
}
if (dr[8] != DBNull.Value)
{
SMTPData[i].Active = Convert.ToBoolean(dr[8].ToString());
}
}
}
}
catch (Exception exp)
{
GF.LogError("clsSMTPMaster.GetSMTP", exp.Message.ToString());
oDB = null;
return(null);
}
finally
{
oDB = null;
}
// return oCombinedAccomData;
return(SMTPData);
}
public SMTPSolution(SMTPDTO SMTPDetails)
{
objSMTP = SMTPDetails;
}
public EMailHandler(SMTPDTO SMTPDetails)
{
_SMTPDetails = SMTPDetails;
}
