private string SetHeaderDatatoClass(out AccountTypes.Payment_GeneralDataType _SaveHeader) { _SaveHeader = new AccountTypes.Payment_GeneralDataType(); try { _SaveHeader.AccountID = MyCommon.GetSelectedID(cmbFromAcc, true); _SaveHeader.ChequeNumber = cmbMethodObg.Text; _SaveHeader.Cr = decimal.Parse(txtToalAmountLKR.Text); _SaveHeader.CurRate = decimal.Parse(txtExRate.Text); _SaveHeader.Description = txtfromMemo.Text; _SaveHeader.FCr = decimal.Parse(txtToalAmountFCR.Text); _SaveHeader.PaymentID = txtPVNno.Text; _SaveHeader.PaymentMethod = int.Parse(MyCommon.GetSelectedID(cmbPayMethod, true)); _SaveHeader.PayStatus = 0; _SaveHeader.TrUser = Program.AccountStatic.UserName; _SaveHeader.CompanyID = Program.AccountStatic.CompanyID; _SaveHeader.AccPeriod = Program.AccountStatic.CurrentAccPeriod; _SaveHeader.PayToCatID = int.Parse(MyCommon.GetSelectedID(cmbPayFor, true)); _SaveHeader.PayToName = cmbPayTo.Text; _SaveHeader.PayActualDate = dtpPVNDate.Value; if (chkAsAdvancePayment.Checked) _SaveHeader.IsAdvancePayment = 1; else _SaveHeader.IsAdvancePayment = 0; List<AccountTypes.Payment_GeneralDetailsDataType> _SaveDetailList; string respond = SetDetailDataToClass(out _SaveDetailList); _SaveHeader.Details = _SaveDetailList; return "True"; } catch (Exception ex) { return ex.Message; } }
private void btnUpdate_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you want to Update current record ? ", "Confirmation ", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { int VoucherStatus = MyPay.GetPVNStatus(txtPVNno.Text); switch (VoucherStatus) { case 3: Program.InformationMessage("Already Accounted, cannot chage"); break; default: if (MyPay.ExistPayment_General(txtPVNno.Text)) { AccountTypes.Payment_GeneralDataType _SaveHeader = new AccountTypes.Payment_GeneralDataType(); string respond = ""; string PVN = ""; string SelItem = MyCommon.GetSelectedID(cmbPayFor, true); if (SelItem == "5") { MyAccount.SaveotherPayee(cmbPayTo.Text, lblAddress.Text); } respond = SetHeaderDatatoClass(out _SaveHeader); if (respond == "True") { respond = MyPay.UpdatePayment_General(_SaveHeader); if (respond == "True") { LoadExtPaymentList(); MessageBox.Show("Data Updated Successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { txtPVNno.Text = ""; Program.VerningMessage(respond); } } else Program.VerningMessage(respond); } else { Program.VerningMessage("Use Save Button"); } break; } } }
public string GetExistPayment_General(string PaymentID, out AccountTypes.Payment_GeneralDataType _ExistData) { _ExistData = new AccountTypes.Payment_GeneralDataType(); MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Select " + "PaymentID," + "PaymentMethod," + "Description," + "AccountID," + "CurRate," + "Cr," + "FCr," + "PayStatus," + "TrRef," + "TrUser," + "TrDate," + "TrTime," + "ChequeNumber,PayToCatID,PayToName,PayActualDate,AccPeriod,CompanyID,IsAdvancePayment" + " from tblpayment" + " Where 1=1 " + " and PaymentID=@PaymentID"; oSqlCommand.Parameters.AddWithValue("@PaymentID", PaymentID); DataRow r = Mycommon.GetDataRowAccount(sqlQuery, oSqlCommand, "Get Exist data Payment_General"); if (r != null) { try { bool resp = false; _ExistData.PaymentID = r["PaymentID"].ToString(); int inPaymentMethod = 0; resp = int.TryParse(r["PaymentMethod"].ToString(), out inPaymentMethod); _ExistData.PaymentMethod = inPaymentMethod; _ExistData.Description = r["Description"].ToString(); _ExistData.AccountID = r["AccountID"].ToString(); decimal deCurRate = 0; resp = decimal.TryParse(r["CurRate"].ToString(), out deCurRate); _ExistData.CurRate = deCurRate; decimal deCr = 0; resp = decimal.TryParse(r["Cr"].ToString(), out deCr); _ExistData.Cr = deCr; decimal deFCr = 0; resp = decimal.TryParse(r["FCr"].ToString(), out deFCr); _ExistData.FCr = deFCr; int inPayStatus = 0; resp = int.TryParse(r["PayStatus"].ToString(), out inPayStatus); _ExistData.PayStatus = inPayStatus; _ExistData.TrRef = r["TrRef"].ToString(); _ExistData.TrUser = r["TrUser"].ToString(); DateTime dtTrDate = new DateTime(1900, 1, 1); resp = DateTime.TryParse(r["TrDate"].ToString(), out dtTrDate); if (resp) _ExistData.TrDate = dtTrDate; else _ExistData.TrDate = new DateTime(1900, 1, 1); _ExistData.TrTime = r["TrTime"].ToString(); _ExistData.ChequeNumber = r["ChequeNumber"].ToString(); _ExistData.PayToName = r["PayToName"].ToString(); int inPayToCatID = 0; resp = int.TryParse(r["PayToCatID"].ToString(), out inPayToCatID); _ExistData.PayToCatID = inPayToCatID; DateTime dtPayActualDate = new DateTime(1900, 1, 1); resp = DateTime.TryParse(r["PayActualDate"].ToString(), out dtPayActualDate); if (resp) _ExistData.PayActualDate = dtPayActualDate; else _ExistData.PayActualDate = new DateTime(1900, 1, 1); //AccPeriod int inAccPeriod = 0; resp = int.TryParse(r["AccPeriod"].ToString(), out inAccPeriod); _ExistData.AccPeriod = inAccPeriod; int inCompanyID = 0; resp = int.TryParse(r["CompanyID"].ToString(), out inCompanyID); _ExistData.CompanyID = inCompanyID; //IsAdvancePayment int inIsAdvancePayment = 0; resp = int.TryParse(r["IsAdvancePayment"].ToString(), out inIsAdvancePayment); _ExistData.IsAdvancePayment = inIsAdvancePayment; List<AccountTypes.Payment_GeneralDetailsDataType> _Exlist = new List<AccountTypes.Payment_GeneralDetailsDataType>(); string respond1 = GetPaymentDetailList(PaymentID, out _Exlist); _ExistData.Details = _Exlist; return "True"; } catch (Exception ex) { return ex.Message; } } else return "data not found "; }