public void UpdateRecord(Objects.BankIssues obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_BankIssuesUpdate"; cmd.Parameters.AddWithValue("@IssueID", obj.IssueID); cmd.Parameters.AddWithValue("@IssueDate", obj.IssueDate); cmd.Parameters.AddWithValue("@ChequeNo", obj.ChequeNo); cmd.Parameters.AddWithValue("@ChequeDate", obj.ChequeDate); cmd.Parameters.AddWithValue("@BankAccountNo", obj.BankAccountNo); cmd.Parameters.AddWithValue("@Amount", obj.Amount); cmd.Parameters.AddWithValue("@ReceivedBy", obj.ReceivedBy); cmd.Parameters.AddWithValue("@IsLost", obj.IsLost); cmd.Parameters.AddWithValue("@Narration", obj.Narration); cmd.Parameters.AddWithValue("@UserID", obj.UserID); cmd.Parameters.AddWithValue("@EntryDate", obj.EntryDate); cmd.Parameters.AddWithValue("@IsPosted", obj.IsPosted); cmd.Parameters.AddWithValue("@WHTAccountNo", obj.WHTAccountNo); cmd.Parameters.AddWithValue("@WHTAmount", obj.WHTAmount); new Database(connectionstring).ExecuteNonQueryOnly(cmd); } catch (Exception exc) { throw exc; } }
private void btnSave_Click(object sender, EventArgs e) { try { string vMessage = string.Empty; if (txtCheqNo.Text.Trim() == string.Empty) { vMessage = "Please Enter Cheque Number."; new Speak().SayIt(vMessage); MessageBox.Show(vMessage, "Information Missing"); txtCheqNo.Focus(); return; } if (txtBankAccName.Text.Trim() == string.Empty) { vMessage = "Please Select Bank Account."; new Speak().SayIt(vMessage); MessageBox.Show(vMessage, "Information Missing"); txtBankAccNo.Focus(); return; } Int64 vAmount, vChqAmount, vWHTAmnt; Int64.TryParse(txtTotalAmount.Text, out vAmount); Int64.TryParse(txtTotalCheqAmount.Text, out vChqAmount); Int64.TryParse(txtWHTAmount.Text, out vWHTAmnt); if (vAmount != vChqAmount) { vMessage = "Amount Detail not equal to Total Cheques Amount."; new Speak().SayIt(vMessage); MessageBox.Show(vMessage, "Information Missing"); txtAccountNo.Focus(); return; } if (Grid.Rows.Count == 0) { vMessage = "Amount Detail not entered."; new Speak().SayIt(vMessage); MessageBox.Show(vMessage, "Information Missing"); txtAccountNo.Focus(); return; } Int64.TryParse(txtChqAmount.Text, out vChqAmount); Objects.BankIssues obj = new Objects.BankIssues(); obj.IssueID = Int64.Parse(txtID.Text); obj.IssueDate = dtDepositDate.Value; obj.BankAccountNo = txtBankAccNo.Text; obj.Amount = vChqAmount; obj.WHTAccountNo = "200000"; obj.WHTAmount = vWHTAmnt; obj.ReceivedBy = txtReceivedby.Text; obj.Narration = txtNarration.Text; DAL.Settings obSet = new DAL.Settings(); obSet.connectionstring = objDAL.connectionstring; obj.IsPosted = Convert.ToBoolean(obSet.GetSettingValue(DAL.Settings.ProSettings.IsAutoPost)); obj.UserID = vUserID; obj.EntryDate = DateTime.Now.Date; obj.ChequeDate = dtCheqDate.Value; obj.ChequeNo = txtCheqNo.Text; obj.IsLost = false; if (!vOpenMode) { //Insert Activity obj.IssueID = Int64.Parse(objDAL.getNextNo().ToString()); objDAL.DeleteRecordBody(obj.IssueID); objDAL.InsertRecord(obj); } else { objDAL.DeleteRecordBody(obj.IssueID); objDAL.UpdateRecord(obj); } //Save Detail foreach (DataGridViewRow dr in Grid.Rows) { if (dr.Cells[0].Value != null) { Objects.BankIssueBody objDon = new Objects.BankIssueBody(); objDon.IssueID = obj.IssueID; objDon.AccountNo = dr.Cells["AccountNo"].Value.ToString(); objDon.Amount = decimal.Parse(dr.Cells["Amount"].Value.ToString()); objDAL.InsertRecordBody(objDon); } } vMessage = "Record Saved Successfully."; new Speak().SayIt(vMessage); MessageBox.Show(vMessage, "Confirmation"); PrintVoucher(obj.IssueID); btnClear_Click(sender, e); } catch (Exception exc) { MessageBox.Show(exc.Message.ToString(), "Error"); } }