public DataSourceCommunicator GetDataBaseConnection()
{
try
{
DBServiceConfig objXmlConfig = new DBServiceConfig();
Exception ce = new Exception();
DBServiceConfig.LoadFromFile(ConstantStrings.ConfigXMLPath, out objXmlConfig, out ce);
DataSourceCommunicator dbget = null;
if (objXmlConfig != null)
{
DBName = objXmlConfig.DBName;
dbget = new DataSourceCommunicator(DataSourceCommunicator.ParamType.ServerCredentials, objXmlConfig.DBServer, objXmlConfig.DBUser, objXmlConfig.DBPassword);
ce = null;
}
return(dbget);
}
catch (System.Exception ex)
{
Program.log.Write("Scheduler - Error : " + ex.Message);
return(null);
}
}
private void ExecuteVendorOverDueRemainder()
{
try
{
string corporateid = string.Empty;
string facilityid = string.Empty;
string corporatename = string.Empty;
string facilityname = string.Empty;
string adminemailaddress = string.Empty;
string erroremailaddresss = string.Empty;
DataSourceCommunicator db = GetDataBaseConnection();
db.AddParameter("@LOGGEDINGBY", adminemailaddress);
DataSet ds = db.ExecuteStoredProcedureAsDataSet("GetVendorOrderdueRemainderFacilityList", DBName);
if (ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
corporateid = dr["corporateid"].ToString();
corporatename = dr["corporatename"].ToString();
facilityid = dr["facilityid"].ToString();
facilityname = dr["facilitydescription"].ToString();
try
{
ProcessVendorOverDueByFacility(corporateid, facilityid, corporatename, facilityname, adminemailaddress, erroremailaddresss);
}
catch (Exception ce)
{
Program.log.Write("Scheduler - Error : " + ce.Message);
}
}
}
}
catch (Exception ce)
{
Program.log.Write("Scheduler - Error start : " + ce.Message);
}
}
private void ProcessVendorOverDueByFacility(string corporateid, string facilityid, string corporatename, string facilityname, string adminemailaddress, string erroremailaddresss)
{
try
{
string ErrorMsg = string.Empty;
DataSourceCommunicator db = GetDataBaseConnection();
db.AddParameter("@CorporateID", corporateid);
db.AddParameter("@FacilityID", facilityid);
db.AddParameter("@Application", "Schedular");
db.AddParameter("@LOGGEDINGBY", 1);
EmailController objemail = new EmailController();
List <BALVendorOrderDue> VendorOrderDueList = new List <BALVendorOrderDue>();
DataSet ds = db.ExecuteStoredProcedureAsDataSet("GetVendorOrderdueRemainderReport", DBName);
foreach (DataTable dt in ds.Tables)
{
if (dt.Rows.Count > 0)
{
int i = 0;
foreach (DataRow dr in dt.Rows)
{
if (i < 1)
{
if (dr["FromEmailID"].ToString() == null || dr["FromEmailID"].ToString() == "" || dr["ToEmailID"].ToString() == null || dr["ToEmailID"].ToString() == "")
{
ErrorMsg = "No super admin assign to ";
Program.log.Write("Scheduler - Error : " + ErrorMsg + dr["FacilityDescription"].ToString() + " facility");
}
else
{
if (Int64.Parse(dr["VenOrderDueID"].ToString()) != 0)
{
objemail.vendorEmailcontent = dr["BodyContent1"].ToString() + dr["BodyContent2"].ToString() + "<div><br />Regards <br /> " + dr["BodyContent3"].ToString() + "</div>";
Program.log.Write("Vendor order due email sent to Tech Person[" + dr["ToEmailID"].ToString() + "] of this Corporate[" + corporatename + "] and Facility[" + dr["FacilityDescription"].ToString() + "]");
}
else
{
objemail.vendorEmailcontent = dr["BodyContent1"].ToString() + dr["BodyContent2"].ToString() + dr["BodyContent3"].ToString();
Program.log.Write("Notification email sent to Super Admin[" + dr["ToEmailID"].ToString() + "] to add tech role user for this Corporate[" + corporatename + "] and Facility[" + dr["FacilityDescription"].ToString() + "]");
}
objemail.vendoremailsubject = dr["SubjectContent"].ToString();
objemail.CorporateEmail = dr["FromEmailID"].ToString();
objemail.vendorContactEmail = dr["ToEmailID"].ToString();
}
if (ErrorMsg == "")
{
objemail.SendEmailTransferOut(objemail.CorporateEmail, objemail.vendorContactEmail, objemail.vendorEmailcontent, objemail.vendoremailsubject);
}
}
i++;
}
}
else
{
Program.log.Write("No Vendor due for this Corporate[" + corporatename + "] and Facility[" + facilityname + "] ");
}
}
}
catch (Exception ce)
{
Program.log.Write("Scheduler - Error End : " + ce.Message);
}
}