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 = MyReceipt.GetReceiptStatus(txtRcptNumber.Text); switch (VoucherStatus) { case 3: Program.InformationMessage("Already Accounted, cannot chage"); break; default: if (MyReceipt.ExistReceipt(txtRcptNumber.Text)) { REceiptTypes.ReceiptDataType _SaveHeader = new REceiptTypes.ReceiptDataType(); string respond = ""; string Rcpt = ""; string SelItem = MyCommon.GetSelectedID(cmbPayFor, true); if (SelItem == "5") { MyAccount.SaveotherPayee(cmbPayTo.Text, lblAddress.Text); } respond = SetHeaderDatatoClass(out _SaveHeader); if (respond == "True") { respond = MyReceipt.Update (_SaveHeader); if (respond == "True") { LoadExtPaymentList(); MessageBox.Show("Data Saved Successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { txtRcptNumber.Text = ""; Program.VerningMessage(respond); } } } else { Program.VerningMessage("Use Update Button"); } break; } } }
public string GetExistReceipt(string ReceiptID, out REceiptTypes.ReceiptDataType _ExistData) { _ExistData = new REceiptTypes.ReceiptDataType(); MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Select " + "ReceiptID," + "ReceiptMethod," + "Description," + "AccountID," + "CurRate," + "Dr," + "FDr," + "ReceiptStatus," + "TrRef," + "TrUser," + "TrDate," + "TrTime," + "ChequeNumber," + "AccPeriod," + "CompanyID," + "RcptFromCatID," + "RcptFromName," + "RcptActualDate," + "ApproveBy," + "ApproveDate," + "ApproveTime," + "AcountedBy," + "AccountDate," + "AccountedTime" + " from tblreceipt" + " Where 1=1 " + " and ReceiptID=@ReceiptID"; oSqlCommand.Parameters.AddWithValue("@ReceiptID", ReceiptID); DataRow r = Mycommon.GetDataRowAccount(sqlQuery, oSqlCommand, "Get Exist data Receipt"); if (r != null) { try { bool resp = false; _ExistData.ReceiptID = r["ReceiptID"].ToString(); int inReceiptMethod = 0; resp = int.TryParse(r["ReceiptMethod"].ToString(), out inReceiptMethod); _ExistData.ReceiptMethod = inReceiptMethod; _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 deDr = 0; resp = decimal.TryParse(r["Dr"].ToString(), out deDr); _ExistData.Dr = deDr; decimal deFDr = 0; resp = decimal.TryParse(r["FDr"].ToString(), out deFDr); _ExistData.FDr = deFDr; int inReceiptStatus = 0; resp = int.TryParse(r["ReceiptStatus"].ToString(), out inReceiptStatus); _ExistData.ReceiptStatus = inReceiptStatus; _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(); 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; int inRcptFromCatID = 0; resp = int.TryParse(r["RcptFromCatID"].ToString(), out inRcptFromCatID); _ExistData.RcptFromCatID = inRcptFromCatID; _ExistData.RcptFromName = r["RcptFromName"].ToString(); DateTime dtRcptActualDate = new DateTime(1900, 1, 1); resp = DateTime.TryParse(r["RcptActualDate"].ToString(), out dtRcptActualDate); if (resp) _ExistData.RcptActualDate = dtRcptActualDate; else _ExistData.RcptActualDate = new DateTime(1900, 1, 1); _ExistData.ApproveBy = r["ApproveBy"].ToString(); DateTime dtApproveDate = new DateTime(1900, 1, 1); resp = DateTime.TryParse(r["ApproveDate"].ToString(), out dtApproveDate); if (resp) _ExistData.ApproveDate = dtApproveDate; else _ExistData.ApproveDate = new DateTime(1900, 1, 1); _ExistData.ApproveTime = r["ApproveTime"].ToString(); _ExistData.AcountedBy = r["AcountedBy"].ToString(); DateTime dtAccountDate = new DateTime(1900, 1, 1); resp = DateTime.TryParse(r["AccountDate"].ToString(), out dtAccountDate); if (resp) _ExistData.AccountDate = dtAccountDate; else _ExistData.AccountDate = new DateTime(1900, 1, 1); _ExistData.AccountedTime = r["AccountedTime"].ToString(); List <REceiptTypes.ReceiptDetailsDataType> _ExtDetails=new List<REceiptTypes.ReceiptDetailsDataType>(); string rsp = GetReceiptList(ReceiptID, out _ExtDetails); _ExistData.ReceiptList = _ExtDetails; return "True"; } catch (Exception ex) { return ex.Message; } } else return "data not found "; }
private string SetHeaderDatatoClass(out REceiptTypes.ReceiptDataType _SaveHeader) { _SaveHeader = new REceiptTypes.ReceiptDataType(); try { _SaveHeader.AccountID = MyCommon.GetSelectedID(cmbFromAcc, true); _SaveHeader.ChequeNumber = cmbMethodObg.Text; _SaveHeader.Dr = decimal.Parse(txtToalAmountLKR.Text); _SaveHeader.CurRate = decimal.Parse(txtExRate.Text); _SaveHeader.Description = txtfromMemo.Text; _SaveHeader.FDr = decimal.Parse(txtToalAmountFCR.Text); _SaveHeader.ReceiptID = txtRcptNumber.Text; _SaveHeader.ReceiptMethod = int.Parse(MyCommon.GetSelectedID(cmbPayMethod, true)); _SaveHeader.ReceiptStatus = 0; _SaveHeader.TrUser = Program.AccountStatic.UserName; _SaveHeader.CompanyID = Program.AccountStatic.CompanyID; _SaveHeader.AccPeriod = Program.AccountStatic.CurrentAccPeriod; _SaveHeader.RcptFromCatID = int.Parse(MyCommon.GetSelectedID(cmbPayFor, true)); _SaveHeader.RcptFromName = cmbPayTo.Text; _SaveHeader.RcptActualDate = dtpPVNDate.Value; List<REceiptTypes.ReceiptDetailsDataType> _SaveDetailList; string respond = SetDetailDataToClass(out _SaveDetailList); _SaveHeader.ReceiptList = _SaveDetailList; return "True"; } catch (Exception ex) { return ex.Message; } }