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