public void AddCashRelease(CashReleaseUnit oUnit) { SqlCommand oCommand = new SqlCommand(); oCommand.Connection = this.Connection; oCommand.CommandText = "INSERT INTO LOAN3 (DocNum, RefNo, TypeOfPayment, SourceOfFund, ChequeNo, Amount, DateCreated, CreatedBy, DateModified, ModifiedBy) VALUES (@DocNum, @RefNo, @TypeOfPayment, @SourceOfFund, @ChequeNo, @Amount, @DateCreated, @CreatedBy, @DateModified, @ModifiedBy)"; oCommand.Parameters.Add(new SqlParameter("@DocNum", oUnit.DocNum)); oCommand.Parameters.Add(new SqlParameter("@RefNo", oUnit.ReleaseNo)); oCommand.Parameters.Add(new SqlParameter("@TypeOfPayment", oUnit.TypeOfPayment)); oCommand.Parameters.Add(new SqlParameter("@SourceOfFund", oUnit.SourceOfFund)); oCommand.Parameters.Add(new SqlParameter("@ChequeNo", oUnit.ChequeNo)); oCommand.Parameters.Add(new SqlParameter("@Amount", oUnit.Amount)); oCommand.Parameters.Add(new SqlParameter("@DateCreated", oUnit.DateCreated)); oCommand.Parameters.Add(new SqlParameter("@CreatedBy", oUnit.CreatedBy)); oCommand.Parameters.Add(new SqlParameter("@DateModified", oUnit.DateModified)); oCommand.Parameters.Add(new SqlParameter("@ModifiedBy", oUnit.ModifiedBy)); oCommand.ExecuteNonQuery(); }
public void UpdateCashRelease(CashReleaseUnit oUnit) { SqlCommand oCommand = new SqlCommand(); oCommand.Connection = this.Connection; oCommand.CommandText = "UPDATE LOAN3 SET DocNum=@DocNum, TypeOfPayment=@TypeOfPayment, SourceOfFund=@SourceOfFund, ChequeNo=@ChequeNo, Amount=@Amount, DateModified=@DateModified, ModifiedBy=@ModifiedBy WHERE ReleaseNo=@ReleaseNo"; oCommand.Parameters.Add(new SqlParameter("@DocNum", oUnit.DocNum)); oCommand.Parameters.Add(new SqlParameter("@RefNo", oUnit.ReleaseNo)); oCommand.Parameters.Add(new SqlParameter("@TypeOfPayment", oUnit.TypeOfPayment)); oCommand.Parameters.Add(new SqlParameter("@SourceOfFund", oUnit.SourceOfFund)); oCommand.Parameters.Add(new SqlParameter("@ChequeNo", oUnit.ChequeNo)); oCommand.Parameters.Add(new SqlParameter("@Amount", oUnit.Amount)); oCommand.Parameters.Add(new SqlParameter("@DateModified", oUnit.DateModified)); oCommand.Parameters.Add(new SqlParameter("@ModifiedBy", oUnit.ModifiedBy)); oCommand.ExecuteNonQuery(); }
private void btnAdd_Click(object sender, EventArgs e) { if (cboTypeOfPayment.SelectedIndex == -1) { MessageBox.Show("Please select type of Payment!!!", "Fund", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (cboSourceOfFund.EditValue == null) { MessageBox.Show("Please select fund!!!", "Fund", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (btnAdd.Text == "Add") { CashReleaseManager oManager = new CashReleaseManager(); CashReleaseUnit oUnit = new CashReleaseUnit(); oManager.ConnectionString = this.ConnectionString; oManager.Open(); oUnit.ReleaseNo = txtReleaseNo.Text; oUnit.DocNum = txtLoanNo.Text; oUnit.ChequeNo = txtCheckNo.Text; oUnit.TypeOfPayment = cboTypeOfPayment.Text; oUnit.SourceOfFund = cboSourceOfFund.EditValue == null ? "" : cboSourceOfFund.EditValue.ToString(); oUnit.Amount = Convert.ToDouble(txtAmount.Text); oUnit.CreatedBy = this.ActiveUserID; oUnit.DateCreated = (DateTime)dtCreated.EditValue; oUnit.ModifiedBy = this.ActiveUserID; oUnit.DateModified = (DateTime)dtModified.EditValue; oManager.AddCashRelease(oUnit); oManager.Close(); this.Close(); } else if (btnAdd.Text == "Update") { CashReleaseManager oManager = new CashReleaseManager(); CashReleaseUnit oUnit = new CashReleaseUnit(); oManager.ConnectionString = this.ConnectionString; oManager.Open(); oUnit.ReleaseNo = txtReleaseNo.Text; oUnit.DocNum = txtLoanNo.Text; oUnit.ChequeNo = txtCheckNo.Text; oUnit.TypeOfPayment = cboTypeOfPayment.Text; oUnit.SourceOfFund = cboSourceOfFund.EditValue.ToString(); oUnit.Amount = Convert.ToDouble(txtAmount.Text); oUnit.CreatedBy = this.ActiveUserID; oUnit.DateCreated = (DateTime)dtCreated.EditValue; oUnit.ModifiedBy = this.ActiveUserID; oUnit.DateModified = (DateTime)dtModified.EditValue; oManager.UpdateCashRelease(oUnit); oManager.Close(); } }