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); } }