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(EventMessageDTO oEventMessageData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_EventMessage";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iMessageId", DbType.Int32, oEventMessageData.MessageId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsEventMessage.Delete", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public bool Update(EventMessageDTO oEventMessageData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Upd_EventMessage";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@MessageId", DbType.String, oEventMessageData.MessageId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@EventName", DbType.String, oEventMessageData.EventName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@EventMessage", DbType.String, oEventMessageData.EventMessage);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@EventSubject", DbType.String, oEventMessageData.EventSubject);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@MailAllowed", DbType.Boolean, oEventMessageData.MailAllowed);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
GF.LogError("clsEventMessageMaster.Update", exp.Message.ToString());
oDB = null;
return(false);
}
finally
{
oDB = null;
}
return(true);
}
private void Delete()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Delete))
{
return;
}
if (ValidateValues() == false)
{
return;
}
bool bActionCompleted = false;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit button again.";
return;
}
EventMessageDTO oEventData = new EventMessageDTO();
oEventData.MessageId = Id;
EventMessageMaster oEventMaster = new EventMessageMaster();
/*
* ADDED BY VIJAY
* CHECK IF THE Event 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), "tblEmailMessageMaster", out sMessage);
if (sMessage != "")
{
base.DisplayAlert(sMessage);
btnDelete.Enabled = true;
}
else
{
bActionCompleted = oEventMaster.Delete(oEventData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been deleted successfully.");
txtEventName.Text = "";
//lblStatus.Text = "Deleted";
RefreshGrid();
}
else
{
base.DisplayAlert("Error Occured while deletion: Please refer to the error log.");
}
}
oEventData = null;
oEventMaster = null;
}
private EventMessageDTO[] GetEventMessage(int MessageId, string EventName)
{
DataSet ds;
EventMessageDTO[] EventMessageData;
EventMessageData = null;
ds = null;
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Get_EventMessageDetails";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iMessageId", DbType.Int32, MessageId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@EventName", DbType.String, EventName);
ds = oDB.ExecuteDataSet(oDB.DbCmd);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
EventMessageData = new EventMessageDTO[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
EventMessageData[i] = new EventMessageDTO();
//MessageId, EventName, EventMessage, EventSubject,
//EventMessageDefault, MailAllowed
EventMessageData[i].MessageId = Convert.ToInt32(ds.Tables[0].Rows[i][0].ToString());
EventMessageData[i].EventName = Convert.ToString(ds.Tables[0].Rows[i][1].ToString());
EventMessageData[i].EventMessage = Convert.ToString(ds.Tables[0].Rows[i][2].ToString());
EventMessageData[i].EventSubject = Convert.ToString(ds.Tables[0].Rows[i][3].ToString());
EventMessageData[i].EventMessageDefault = Convert.ToString(ds.Tables[0].Rows[i][4].ToString());
EventMessageData[i].MailAllowed = Convert.ToBoolean(ds.Tables[0].Rows[i][5].ToString());
}
}
}
catch (Exception exp)
{
GF.LogError("clsEventMessageMaster.GetEventMessage", exp.Message.ToString());
oDB = null;
return(null);
}
finally
{
oDB = null;
}
// return oCombinedAccomData;
return(EventMessageData);
}
private string PrepareMessageText(EventMessageDTO EventMessageDTO)
{
StringBuilder emailText = new StringBuilder();
emailText.Append(string.Empty);
//string HeaderStyle = "width:125; font-weight:bold";
emailText.Append("<table id=tblMessage style='font-size:12px'>");
#region Message Row
emailText.Append("<tr>");
emailText.Append("<td>" + EventMessageDTO.EventMessage + "</td>");
emailText.Append("</tr>");
#endregion
return(emailText.ToString());
}
private void Update()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update))
{
return;
}
if (ValidateValues() == false)
{
return;
}
bool bActionCompleted = false;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit button again.";
return;
}
EventMessageDTO oEventData = new EventMessageDTO();
oEventData.MessageId = Id;
oEventData.EventName = txtEventName.Text.ToString();
oEventData.EventMessage = txtEventMesssage.Text;
oEventData.EventSubject = txtEventSubject.Text;
oEventData.MailAllowed = chkAllowMails.Checked;
EventMessageMaster oEventMaster = new EventMessageMaster();
bActionCompleted = oEventMaster.Update(oEventData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been updated successfully");
txtEventName.Text = "";
lblStatus.Text = "Updated";
}
else
{
lblStatus.Text = "Error Occured while updation: Please refer to the error log.";
}
oEventData = null;
oEventMaster = null;
}
private void Save()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add))
{
return;
}
bool bActionCompleted = false;
EventMessageDTO oEventData = new EventMessageDTO();
oEventData.EventName = txtEventName.Text.ToString();
oEventData.EventMessage = txtEventMesssage.Text.ToString();
oEventData.EventSubject = txtEventSubject.Text.ToString();
oEventData.EventName = txtEventName.Text.ToString();
oEventData.EventMessageDefault = "";
if (chkAllowMails.Checked)
{
oEventData.MailAllowed = true;
}
else
{
oEventData.MailAllowed = false;
}
EventMessageMaster oEventMaster = new EventMessageMaster();
bActionCompleted = oEventMaster.Insert(oEventData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been inserted successfully");
txtEventName.Text = string.Empty;
txtEventName.Text = string.Empty;
txtEventMesssage.Text = string.Empty;
txtEventSubject.Text = string.Empty;
chkAllowMails.Checked = false;
lblStatus.Text = "Saved";
}
else
{
lblStatus.Text = "Error Occured while insertion: Please refer to the error log.";
}
oEventData = null;
oEventMaster = null;
}
