/// <summary>
/// To fetch and assign direction message to label
/// </summary>
private void GetTooltip()
{
WIS_ConfigBO WIS_ConfigBOobj = new WIS_ConfigBO();
WIS_ConfigBLL WIS_ConfigBLLobj = new WIS_ConfigBLL();
WIS_ConfigBOobj = WIS_ConfigBLLobj.getConfiguration("GENERAL_DIRECTION_DETAILS");
if (WIS_ConfigBOobj != null)
{
lblDirectionMessage.Text = WIS_ConfigBOobj.ConfigData;
}
}
/// <summary>
/// Get Build Version
/// </summary>
private void getBuildVersion()
{
WIS_ConfigBO WIS_ConfigBO = new WIS_ConfigBO();
WIS_ConfigBLL WIS_ConfigBLL = new WIS_ConfigBLL();
WIS_ConfigBO = WIS_ConfigBLL.getBuildVersion();
if (WIS_ConfigBO != null)
{
lblVersionBuild.Text = WIS_ConfigBO.BUILDVERSION.ToString();
lblDataVersion.Text = WIS_ConfigBO.BUILDDATE.ToString().Trim();
lblCopyright.Text = WIS_ConfigBO.BUILDCOPY.ToString().Trim();
}
}
/// <summary>
/// To Map Data
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private WIS_ConfigBO MapData(IDataReader reader)
{
WIS_ConfigBO oWIS_ConfigBO = new WIS_ConfigBO();
if (ColumnExists(reader, "ConfigItem") && !reader.IsDBNull(reader.GetOrdinal("ConfigItem")))
{
oWIS_ConfigBO.ConfigItem = reader.GetString(reader.GetOrdinal("ConfigItem"));
}
if (ColumnExists(reader, "ConfigData") && !reader.IsDBNull(reader.GetOrdinal("ConfigData")))
{
oWIS_ConfigBO.ConfigData = reader.GetString(reader.GetOrdinal("ConfigData"));
}
return(oWIS_ConfigBO);
}
/// <summary>
/// Get Round Off Limit
/// </summary>
/// <param name="SearchValue"></param>
/// <returns></returns>
public string getRoundOffLimit(string SearchValue)
{
WIS_ConfigBO oWIS_ConfigBO;
try
{
oWIS_ConfigBO = new WIS_ConfigBO();
oWIS_ConfigBO = getConfiguration(SearchValue);
}
catch (Exception ex)
{
throw ex;
}
return(oWIS_ConfigBO.ConfigData);
}
/// <summary>
/// To Get Config SMS sending status
/// </summary>
/// <returns></returns>
public WIS_ConfigBO GetConfigSMSsending()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_SEL_SMS_CONFIG";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
WIS_ConfigBO WIS_ConfigSMSBO = null;
// EmailTemplateList EmailTemplateListobj = new EmailTemplateList();
while (dr.Read())
{
WIS_ConfigSMSBO = new WIS_ConfigBO();
if (!dr.IsDBNull(dr.GetOrdinal("RegMobileNumber")))
{
WIS_ConfigSMSBO.MobileNumber = (dr.GetString(dr.GetOrdinal("RegMobileNumber")));
}
if (!dr.IsDBNull(dr.GetOrdinal("RegMobilePassword")))
{
WIS_ConfigSMSBO.MobilePassword = (dr.GetString(dr.GetOrdinal("RegMobilePassword")));
}
if (!dr.IsDBNull(dr.GetOrdinal("RegSiteUrl")))
{
WIS_ConfigSMSBO.SiteUrl = (dr.GetString(dr.GetOrdinal("RegSiteUrl")));
}
if (!dr.IsDBNull(dr.GetOrdinal("RegMobileStatus")))
{
WIS_ConfigSMSBO.MobileStatus = (dr.GetString(dr.GetOrdinal("RegMobileStatus")));
}
//EmailTemplateListobj.Add(WIS_ConfigSMSBO);
}
dr.Close();
return(WIS_ConfigSMSBO);
}
/// <summary>
/// To Get Build Version
/// </summary>
/// <returns></returns>
public WIS_ConfigBO getBuildVersion()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_GET_BUILD_CONFIG";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
WIS_ConfigBO WIS_ConfigBuildBO = null;
// EmailTemplateList EmailTemplateListobj = new EmailTemplateList();
while (dr.Read())
{
WIS_ConfigBuildBO = new WIS_ConfigBO();
if (!dr.IsDBNull(dr.GetOrdinal("BUILDVERSION")))
{
WIS_ConfigBuildBO.BUILDVERSION = (dr.GetString(dr.GetOrdinal("BUILDVERSION")));
}
if (!dr.IsDBNull(dr.GetOrdinal("BUILDDATE")))
{
WIS_ConfigBuildBO.BUILDDATE = (dr.GetString(dr.GetOrdinal("BUILDDATE")));
}
if (!dr.IsDBNull(dr.GetOrdinal("BUILDCOPY")))
{
WIS_ConfigBuildBO.BUILDCOPY = (dr.GetString(dr.GetOrdinal("BUILDCOPY")));
}
}
dr.Close();
return(WIS_ConfigBuildBO);
}
/// <summary>
/// To Get Serial Number
/// </summary>
/// <param name="CONFIGITEM"></param>
/// <returns></returns>
public WIS_ConfigBO GetSerialNumber(string CONFIGITEM)
{
proc = "USP_RPT_UPD_SERIALNO";
cnn = new OracleConnection(con);
WIS_ConfigBO oWIS_ConfigBO = null;
WIS_ConfigList lstWIS_Config = new WIS_ConfigList();
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("CONFIGITEM_", CONFIGITEM);
// cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oWIS_ConfigBO = new WIS_ConfigBO();
oWIS_ConfigBO = MapData(dr);
// lstWIS_Config.Add(oWIS_ConfigBO);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(oWIS_ConfigBO);
}
/// <summary>
/// To Get Configuration
/// </summary>
/// <param name="SearchValue"></param>
/// <returns></returns>
public WIS_ConfigBO getConfiguration(string SearchValue)
{
proc = "USP_GET_WIS_CONFIGURATION";
cnn = new OracleConnection(con);
WIS_ConfigBO oWIS_ConfigBO = null;
WIS_ConfigList lstWIS_Config = new WIS_ConfigList();
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("ConfigItem_", SearchValue);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oWIS_ConfigBO = new WIS_ConfigBO();
oWIS_ConfigBO = MapData(dr);
// lstWIS_Config.Add(oWIS_ConfigBO);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(oWIS_ConfigBO);
}
/// <summary>
/// To send route approval notification
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ApproverButton_Click(object sender, EventArgs e)
{
string ResultValue = string.Empty;
string message = string.Empty;
string WorkFlowCode = UtilBO.WorkflowRouteApproval;
string emailSubject = string.Empty;
string emailBody = string.Empty;
ProjectRouteBO objProjectRoute = new ProjectRouteBO();
ProjectRouteBLL objProjectRouteBLL = new ProjectRouteBLL();
ProjectRouteList objProjectRouteList = new ProjectRouteList();
objProjectRoute.WorkFlowApprover = UtilBO.WorkflowRouteApproval;
objProjectRoute.Project_Id = Convert.ToInt32(Session["PROJECT_ID"]);
objProjectRoute = objProjectRouteBLL.getWOrkFlowApprovalID(objProjectRoute);
if ((objProjectRoute) != null)
{
(new NotificationBLL()).SendEmail(Convert.ToInt32(Session["PROJECT_ID"]), UtilBO.WorkflowRouteApproval);
#region for sending SMS
WIS_ConfigBO WIS_ConfigBO = new WIS_ConfigBO();
WIS_ConfigBLL WIS_ConfigBLL = new WIS_ConfigBLL();
WIS_ConfigBO = WIS_ConfigBLL.GetConfigSMSsending();
if (WIS_ConfigBO != null)
{
if (WIS_ConfigBO.MobileStatus == "Y")
{
string Result = string.Empty;
string SendsmsTest = objProjectRoute.SmsText + objProjectRoute.ProjectCode + objProjectRoute.ProjectName;
NotificationBO SMSNotificationBO = new NotificationBO();
NotificationBLL SMSNotificationBLL = new NotificationBLL();
SMSNotificationBO.ProviderMobileNo = WIS_ConfigBO.MobileNumber;
SMSNotificationBO.ProviderPasword = WIS_ConfigBO.MobilePassword;
SMSNotificationBO.ProviderURL = WIS_ConfigBO.SiteUrl;
SMSNotificationBO.CellNumber = objProjectRoute.CellNumber;
SMSNotificationBO.SmsText = SendsmsTest;
Result = SMSNotificationBLL.SENDSMS(SMSNotificationBO);
}
}
#endregion
//NotificationObj.SendEmail(objProjectRoute.EmailID, objProjectRoute.EmailSubject, objProjectRoute.EmailBody, objProjectRoute.ProjectCode, objProjectRoute.ProjectName);
//ResultValue = NotificationObj.SendSMS(objProjectRoute.CellNumber, objProjectRoute.SmsText, objProjectRoute.ProjectCode, objProjectRoute.ProjectName);
ProjectRouteBO objApprovalHeaderSave = new ProjectRouteBO();
objApprovalHeaderSave.WorkFlowApproverID = objProjectRoute.WorkFlowApproverID;
objApprovalHeaderSave.StatusID = objProjectRoute.StatusID;
objApprovalHeaderSave.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
objApprovalHeaderSave.PageCode = "RTA";
objApprovalHeaderSave.ApproverUserID = objProjectRoute.ApproverUserID;
objApprovalHeaderSave.WorkFlowDefinitionID = objProjectRoute.WorkFlowDefinitionID;
#region email formate
switch (WorkFlowCode)
{
case "RTA":
emailSubject = string.Format("{0} {1}", objProjectRoute.EmailSubject, objProjectRoute.ProjectName);
//emailBody = emailBody.Replace("@@PROJECTNAME", objProjectRoute.EmailBody);
emailBody = objProjectRoute.EmailBody.Replace("@@PROJECTNAME", objProjectRoute.ProjectName);
break;
default:
emailSubject = objProjectRoute.EmailSubject;
break;
}
string approverName = objProjectRoute.ApproverUserName;
StringBuilder sb = new StringBuilder();
sb.Append("Dear " + approverName + ",");
sb.Append("<br/><br/>");
sb.Append(emailBody);
sb.Append("<br/><br/>");
sb.Append("Thanks and Regards,");
sb.Append("<br/>");
sb.Append("WIS - UETCL Team");
#endregion
objApprovalHeaderSave.EmailSubject = emailSubject;
objApprovalHeaderSave.EmailBody = sb.ToString();
message = objProjectRouteBLL.AddApprovalTrackheader(objApprovalHeaderSave);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Route Approval Notification has been sent";
}
if (message != "")
{
int ProjectId = Convert.ToInt32(Session["PROJECT_ID"]);
findRouteStatusafterSave(ProjectId);
getFinalRouteApprovalDetial(ProjectId);
GetApproavlComments();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
ApproverButton.Visible = false;
}
}
else
{
message = "Route Approver is not defined";
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
findRouteStatusafterSave(Convert.ToInt32(Session["PROJECT_ID"]));
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
//Application.Run(new Form1());
EmailTemplateBLL EmailTemplateBLLobj = new EmailTemplateBLL();
EmailTemplateList EmailTemplateListObj = EmailTemplateBLLobj.GetAllOverdueApprovals();
int a = 0;
if (EmailTemplateBLLobj != null)
{
for (int i = 0; i < EmailTemplateListObj.Count; i++)
{
try
{
string fileLoc = ConfigurationManager.AppSettings["ERROS_PATH"].ToString();
FileStream fs = null;
if (!File.Exists(fileLoc))
{
using (fs = File.Create(fileLoc))
{
}
}
MailMessage mailMessage = new MailMessage();
SmtpClient smtp = new SmtpClient();
if (EmailTemplateListObj[i].Triggertype.ToUpper() == "SMS" || EmailTemplateListObj[i].Triggertype.ToUpper() == "BOTH")
{
EmailTemplateBO EmailTemplateBOobj = EmailTemplateBLLobj.GetSMSDetailsForOverDue(EmailTemplateListObj[i].Workflowcode);
if (EmailTemplateBOobj != null)
{
WIS_ConfigBO WIS_ConfigBO = EmailTemplateBLLobj.GetSMSSenderDataForOverDue();
ReddyInfoSoft ris = new ReddyInfoSoft();
ris.sendSMS(WIS_ConfigBO.MobileNumber, WIS_ConfigBO.MobilePassword, EmailTemplateBOobj.Smstext, EmailTemplateListObj[i].Cellnumber, WIS_ConfigBO.SiteUrl, "1");
}
else
{
// for get errors
using (StreamWriter sw = new StreamWriter(fileLoc, true))
{
if (a == 0)
{
sw.WriteLine("[" + DateTime.Now.ToString() + "]" + Environment.NewLine);
a++;
}
sw.WriteLine(i + 1 + ") " + EmailTemplateListObj[i].Workflowcode.ToString() + " Does not contain SMS Text." + Environment.NewLine);
//sw.WriteLine(Environment.NewLine + "-------------------------------------------------------" + Environment.NewLine);
}
//end
}
}
if (EmailTemplateListObj[i].Triggertype.ToUpper() != "SMS")
{
string mailBody = "";
mailMessage.To.Add(EmailTemplateListObj[i].EmailID);
mailMessage.From = new MailAddress(ConfigurationManager.AppSettings["MAIL_FROM"].ToString());
EmailTemplateBO EmailTemplateBOobj = EmailTemplateBLLobj.GetEmailDetailsForOverDue(EmailTemplateListObj[i].Workflowcode);
if (EmailTemplateBOobj != null)
{
mailMessage.Subject = EmailTemplateBOobj.EmailSubject;
mailMessage.Body = "Dear Sir, <br/><br/> " + EmailTemplateBOobj.EmailBody + " <br/><br/> ProjectCode : " + EmailTemplateListObj[i].ProjectCode
+ "<br/> ProjectName : " + EmailTemplateListObj[i].ProjectName + "<br/>" +
"<br/> Requested Date : " + EmailTemplateListObj[i].Requestdate + "<br/>" +
"<br/> Due Date : " + EmailTemplateListObj[i].Duedate + "<br/><br/>" +
"Thanks and Regards, <br/> WIS - UETCL Team";
mailMessage.IsBodyHtml = true;
smtp.Send(mailMessage);
}
else
{
// for get errors
using (StreamWriter sw = new StreamWriter(fileLoc, true))
{
if (a == 0)
{
sw.WriteLine("[" + DateTime.Now.ToString() + "]" + Environment.NewLine);
a++;
}
sw.WriteLine(i + 1 + ") " + EmailTemplateListObj[i].Workflowcode.ToString() + " Does not contain Subject and Body." + Environment.NewLine);
//sw.WriteLine(Environment.NewLine + "-------------------------------------------------------" + Environment.NewLine);
}
//end
}
}
}
catch (Exception ex)
{
// for get errors
string fileLoc = ConfigurationManager.AppSettings["ERROS_PATH"].ToString();
FileStream fs = null;
if (!File.Exists(fileLoc))
{
using (fs = File.Create(fileLoc))
{
}
}
using (StreamWriter sw = new StreamWriter(fileLoc, true))
{
if (a == 0)
{
sw.WriteLine("[" + DateTime.Now.ToString() + "]" + Environment.NewLine);
a++;
}
sw.WriteLine(i + 1 + ") " + EmailTemplateListObj[i].Workflowcode.ToString() + "-" + ex.ToString());
//sw.WriteLine(Environment.NewLine + "-------------------------------------------------------" + Environment.NewLine);
}
//end
}
}
}
}
