private void FrmOnlinePayment_Load(object sender, EventArgs e)
{
try
{
lblMemoNo.Text = MemoNo;
lblMemoDate.Text = MemoDate.ToString("dd-MM-yyyy");
txtMemoAmount.Text = TotalMemoAmount.ToString("0.00");
DataSet ds = ProjectFunctions.GetDataSet("Select * from CASHTENDER Where CATMEMONO='" + MemoNo + "' And CATMEMODATE='" + MemoDate.Date.ToString("yyyy-MM-dd") + "' ANd UnitCode='" + GlobalVariables.CUnitID + "'");
if (ds.Tables[0].Rows.Count > 0)
{
txtUPIDType.Text = ds.Tables[0].Rows[0]["UPIDType"].ToString();
txtUPIDMobileNo.Text = ds.Tables[0].Rows[0]["UPIDMobileNo"].ToString();
txtNameOnUPID.Text = ds.Tables[0].Rows[0]["UPIDName"].ToString();
txtUPID.Text = ds.Tables[0].Rows[0]["UPIDAddress"].ToString();
txtAmountPaid.EditValue = ds.Tables[0].Rows[0]["CATPGAMT"].ToString();
txtBalanceAmount.EditValue = (Convert.ToDecimal(txtMemoAmount.Text) - Convert.ToDecimal(txtAmountPaid.Text));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Card_Load(object sender, EventArgs e)
{
try
{
lblMemoNo.Text = MemoNo;
lblMemoDate.Text = MemoDate.ToString("dd-MM-yyyy");
txtMemoAmount.Text = TotalMemoAmount.ToString("0.00");
DataSet ds = ProjectFunctions.GetDataSet("Select * from CASHTENDER Where CATMEMONO='" + MemoNo + "' And CATMEMODATE='" + MemoDate.Date.ToString("yyyy-MM-dd") + "' ANd UnitCode='" + GlobalVariables.CUnitID + "'");
if (ds.Tables[0].Rows.Count > 0)
{
txtCardType.Text = ds.Tables[0].Rows[0]["CATCARDTYPE"].ToString();
txtCardNo.Text = ds.Tables[0].Rows[0]["CATCARDNO"].ToString();
txtNameOnCard.Text = ds.Tables[0].Rows[0]["CATCARDNAME"].ToString();
txtSLipNo.Text = ds.Tables[0].Rows[0]["CATCARDSLIPNO"].ToString();
txtAmountPaid.EditValue = ds.Tables[0].Rows[0]["CATCARDAMT"].ToString();
txtBalanceAmount.EditValue = (Convert.ToDecimal(txtMemoAmount.Text) - Convert.ToDecimal(txtAmountPaid.Text));
//if (Convert.ToDecimal(txtBalanceAmount.EditValue) > 0)
//{
// WindowsFormsApplication1.Transaction.CashTender frm = new WindowsFormsApplication1.Transaction.CashTender() { MemoNo = lblMemoNo.Text, MemoDate = Convert.ToDateTime(lblMemoDate.Text), TotalMemoAmount = Convert.ToDecimal(txtMemoAmount.Text) };
// var P = ProjectFunctions.GetPositionInForm(this);
// frm.Location = new Point(P.X + (ClientSize.Width / 2 - frm.Size.Width / 2), P.Y + (ClientSize.Height / 2 - frm.Size.Height / 2));
// frm.ShowDialog(this.Parent);
//}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void CashTender_Load(object sender, EventArgs e)
{
try
{
//ProjectFunctions.TextBoxVisualize(groupControl2);
//ProjectFunctions.TextBoxVisualize(groupControl3);
//ProjectFunctions.TextBoxVisualize(groupControl4);
DataSet dsTotalGallaAmount = ProjectFunctions.GetDataSet("sp_LoadGallaBal '" + GlobalVariables.CUnitID + "'");
if (dsTotalGallaAmount.Tables[0].Rows.Count > 0)
{
txtTot2000.Text = (Convert.ToDecimal(dsTotalGallaAmount.Tables[0].Rows[0]["CURIN2000"]) / 2000).ToString();
txtTot1000.Text = (Convert.ToDecimal(dsTotalGallaAmount.Tables[0].Rows[0]["CURIN1000"]) / 1000).ToString();
txtTot500.Text = (Convert.ToDecimal(dsTotalGallaAmount.Tables[0].Rows[0]["CURIN500"]) / 500).ToString();
txtTot200.Text = (Convert.ToDecimal(dsTotalGallaAmount.Tables[0].Rows[0]["CURIN200"]) / 200).ToString();
txtTot100.Text = (Convert.ToDecimal(dsTotalGallaAmount.Tables[0].Rows[0]["CURIN100"]) / 100).ToString();
txtTot50.Text = (Convert.ToDecimal(dsTotalGallaAmount.Tables[0].Rows[0]["CURIN50"]) / 50).ToString();
txtTot20.Text = (Convert.ToDecimal(dsTotalGallaAmount.Tables[0].Rows[0]["CURIN20"]) / 20).ToString();
txtTot10.Text = (Convert.ToDecimal(dsTotalGallaAmount.Tables[0].Rows[0]["CURIN10"]) / 10).ToString();
txtTot5.Text = (Convert.ToDecimal(dsTotalGallaAmount.Tables[0].Rows[0]["CURIN5"]) / 5).ToString();
txtTot2.Text = (Convert.ToDecimal(dsTotalGallaAmount.Tables[0].Rows[0]["CURIN2"]) / 2).ToString();
txtTot1.Text = (Convert.ToDecimal(dsTotalGallaAmount.Tables[0].Rows[0]["CURIN1"]) / 1).ToString();
txtTotTotal.Text = dsTotalGallaAmount.Tables[0].Rows[0]["TotalAmount"].ToString();
txtCashOutCount2000.Text = (Convert.ToDecimal(txtCashOutAmount2000.Text) / 2000).ToString();
txtCashOutCount1000.Text = (Convert.ToDecimal(txtCashOutAmount1000.Text) / 1000).ToString();
txtCashOutCount500.Text = (Convert.ToDecimal(txtCashOutAmount500.Text) / 500).ToString();
txtCashOutCount200.Text = (Convert.ToDecimal(txtCashOutAmount200.Text) / 200).ToString();
txtCashOutCount100.Text = (Convert.ToDecimal(txtCashOutAmount100.Text) / 100).ToString();
txtCashOutCount50.Text = (Convert.ToDecimal(txtCashOutAmount50.Text) / 500).ToString();
txtCashOutCount20.Text = (Convert.ToDecimal(txtCashOutAmount20.Text) / 20).ToString();
txtCashOutCount10.Text = (Convert.ToDecimal(txtCashOutAmount10.Text) / 10).ToString();
txtCashOutCount5.Text = (Convert.ToDecimal(txtCashOutAmount5.Text) / 5).ToString();
txtCashOutCount2.Text = (Convert.ToDecimal(txtCashOutAmount2.Text) / 2).ToString();
txtCashOutCount1.Text = (Convert.ToDecimal(txtCashOutAmount1.Text) / 1).ToString();
}
txtCashMemoNo.Text = MemoNo;
txtCashMemoDate.Text = MemoDate.ToString("dd-MM-yyyy");
txtCardPayment.Text = CardPayment.ToString("0.00");
txtPGPayment.Text = PGPayment.ToString("0.00");
txtCashMemoAmount.Text = TotalMemoAmount.ToString("0.00");
DataSet ds = ProjectFunctions.GetDataSet("Select * from CASHTENDER Where CATMEMONO='" + MemoNo + "' And CATMEMODATE='" + MemoDate.Date.ToString("yyyy-MM-dd") + "' And UnitCode='" + GlobalVariables.CUnitID + "'");
if (ds.Tables[0].Rows.Count > 0)
{
txtCashMemoNo.Text = ds.Tables[0].Rows[0]["CATMEMONO"].ToString();
txtCashMemoDate.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["CATMEMODATE"]).ToString("yyyy-MM-dd");
//txtCashMemoAmount.Text = ds.Tables[0].Rows[0]["CATMEMOAMT"].ToString();
txtCardPayment.Text = "0";
txtPGPayment.Text = "0";
txtCashInAmount2000.Text = ds.Tables[0].Rows[0]["CURIN2000"].ToString();
txtCashInAmount1000.Text = ds.Tables[0].Rows[0]["CURIN1000"].ToString();
txtCashInAmount200.Text = ds.Tables[0].Rows[0]["CURIN200"].ToString();
txtCashInAmount500.Text = ds.Tables[0].Rows[0]["CURIN500"].ToString();
txtCashInAmount100.Text = ds.Tables[0].Rows[0]["CURIN100"].ToString();
txtCashInAmount50.Text = ds.Tables[0].Rows[0]["CURIN50"].ToString();
txtCashInAmount20.Text = ds.Tables[0].Rows[0]["CURIN20"].ToString();
txtCashInAmount10.Text = ds.Tables[0].Rows[0]["CURIN10"].ToString();
txtCashInAmount5.Text = ds.Tables[0].Rows[0]["CURIN5"].ToString();
txtCashInAmount2.Text = ds.Tables[0].Rows[0]["CURIN2"].ToString();
txtCashInAmount1.Text = ds.Tables[0].Rows[0]["CURIN1"].ToString();
txtCashInCount2000.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CURIN2000"]) / 2000).ToString();
txtCashInCount1000.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CURIN1000"]) / 1000).ToString();
txtCashInCount500.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CURIN500"]) / 500).ToString();
txtCashInCount200.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CURIN200"]) / 200).ToString();
txtCashInCount100.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CURIN100"]) / 100).ToString();
txtCashInCount50.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CURIN50"]) / 500).ToString();
txtCashInCount20.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CURIN20"]) / 20).ToString();
txtCashInCount10.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CURIN10"]) / 10).ToString();
txtCashInCount5.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CURIN5"]) / 5).ToString();
txtCashInCount2.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CURIN2"]) / 2).ToString();
txtCashInCount1.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CURIN1"]) / 1).ToString();
if (ds.Tables[0].Rows[0]["AutoCashAmount"].ToString().Trim() == string.Empty)
{
ds.Tables[0].Rows[0]["AutoCashAmount"] = 0;
}
txtAutoCash.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["AutoCashAmount"])).ToString();
txtCashInTotal.Text = Convert.ToDecimal(ds.Tables[0].Rows[0]["CURINTOT"]) + (Convert.ToDecimal(ds.Tables[0].Rows[0]["AutoCashAmount"])).ToString();
txtCashOutAmount2000.Text = ds.Tables[0].Rows[0]["CUROUT2000"].ToString();
txtCashOutAmount1000.Text = ds.Tables[0].Rows[0]["CUROUT1000"].ToString();
txtCashOutAmount200.Text = ds.Tables[0].Rows[0]["CUROUT200"].ToString();
txtCashOutAmount500.Text = ds.Tables[0].Rows[0]["CUROUT500"].ToString();
txtCashOutAmount100.Text = ds.Tables[0].Rows[0]["CUROUT100"].ToString();
txtCashOutAmount50.Text = ds.Tables[0].Rows[0]["CUROUT50"].ToString();
txtCashOutAmount20.Text = ds.Tables[0].Rows[0]["CUROUT20"].ToString();
txtCashOutAmount10.Text = ds.Tables[0].Rows[0]["CUROUT10"].ToString();
txtCashOutAmount5.Text = ds.Tables[0].Rows[0]["CUROUT5"].ToString();
txtCashOutAmount2.Text = ds.Tables[0].Rows[0]["CUROUT2"].ToString();
txtCashOutAmount1.Text = ds.Tables[0].Rows[0]["CUROUT1"].ToString();
txtCashOutTotal.Text = ds.Tables[0].Rows[0]["CUROUTTOT"].ToString();
txtCashOutCount2000.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CUROUT2000"]) / 2000).ToString();
txtCashOutCount1000.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CUROUT1000"]) / 1000).ToString();
txtCashOutCount500.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CUROUT500"]) / 500).ToString();
txtCashOutCount200.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CUROUT200"]) / 200).ToString();
txtCashOutCount100.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CUROUT100"]) / 100).ToString();
txtCashOutCount50.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CUROUT50"]) / 500).ToString();
txtCashOutCount20.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CUROUT20"]) / 20).ToString();
txtCashOutCount10.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CUROUT10"]) / 10).ToString();
txtCashOutCount5.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CUROUT5"]) / 5).ToString();
txtCashOutCount2.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CUROUT2"]) / 2).ToString();
txtCashOutCount1.Text = (Convert.ToDecimal(ds.Tables[0].Rows[0]["CUROUT1"]) / 1).ToString();
}
txtBillBalanceAmount.Text = (TotalMemoAmount - Convert.ToDecimal(txtCardPayment.Text) - Convert.ToDecimal(txtPGPayment.Text)).ToString("0.00");
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
