private void PriceInWords_SummaryCalculated(object sender, TextFormatEventArgs e)
{
if (e.Value != null)
{
e.Text = NumberToEnglish.ConvertMoneyToWords(Convert.ToDouble(e.Value.ToString().Replace(",", "")));
}
}
public static string GetFullNameByID(int iso_id, int ho_id, params int[] br_id)
{
var ctx = PTFContext.Current;
Debug.Assert(ctx != null, "No default context");
int count = br_id.Count();
Debug.Assert(count > 0, "No retailers");
if (count == 1)
{
int id = br_id.First();
return(ctx.Branches.FirstOrDefault(br => br.br_iso_id == iso_id && br.br_ho_id == ho_id && br.br_id == id).SafeGetValue("FullName", ""));
}
else if (count == ctx.Branches.Count())
{
return("ALL");
}
else
{
NumberToEnglish en = new NumberToEnglish();
return(en.ChangeNumericToWords(count, "Selected "));
}
}
public ActionResult PrintDeliveryDetail(int id)
{
try
{
NumberToEnglish num = new NumberToEnglish();
var DeliveryDetails = repo.GetDeliveryDetailByID(id);
var gst = Convert.ToDecimal(System.Configuration.ConfigurationManager.AppSettings["gst"]);
var total = Convert.ToDecimal(DeliveryDetails.totalAmount) / gst;
var diff = Convert.ToDecimal(DeliveryDetails.totalAmount) - total;
DeliveryDetails.cgst = diff / 2;
DeliveryDetails.sgst = diff / 2;
DeliveryDetails.balanceAmount = Convert.ToDecimal(DeliveryDetails.totalAmount);
DeliveryDetails.totalAmount = total;
DeliveryDetails.cylinderAmount = Convert.ToDecimal(DeliveryDetails.totalAmount / DeliveryDetails.filledCylinder);
ViewBag.AmntInWord = num.changeCurrencyToWords(DeliveryDetails.balanceAmount.ToString());
var taxamnt = DeliveryDetails.cgst + DeliveryDetails.sgst;
ViewBag.TaxAmnt = string.Format("{0:0.00}", taxamnt);
ViewBag.TaxAmntInWord = num.changeCurrencyToWords(ViewBag.TaxAmnt);
if (DeliveryDetails.signature != null)
{
ViewBag.SignatureImage = ToBase64ImageString(DeliveryDetails.signature);
}
return(View(DeliveryDetails));
}
catch (Exception)
{
ViewBag.ErrorMsg = "Sorry Some Problem Occured";
}
return(RedirectToAction("Listing"));
}
public void RenderCommissionCheckAmountInEnglish(decimal amount)
{
NumberToEnglish converter = new NumberToEnglish();
string amountString = converter.ChangeCurrencyToWords(Convert.ToDouble(amount));
Html32TextWriter writer = new Html32TextWriter(Response.Output);
writer.Write(amountString);
}
public void GetEnglish_Returns_Input_Number_With_Edge_Cases_Spelled_Out_In_English()
{
var expectedEnglish = "nine hundred and sixteen quadrillion eight hundred trillion ";
expectedEnglish += "one hundred and eighty-five million one hundred and six thousand ";
expectedEnglish += "seven hundred and fifteen";
NumberToEnglish.GetEnglish("916800000185106715").Should().Be(expectedEnglish);
}
public void TestMillions()
{
NumberToEnglish n = new NumberToEnglish();
string actual = n.MoneyConverter(7890123);
string expected = "seven million eight hundred and ninety thousand one hundred and twenty-three";
Assert.Equal(expected, actual);
}
public void TestHundredThousands()
{
NumberToEnglish n = new NumberToEnglish();
string actual = n.MoneyConverter(678901);
string expected = "six hundred and seventy-eight thousand nine hundred and one";
Assert.Equal(expected, actual);
}
public void TestTenThousands()
{
NumberToEnglish n = new NumberToEnglish();
string actual = n.MoneyConverter(56789);
string expected = "fifty-six thousand seven hundred and eighty-nine";
Assert.Equal(expected, actual);
}
public void TestThousands()
{
NumberToEnglish n = new NumberToEnglish();
string actual = n.MoneyConverter(4567);
string expected = "four thousand five hundred and sixty-seven";
Assert.Equal(expected, actual);
}
public void TestHundreds()
{
NumberToEnglish n = new NumberToEnglish();
string actual = n.MoneyConverter(345);
string expected = "three hundred and forty-five";
Assert.Equal(expected, actual);
}
public void TestTens()
{
NumberToEnglish n = new NumberToEnglish();
string actual = n.MoneyConverter(23);
string expected = "twenty-three";
Assert.Equal(expected, actual);
}
public void TestOnes()
{
NumberToEnglish n = new NumberToEnglish();
string actual = n.MoneyConverter(1);
string expected = "one";
Assert.Equal(expected, actual);
}
private void PriceInWords_SummaryCalculated(object sender, DevExpress.XtraReports.UI.TextFormatEventArgs e)
{
try
{
e.Text = NumberToEnglish.ConvertMoneyToWords(Convert.ToDouble(e.Value.ToString().Replace(",", "")));
}
catch
{
}
}
private void PriceInWords_SummaryCalculated(object sender, DevExpress.XtraReports.UI.TextFormatEventArgs e)
{
if (e.Value != null)
{
double grandTotal = Convert.ToDouble(e.Value.ToString().Replace(",", ""));
if (_includeInsurance)
{
grandTotal += BLL.Order.GetInsuranceValue(_orderID, grandTotal);
}
e.Text = NumberToEnglish.ConvertMoneyToWords(grandTotal);
}
}
public ActionResult SendEmail(int id)
{
try
{
NumberToEnglish num = new NumberToEnglish();
var DeliveryDetails = repo.GetDeliveryDetailByID(id);
var gst = Convert.ToDecimal(System.Configuration.ConfigurationManager.AppSettings["gst"]);
var total = Convert.ToDecimal(DeliveryDetails.totalAmount) / gst;
var diff = Convert.ToDecimal(DeliveryDetails.totalAmount) - total;
DeliveryDetails.cgst = diff / 2;
DeliveryDetails.sgst = diff / 2;
DeliveryDetails.balanceAmount = Convert.ToDecimal(DeliveryDetails.totalAmount);
DeliveryDetails.totalAmount = total;
DeliveryDetails.cylinderAmount = Convert.ToDecimal(DeliveryDetails.totalAmount / DeliveryDetails.filledCylinder);
ViewBag.AmntInWord = num.changeCurrencyToWords(DeliveryDetails.balanceAmount.ToString());
var taxamnt = DeliveryDetails.cgst + DeliveryDetails.sgst;
ViewBag.TaxAmnt = string.Format("{0:0.00}", taxamnt);
ViewBag.TaxAmntInWord = num.changeCurrencyToWords(ViewBag.TaxAmnt);
var smtpServer = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["smtpServer"]);
var smtpPort = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["smtpPort"]);
var smtpUser = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["smtpUser"]);
var smtpPwd = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["smtpPass"]);
MailMessage message = new MailMessage();
MailAddress Sender = new MailAddress(smtpUser);
MailAddress receiver = new MailAddress(DeliveryDetails.CustomerDetail.email);
SmtpClient smtp = new SmtpClient()
{
Host = smtpServer, // "smtp.gmail.com", //for gmail
Port = Convert.ToInt32(smtpPort), //, //for gmail
EnableSsl = false,
Credentials = new System.Net.NetworkCredential(smtpUser, smtpPwd)
};
message.From = Sender;
message.Subject = "Invoice for delivery details- " + DeliveryDetails.voucherNo;
message.To.Add(receiver);
message.IsBodyHtml = true;
message.Body = this.ConvertViewToString("~/Views/DeliveryDetail/PrintDeliveryDetail.cshtml", DeliveryDetails);
smtp.Send(message);
ViewBag.SuccessMsg = "Invoice sent Successfully";
}
catch (Exception)
{
ViewBag.Status = "Problem while sending email, Please check details.";
}
var DeliveryDetaillist = repo.GetAllDeliveryDetails();
return(View("Listing", DeliveryDetaillist));
}
public Employee GetData()
{
///бессмысленный функционал
///string[] name = _timeReport.Name.Split(' ').ToArray();
///this._invoicerName = name;
/// находим из Time репорта чисто по имени?
var contractorsAndContractsDataRow = _contractorsAndContractsData;
if (contractorsAndContractsDataRow == null)
{
throw new Exception("Не найдена строка в контрактах для работника из указанного Time Report. Перепроверьте файлы. (Для корректной работы программмы файлы должны соответсвовать шаблону)");
}
var paymentDataRow = _paymentData;
if (paymentDataRow == null)
{
throw new Exception("Не найдена строка в таблице Payment Data для работника из указанного Time Report. Перепроверьте файлы. (Для корректной работы программмы файлы должны соответсвовать шаблону)");
}
CultureInfo ci = new CultureInfo("ru-RU");
_hourlyRate = paymentDataRow.InvoiceAmount / paymentDataRow.HoursInvoiced;
string amountInwords = NumberToEnglish.ChangeNumericToWords(paymentDataRow.InvoiceAmount);
var result = new Employee()
{
NameEng = contractorsAndContractsDataRow.NameEng,
NameRus = contractorsAndContractsDataRow.NameRus,
ContractId = contractorsAndContractsDataRow.ContractId,
DocSetNumber = paymentDataRow.DocSetNumber,
ContractDate = string.Format("'{0}", contractorsAndContractsDataRow.ContractStartDate.ToString("dd MMM yyyy")),
ContractDateTranslated = string.Format("'{0}", contractorsAndContractsDataRow.ContractStartDate.ToString("dd MMM yyyy", ci)),
HoursInvoiced = paymentDataRow.HoursInvoiced,
Phone = contractorsAndContractsDataRow.Phone,
ProjectName = paymentDataRow.ProjectName,
TotalAmount = paymentDataRow.InvoiceAmount,
DocumentSetDate = string.Format("'{0}", _dateTo.ToString("dd MMM yyyy")),
DocumentSetDateTranslated = string.Format("'{0}", _dateTo.ToString("dd MMM yyyy", ci)),
DatesCovered = GetDatesRange(),
AmountInwords = amountInwords,
AmountInWordsTranslated = TranslateTextUsingGoogle.GetTranslateForAmount(amountInwords, "ru")
};
return(result);
}
/// <summary>
/// Run solution for problem 17.
/// </summary>
/// <param name="rangeThreshold">Range threshold.</param>
/// <returns>
/// Number of letters when numbers from 1 to <paramref name="rangeThreshold"/> inclusive
/// are written out in words.
/// </returns>
public static int Run(int rangeThreshold)
{
var numbersLetterCount = 0;
var regEx = new Regex("[a-z]+");
for (var i = 1; i <= rangeThreshold; i += 1)
{
var result = NumberToEnglish.GetEnglish(i);
numbersLetterCount += regEx.Matches(NumberToEnglish.GetEnglish(i))
.Aggregate(0, (letterCount, match) => letterCount + match.Value.Length);
}
return(numbersLetterCount);
}
public void SendEmail(int id)
{
try
{
NumberToEnglish num = new NumberToEnglish();
var DeliveryDetails = repo.GetDeliveryDetailByID(id);
var cgst = Convert.ToDecimal(System.Configuration.ConfigurationManager.AppSettings["Cgst"]) / 100;
var sgst = Convert.ToDecimal(System.Configuration.ConfigurationManager.AppSettings["Sgst"]) / 100;
var total = Convert.ToDecimal(DeliveryDetails.totalAmount);
DeliveryDetails.cgst = total * cgst;
DeliveryDetails.sgst = total * sgst;
DeliveryDetails.balanceAmount = total + DeliveryDetails.cgst + DeliveryDetails.sgst;
var AmntInWord = num.changeNumericToWords(DeliveryDetails.balanceAmount.ToString());
var TaxAmnt = DeliveryDetails.cgst + DeliveryDetails.sgst;
var TaxAmntInWord = num.changeNumericToWords((DeliveryDetails.cgst + DeliveryDetails.sgst).ToString());
var smtpServer = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["smtpServer"]);
var smtpPort = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["smtpPort"]);
var smtpUser = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["smtpUser"]);
var smtpPwd = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["smtpPass"]);
MailMessage message = new MailMessage();
MailAddress Sender = new MailAddress(smtpUser);
MailAddress receiver = new MailAddress(DeliveryDetails.CustomerDetail.email);
SmtpClient smtp = new SmtpClient()
{
Host = smtpServer, // "smtp.gmail.com", //for gmail
Port = Convert.ToInt32(smtpPort), //587, //for gmail
EnableSsl = false,
Credentials = new System.Net.NetworkCredential(smtpUser, smtpPwd)
};
message.From = Sender;
message.Subject = "Invoice for delivery details- " + DeliveryDetails.voucherNo;
message.To.Add(receiver);
message.IsBodyHtml = true;
message.Body = RenderViewToString("DeliveryDetai", "~/Views/DeliveryDetail/PrintDeliveryDetail.cshtml", DeliveryDetails); //this.ConvertViewToString(DeliveryDetails, AmntInWord.ToString(), TaxAmnt.ToString(), TaxAmntInWord.ToString());
smtp.Send(message);
}
catch (Exception ex)
{
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
NumberToEnglish NoToEng = new NumberToEnglish();
if (e.Row.RowType == DataControlRowType.DataRow)
{
Qty = Qty + Double.Parse(e.Row.Cells[3].Text);
//UnitPrice = UnitPrice + Double.Parse(e.Row.Cells[7].Text);
// TotalDP = TotalDP + Double.Parse(e.Row.Cells[10].Text);
//TotalTaxAmount = TotalTaxAmount + Double.Parse(e.Row.Cells[8].Text);
TotalTax = TotalTax + Double.Parse(e.Row.Cells[10].Text);
TotalBv = TotalBv + Double.Parse(e.Row.Cells[11].Text);
TotalDp = TotalDp + Double.Parse(e.Row.Cells[12].Text);
// TotalPrice = TotalPrice + Double.Parse(e.Row.Cells[11].Text);
// lblTotalTaxAmount.Text = string.Format("{0:f2}", (Double.Parse(lblTotalTaxAmount.Text)));
GrossAmt = GrossAmt + Double.Parse(e.Row.Cells[11].Text);
// Tottax = (0 + Double.Parse(lblTotalTaxAmount.Text.ToString().Replace(".0000", ".00")));
}
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[6].Text = "Total :";
// e.Row.Cells[7].Text = string.Format("{0:f2}", UnitPrice);
// e.Row.Cells[6].Text = Qty.ToString();
// e.Row.Cells[10].Text = string.Format("{0:f0}", TotalDP);
//e.Row.Cells[8].Text = string.Format("{0:f2}", TotalTaxAmount);
e.Row.Cells[10].Text = string.Format("{0:f0}", TotalTax);
e.Row.Cells[11].Text = string.Format("{0:f0}", TotalBv);
e.Row.Cells[12].Text = string.Format("{0:f0}", TotalDp);
Double Courch = Double.Parse((lblCourierCharges.Text).ToString().Replace(".0000", ".00"));
Double NetPay = Tottax + TotalPrice + Courch;
// lblTotalPayment.Text = TotalPrice.ToString();
lblTotalPayment.Text = (TotalDp + Courch).ToString().Replace(".0000", ".00");
// bvdiscountamount.Text = "0.00";
lblamountinword.Text = NoToEng.changeNumericToWords(Double.Parse(lblTotalPayment.Text)) + " Rupees Only.";
}
}
protected override Task <Question> BuildQuestion()
{
var number = _randomGenerator.Next(int.MaxValue);
var value = _randomGenerator.Next(100) < 51 ? $"{number}" : NumberToEnglish.ChangeNumericToWords(number);
var question = new Question
{
InputValues = new List <Value>()
{
new Value
{
Name = "number",
Data = $"{value}"
},
new Value
{
Name = "hash",
Data = $"{StringEncrypt.Encrypt($"{number}","seppeisthebest")}"
},
}
};
return(Task.FromResult(question));
}
private void xrInsuranceValue_SummaryCalculated(object sender, DevExpress.XtraReports.UI.TextFormatEventArgs e)
{
try
{
NumberToEnglish converter = new NumberToEnglish();
totalWithoutInsurance = Convert.ToDouble(e.Value);
if (_includeInsurance)
{
BLL.Order order = new BLL.Order();
insuranceValue = BLL.Order.GetInsuranceValue(_orderID, totalWithoutInsurance);
e.Text = insuranceValue.ToString("###,###,##0.#0");
xrTotalPrice.Text = (insuranceValue + totalWithoutInsurance).ToString();
}
else
{
insuranceValue = 0;
e.Text = " - ";
xrTotalPrice.Text = totalWithoutInsurance.ToString();
}
}
catch
{
}
}
public void GetEnglish_Returns_Input_Number_Spelled_Out_In_English()
{
NumberToEnglish.GetEnglish(413).Should().Be("four hundred and thirteen");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserID"] == null)
{
Session.RemoveAll();
Response.Redirect("../../Default.aspx");
}
DataTable dtBankAdvice = new DataTable();
StringBuilder sbMst = new StringBuilder();
StringBuilder sbfilter = new StringBuilder();
sbfilter.Append(" ");
sbMst.Append("SELECT DECODE(EMP_INFO.SEX, 'M', 'Mr. ' || EMP_INFO.NAME, 'F', 'Ms. ' || EMP_INFO.NAME) AS NAME, EMP_INFO.BKACNO, ");
sbMst.Append(" AMCL_EMP_SALARY.NET_PAYABLE ");
sbMst.Append(" FROM AMCL_EMP_SALARY INNER JOIN ");
sbMst.Append(" EMP_INFO ON AMCL_EMP_SALARY.ID = EMP_INFO.ID ");
if (Request.QueryString["calDate"].ToString() != " ")
{
sbfilter.Append(" WHERE (AMCL_EMP_SALARY.CAL_DATE ='" + Convert.ToDateTime(Request.QueryString["calDate"]).ToString("dd-MMM-yyyy") + "')");
}
sbMst.Append(sbfilter.ToString());
sbMst.Append(" ORDER BY EMP_INFO.RANK, EMP_INFO.SENIORITY");
dtBankAdvice = commonGatewayObj.Select(sbMst.ToString());
dtBankAdvice.TableName = "BankAdvice";
DataTable dtTotalAmount = new DataTable();
StringBuilder querySring = new StringBuilder();
querySring.Append("SELECT SUM(AMCL_EMP_SALARY.NET_PAYABLE) AS TOTAL_AMOUNT FROM AMCL_EMP_SALARY");
querySring.Append(" WHERE (AMCL_EMP_SALARY.CAL_DATE ='" + Convert.ToDateTime(Request.QueryString["calDate"]).ToString("dd-MMM-yyyy") + "')");
dtTotalAmount = commonGatewayObj.Select(querySring.ToString());
dtTotalAmount.TableName = "TotalAmount";
NumberToEnglish numberToEnnglishObj = new NumberToEnglish();
decimal totalAmount = Convert.ToDecimal(dtTotalAmount.Rows[0]["TOTAL_AMOUNT"]);
string totalAmountInWords = numberToEnnglishObj.changeNumericToWords(totalAmount);
if (dtBankAdvice.Rows.Count > 0)
{
//dtBankAdvice.WriteXmlSchema(@"F:\PortfolioManagementSystem\UI\ReportViewer\Report\crtmBankAdviceReport.xsd");
//ReportDocument rdoc = new ReportDocument();
string Path = Server.MapPath("Report/crtmBankAdviceReport.rpt");
rdoc.Load(Path);
rdoc.SetDataSource(dtBankAdvice);
CRV_BankAdvice.ReportSource = rdoc;
rdoc.SetParameterValue("prmtotalAmount", totalAmount);
rdoc.SetParameterValue("prmtotalAmountInWords", totalAmountInWords);
rdoc = ReportFactory.GetReport(rdoc.GetType());
CRV_BankAdvice.DisplayToolbar = true;
CRV_BankAdvice.HasExportButton = true;
CRV_BankAdvice.HasPrintButton = true;
}
else
{
Response.Write("No Data Found");
}
}
/// <summary>
/// Returns the english representation of the integer.
/// </summary>
/// <param name="num"></param>
public static string ToEnglish(this int num)
{
return(NumberToEnglish.Convert(num));
}
