/// <summary>
/// Handles the Click event of the ImageButtonExportToCSV control.
/// </summary>
/// <param name="sender">Source of the event.</param>
/// <param name="e">The <see cref="System.Web.UI.ImageClickEventArgs"/>Instance containing the event data.</param>
/// <remarks>
/// Sequence Diagram:<br/>
/// <img src="SequenceDiagrams/SD_PrintRoverWeb.Administration.ManageDBUploadUsers.ImageButtonExportToCsv_Click.jpg"/>
/// </remarks>
protected void ImageButtonExportToCsv_Click(object sender, ImageClickEventArgs e)
{
DataSet datasetReport = DataManager.Provider.MyBalance.ProvideAllMyBalance();
DataTable toExcel = datasetReport.Tables[0];
string filename = "AccountingPlus Manage My Balance";
HttpContext context = HttpContext.Current;
context.Response.Clear();
string columns = string.Empty;
string columnData = string.Empty;
foreach (DataColumn column in toExcel.Columns)
{
if (column.ColumnName == "RECHARGE_ID")
{
column.ColumnName = "Recharge ID";
}
if (column.ColumnName == "IS_RECHARGE")
{
column.ColumnName = "Is Recharge";
}
if (column.ColumnName == "AMOUNT")
{
column.ColumnName = "Amount";
}
columns += column.ColumnName + ",";
}
context.Response.Write(columns.Remove(columns.Length - 1, 1));
context.Response.Write(Environment.NewLine);
foreach (DataRow row in toExcel.Rows)
{
columnData = string.Empty;
for (int i = 0; i < toExcel.Columns.Count; i++)
{
if (i == 2)
{
if (row["AMOUNT"].ToString() != "")
{
row[i] = Protector.DecodeString(row["AMOUNT"].ToString());
}
else
{
row[i] = "";
}
}
columnData += row[i].ToString().Replace(",", string.Empty) + ",";
}
context.Response.Write(columnData.Remove(columnData.Length - 1, 1));
context.Response.Write(Environment.NewLine);
}
context.Response.ContentType = "template/csv";
context.Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + ".csv");
context.Response.End();
}
/// <summary>
/// Binds the sample users.
/// </summary>
/// <remarks>
/// Sequence Diagram:<br/>
/// <img src="SequenceDiagrams/SD_PrintRoverWeb.Administration.ManageDBUploadUsers.BindSampleUsers.jpg" />
/// </remarks>
private void BindMyBalance()
{
DataSet dsMyBalance = DataManager.Provider.MyBalance.ProvideMyBalance();
if (dsMyBalance.Tables[0].Rows.Count > 0)
{
for (int dsBalance = 0; dsBalance < dsMyBalance.Tables[0].Rows.Count; dsBalance++)
{
TableRow trBalance = new TableRow();
trBalance.CssClass = "GridRow";
trBalance.Attributes.Add("onMouseOver", "this.className='GridRowOnmouseOver'");
trBalance.Attributes.Add("onMouseOut", "this.className='GridRowOnmouseOut'");
TableCell tdSlNo = new TableCell();
tdSlNo.HorizontalAlign = HorizontalAlign.Left;
int rowNumber = dsBalance + 1;
tdSlNo.Text = Convert.ToString(rowNumber, CultureInfo.CurrentCulture);
tdSlNo.Width = 30;
TableCell tdRechargeID = new TableCell();
tdRechargeID.Text = dsMyBalance.Tables[0].Rows[dsBalance]["RECHARGE_ID"].ToString();
tdRechargeID.HorizontalAlign = HorizontalAlign.Left;
TableCell tdIsRecharge = new TableCell();
tdIsRecharge.Text = dsMyBalance.Tables[0].Rows[dsBalance]["IS_RECHARGE"].ToString();
tdIsRecharge.HorizontalAlign = HorizontalAlign.Left;
TableCell tdAmount = new TableCell();
tdAmount.Text = Protector.DecodeString(dsMyBalance.Tables[0].Rows[dsBalance]["AMOUNT"].ToString());
tdAmount.HorizontalAlign = HorizontalAlign.Left;
trBalance.Cells.Add(tdSlNo);
trBalance.Cells.Add(tdRechargeID);
trBalance.Cells.Add(tdIsRecharge);
trBalance.Cells.Add(tdAmount);
TableMyBalance.Rows.Add(trBalance);
}
}
else
{
}
}
private void BuildUserAccountSummery()
{
if (string.IsNullOrEmpty(DropDownListToYear.SelectedValue) && string.IsNullOrEmpty(DropDownListFromYear.SelectedValue))
{
BindFromYearDropDown();
BindToYearDropDown();
SetTodaysDateValue();
}
decimal total = 0;
decimal closingValue = 0;
decimal previousClosingTotal = 0;
string monthFrom = DropDownListFromMonth.SelectedValue;
string dayFrom = DropDownListFromDate.SelectedValue;
string yearFrom = DropDownListFromYear.SelectedValue;
string monthTo = DropDownListToMonth.SelectedValue;
string dayTo = DropDownListToDate.SelectedValue;
string yearTo = DropDownListToYear.SelectedValue;
string fromDate = "" + monthFrom + "/" + dayFrom + "/" + yearFrom + "";
string toDate = "" + monthTo + "/" + dayTo + "/" + yearTo + "";
string userID = "";
string currencySymbol = string.Empty;
if (HiddenUserID.Value != null && HiddenUserID.Value != "0")
{
HiddenUserID.Value = DropDownListUsers.SelectedValue;
userID = HiddenUserID.Value;
DropDownListUsers.SelectedValue = userID;
}
else
{
userID = DropDownListUsers.SelectedValue;
}
if (HiddenFieldSelectedCostProfile.Value != null && HiddenFieldSelectedCostProfile.Value != "0")
{
userID = HiddenFieldSelectedCostProfile.Value;
}
DataSet dsUserAccountSummary = DataManager.Provider.Users.provideAccountSummary(userID, fromDate, toDate);
try
{
if (dsUserAccountSummary != null && dsUserAccountSummary.Tables.Count > 0 && dsUserAccountSummary.Tables[0].Rows.Count > 0)
{
//decrypt the values sum the total amount
for (int index = 0; index < dsUserAccountSummary.Tables[0].Rows.Count; index++)
{
try
{
total += decimal.Parse(Protector.DecodeString(dsUserAccountSummary.Tables[0].Rows[index]["Total"].ToString()));
}
catch
{
}
}
LabelBalanceAmount.Text = total.ToString();
}
if (dsUserAccountSummary != null && dsUserAccountSummary.Tables.Count > 0 && dsUserAccountSummary.Tables[3].Rows.Count > 0)
{
//decrypt the values sum the total amount
for (int index = 0; index < dsUserAccountSummary.Tables[3].Rows.Count; index++)
{
try
{
previousClosingTotal += decimal.Parse(Protector.DecodeString(dsUserAccountSummary.Tables[3].Rows[index]["ACC_AMOUNT"].ToString()));
}
catch
{
}
}
}
try
{
closingValue = previousClosingTotal;
}
catch
{
}
if (dsUserAccountSummary != null && dsUserAccountSummary.Tables.Count > 0 && dsUserAccountSummary.Tables[1].Rows.Count > 0)
{
for (int index = 0; index < dsUserAccountSummary.Tables[1].Rows.Count; index++)
{
TableRow trUser = new TableRow();
AppController.StyleTheme.SetGridRowStyle(trUser);
trUser.ID = dsUserAccountSummary.Tables[1].Rows[index]["ACC_USR_ID"].ToString() + index.ToString();
TableCell tdSlno = new TableCell();
tdSlno.Text = (index + 1).ToString();
tdSlno.HorizontalAlign = HorizontalAlign.Left;
TableCell tdDate = new TableCell();
DateTime dtDate = new DateTime();
try
{
dtDate = DateTime.Parse(dsUserAccountSummary.Tables[1].Rows[index]["REC_CDATE"].ToString());
}
catch
{
tdDate.Text = dsUserAccountSummary.Tables[1].Rows[index]["REC_CDATE"].ToString();
}
tdDate.Text = dtDate.ToString("dd MMMM yyyy hh:mm:ss tt");
tdDate.HorizontalAlign = HorizontalAlign.Left;
tdDate.Attributes.Add("onclick", "togall(" + index + ")");
TableCell tdUserRemarks = new TableCell();
tdUserRemarks.Text = dsUserAccountSummary.Tables[1].Rows[index]["REMARKS"].ToString();
tdUserRemarks.HorizontalAlign = HorizontalAlign.Left;
tdUserRemarks.Attributes.Add("onclick", "togall(" + index + ")");
string JobID = dsUserAccountSummary.Tables[1].Rows[index]["JOB_LOG_ID"].ToString();
TableCell tdUserJobID = new TableCell();
tdUserJobID.Text = JobID;
tdUserJobID.HorizontalAlign = HorizontalAlign.Left;
tdUserJobID.Attributes.Add("onclick", "togall(" + index + ")");
TableCell tdUserName = new TableCell();
tdUserName.Text = dsUserAccountSummary.Tables[1].Rows[index]["ACC_USER_NAME"].ToString();
tdUserName.HorizontalAlign = HorizontalAlign.Left;
tdUserName.Attributes.Add("onclick", "togall(" + index + ")");
decimal amount = 0;
try
{
amount = decimal.Parse(Protector.DecodeString(dsUserAccountSummary.Tables[1].Rows[index]["ACC_AMOUNT"].ToString()));
}
catch
{
}
string debitValue = "";
string crditValue = "";
closingValue = (closingValue + amount);
if (amount < 0)
{
debitValue = amount.ToString();
//crditValue = "0.00";
}
if (amount > 0)
{
crditValue = amount.ToString();
//debitValue = "0.00";
}
if (dsUserAccountSummary.Tables[2].Rows.Count > 0)
{
currencySymbol = dsUserAccountSummary.Tables[2].Rows[0]["Cur_SYM_TXT"].ToString();
if (string.IsNullOrEmpty(currencySymbol))
{
string path = (Server.MapPath("~/") + "App_UserData\\Currency\\");
if (Directory.Exists(path))
{
DirectoryInfo downloadedInfo = new DirectoryInfo(path);
foreach (FileInfo file in downloadedInfo.GetFiles())
{
currencySymbol = "<img src='../App_UserData/Currency/" + file.Name + "' width='16px' height='16px'/>";
break;
}
}
}
}
TableCell tdUserDebit = new TableCell();
tdUserDebit.HorizontalAlign = HorizontalAlign.Left;
tdUserDebit.Attributes.Add("onclick", "togall(" + index + ")");
TableCell tdUserCredit = new TableCell();
tdUserCredit.HorizontalAlign = HorizontalAlign.Left;
tdUserCredit.Attributes.Add("onclick", "togall(" + index + ")");
if (amount < 0)
{
tdUserDebit.Text = currencySymbol + " " + debitValue.Replace("-", "");
}
if (amount > 0)
{
tdUserCredit.Text = currencySymbol + " " + crditValue;
}
TableCell tdUserClosing = new TableCell();
tdUserClosing.Text = currencySymbol + " " + closingValue.ToString();
tdUserClosing.HorizontalAlign = HorizontalAlign.Left;
tdUserClosing.Attributes.Add("onclick", "togall(" + index + ")");
trUser.Cells.Add(tdSlno);
trUser.Cells.Add(tdDate);
trUser.Cells.Add(tdUserRemarks);
trUser.Cells.Add(tdUserJobID);
trUser.Cells.Add(tdUserDebit);
trUser.Cells.Add(tdUserCredit);
trUser.Cells.Add(tdUserClosing);
TableUsers.Rows.Add(trUser);
}
}
}
catch
{
}
}
public static bool sendConfirmationEmail(string rechargeID, string userID, string amount)
{
string valueName = DataManager.Provider.Users.ProvideUserEmailandUserName(userID);
string[] value = valueName.Split(',');
string emailId = "";
string userName = "";
if (value.Length > 0)
{
emailId = value[0].ToString();
}
if (value.Length > 1)
{
userName = value[1].ToString();
}
string balance = DataManager.Provider.Users.ProvideBalance(userID);
try
{
DbDataReader drSMTPSettings = DataManager.Provider.Users.ProvideSMTPDetails();
string strMailTo = System.Configuration.ConfigurationManager.AppSettings["mailTo"];
MailMessage mail = new MailMessage();
StringBuilder sbRechargeDetails = new StringBuilder();
sbRechargeDetails.Append("<table class='SummaryTable' width='50%' style='background-color:silver' cellspacing='1' cellpadding='8' border='0'>");
sbRechargeDetails.Append("<tr class='SummaryDataRow'>");
sbRechargeDetails.Append("<td colspan='2' align='left' class='SummaryDataRow'>Dear " + userName + ", <br/><br/> Your Recharge has been done successfully.<br/><br/> </td>");
sbRechargeDetails.Append("</tr>");
sbRechargeDetails.Append("<tr class='SummaryDataRow'>");
sbRechargeDetails.Append("<td colspan='2' align='left' class='SummaryDataRow'>Please find the Recharge details below.<br/><br/> </td>");
sbRechargeDetails.Append("</tr>");
sbRechargeDetails.Append("<tr class='SummaryTitleRow'>");
sbRechargeDetails.Append("<td colspan='2' align='center' class='SummaryTitleCell'></td>");
sbRechargeDetails.Append("</tr>");
sbRechargeDetails.Append("<tr class='SummaryDataRow'>");
sbRechargeDetails.Append("<td class='SummaryDataCell'>User Name</td>");
sbRechargeDetails.Append("<td class='SummaryDataCell'>" + userName + "</td>");
sbRechargeDetails.Append("</tr>");
sbRechargeDetails.Append("<tr class='SummaryDataRow'>");
sbRechargeDetails.Append("<td class='SummaryDataCell'>Recharge ID</td>");
sbRechargeDetails.Append("<td class='SummaryDataCell'>" + rechargeID + "</td>");
sbRechargeDetails.Append("</tr>");
sbRechargeDetails.Append("<tr class='SummaryDataRow'>");
sbRechargeDetails.Append("<td class='SummaryDataCell'>Amount</td>");
sbRechargeDetails.Append("<td class='SummaryDataCell'>" + Protector.DecodeString(amount) + "</td>");
sbRechargeDetails.Append("</tr>");
sbRechargeDetails.Append("<tr class='SummaryDataRow'>");
sbRechargeDetails.Append("<td class='SummaryDataCell'>Your Current Balance</td>");
sbRechargeDetails.Append("<td class='SummaryDataCell'>" + balance + "</td>");
sbRechargeDetails.Append("</tr>");
sbRechargeDetails.Append("<tr class='SummaryDataRow'>");
sbRechargeDetails.Append("<td class='SummaryDataCell'>Date of recharge</td>");
sbRechargeDetails.Append("<td class='SummaryDataCell'>" + DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToLongTimeString() + "</td>");
sbRechargeDetails.Append("</tr>");
sbRechargeDetails.Append("<tr class='SummaryTitleRow'>");
sbRechargeDetails.Append("<td colspan='2' align='center' class='SummaryTitleCell'></td>");
sbRechargeDetails.Append("</tr>");
//sbPrintJobSummary.Append("<tr class='SummaryDataRow'>");
//sbPrintJobSummary.Append("<td colspan='2' align='left' class='SummaryDataCell'><br/><br/><br/>With Best Regards <br/>Accounting Plus<hr/>Note: This is automated email. Please don't reply to this email</td>");
//sbPrintJobSummary.Append("</tr>");
sbRechargeDetails.Append("</table>");
StringBuilder sbEmailcontent = new StringBuilder();
sbEmailcontent.Append("<html><head><style type='text/css'>");
sbEmailcontent.Append(".GridRow{background-color:white;font-size:12px;font-family:verdana;}");
sbEmailcontent.Append(".GridHeaderRow{white-space:nowrap;background-color:#efefef;font-size:12px;font-family:verdana;}");
sbEmailcontent.Append(".GridCell{font-size:12px;font-family:verdana;}");
sbEmailcontent.Append(".SummaryTitleRow{white-space:nowrap;background-color:#efefef;font-size:16px;font-family:verdana;}");
sbEmailcontent.Append(".SummaryTitleCell{white-space:nowrap;background-color:#efefef;font-size:16px;font-family:verdana;}");
sbEmailcontent.Append(".SummaryDataRow{white-space:nowrap;background-color:white;font-size:14px;font-family:verdana;}");
sbEmailcontent.Append(".SummaryDataCell{white-space:nowrap;background-color:white;font-size:12px;font-family:verdana;}");
sbEmailcontent.Append(".SummaryDataCellReset{white-space:nowrap;background-color:white;font-size:12px;font-family:verdana;font-weight: bold;color:Red;}");
sbEmailcontent.Append(".Passed{white-space:nowrap;background-color:white;font-size:18px;font-family:verdana;font-weight:bold;color:green}");
sbEmailcontent.Append(".Failed{white-space:nowrap;background-color:white;font-size:18px;font-family:verdana;font-weight:bold;color:red}");
sbEmailcontent.Append("</style></head>");
sbEmailcontent.Append("<body>");
sbEmailcontent.Append("<table width='100%' class='MainTable' style='background-color:white' cellspacing='0' cellpadding='8' border='0'>");
sbEmailcontent.Append("<tr><td></td></tr>");
sbEmailcontent.Append("<tr><td valign='top' align='center'>");
sbEmailcontent.Append(sbRechargeDetails.ToString());
sbEmailcontent.Append("</td></tr>");
sbEmailcontent.Append("</table></body></html>");
mail.Body = sbEmailcontent.ToString();
mail.IsBodyHtml = true;
SmtpClient Email = new SmtpClient();
while (drSMTPSettings.Read())
{
mail.To.Add(emailId);
//if (!string.IsNullOrEmpty(strMailCC))
//{
// mail.CC.Add(strMailCC);
//}
mail.From = new MailAddress(drSMTPSettings["FROM_ADDRESS"].ToString());
mail.Subject = "[AccountingPlus] Recharge Successfull";
Email.Host = drSMTPSettings["SMTP_HOST"].ToString(); //"172.29.240.82";
Email.Port = Convert.ToInt32(drSMTPSettings["SMTP_PORT"]); //25;
Email.Send(mail);
}
drSMTPSettings.Close();
}
catch
{
string serverMessage = "Failed to recharge";
}
return(true);
}
private void GetMiniStatement()
{
DataSet dsgetuserStatement = DataManagerDevice.ProviderDevice.Device.GetMiniStatement(userID);
decimal closingValue = 0;
for (int index = 0; index < dsgetuserStatement.Tables[1].Rows.Count; index++)
{
TableRow trUser = new TableRow();
trUser.CssClass = "JoblistFont";
trUser.ID = dsgetuserStatement.Tables[1].Rows[index]["ACC_USR_ID"].ToString() + index.ToString();
TableCell tdSlno = new TableCell();
tdSlno.Text = (index + 1).ToString();
tdSlno.HorizontalAlign = HorizontalAlign.Left;
TableCell tdUserRemarks = new TableCell();
tdUserRemarks.Text = dsgetuserStatement.Tables[1].Rows[index]["REMARKS"].ToString();
tdUserRemarks.HorizontalAlign = HorizontalAlign.Left;
//tdUserRemarks.Attributes.Add("onclick", "togall(" + index + ")");
string JobID = dsgetuserStatement.Tables[1].Rows[index]["JOB_LOG_ID"].ToString();
TableCell tdUserJobID = new TableCell();
tdUserJobID.Text = JobID;
tdUserJobID.HorizontalAlign = HorizontalAlign.Left;
//tdUserJobID.Attributes.Add("onclick", "togall(" + index + ")");
TableCell tdUserName = new TableCell();
tdUserName.Text = dsgetuserStatement.Tables[1].Rows[index]["ACC_USER_NAME"].ToString();
tdUserName.HorizontalAlign = HorizontalAlign.Left;
//tdUserName.Attributes.Add("onclick", "togall(" + index + ")");
decimal amount = 0;
try
{
amount = decimal.Parse(Protector.DecodeString(dsgetuserStatement.Tables[1].Rows[index]["ACC_AMOUNT"].ToString()));
}
catch
{
}
string debitValue = "0.00";
string crditValue = "0.00";
closingValue = (closingValue + amount);
if (amount < 0)
{
debitValue = amount.ToString();
crditValue = "0.00";
}
if (amount > 0)
{
crditValue = amount.ToString();
debitValue = "0.00";
}
TableCell tdUserDebit = new TableCell();
tdUserDebit.Text = debitValue.Replace("-", "");
tdUserDebit.HorizontalAlign = HorizontalAlign.Left;
//tdUserDebit.Attributes.Add("onclick", "togall(" + index + ")");
TableCell tdUserCredit = new TableCell();
tdUserCredit.Text = crditValue;
tdUserCredit.HorizontalAlign = HorizontalAlign.Left;
//tdUserCredit.Attributes.Add("onclick", "togall(" + index + ")");
TableCell tdUserClosing = new TableCell();
tdUserClosing.Text = closingValue.ToString();
tdUserClosing.HorizontalAlign = HorizontalAlign.Left;
//tdUserClosing.Attributes.Add("onclick", "togall(" + index + ")");
LabelBalanceAmount.Text = "Balance :" + closingValue.ToString();
trUser.Cells.Add(tdSlno);
trUser.Cells.Add(tdUserRemarks);
trUser.Cells.Add(tdUserJobID);
//trUser.Cells.Add(tdUserName);
trUser.Cells.Add(tdUserDebit);
trUser.Cells.Add(tdUserCredit);
trUser.Cells.Add(tdUserClosing);
TableMiniStatement.Rows.Add(trUser);
TableRow horizantalRow = new TableRow();
TableCell horizantalCell = new TableCell();
horizantalCell.HorizontalAlign = HorizontalAlign.Left;
horizantalCell.VerticalAlign = VerticalAlign.Middle;
//horizantalCell.Height = 6;
//horizantalCell.CssClass = "PaddingInner_Grid";
horizantalCell.ColumnSpan = 12;
if (index == 9)
{
horizantalCell.CssClass = "PaddingInner_Grid";
}
else
{
horizantalCell.CssClass = "PaddingInner_Grid HR_Line";
}
horizantalRow.Cells.Add(horizantalCell);
TableMiniStatement.Rows.Add(horizantalRow);
}
}
