private void SaveVoucherDetails() { BusinessLayer.Accounts.TrnDebitNoteHeader objDebitNote = new TrnDebitNoteHeader(); Entity.Accounts.TrnDebitNoteHeader DebitNote = new Entity.Accounts.TrnDebitNoteHeader(); DebitNote.DNHeaderID = DNHeaderID; DebitNote.CompanyID_FK = Convert.ToInt32(Session["CompanyId"].ToString().Trim()); DebitNote.FinYearID_FK = Convert.ToInt32(Session["FinYrID"].ToString().Trim()); DebitNote.BranchID_FK = Convert.ToInt32(Session["BranchId"].ToString().Trim()); DebitNote.DNVoucherDate = Convert.ToDateTime(txtVoucherDate.Text.Trim() + " 00:00:00"); DebitNote.SupplierLedgerID_FK = Convert.ToInt32(ddlSupplierLedger.SelectedValue.Trim()); DebitNote.TotalAmount = Convert.ToDecimal(txtTotalAmt.Text.Trim()); DebitNote.DNNarration = txtNarration.Text.Trim(); DebitNote.OperationBy = Convert.ToInt32(Session["UserId"].ToString().Trim()); DebitNote.XMLDebitNoteDetails = PrepareXMLString(); int RowsAffected = objDebitNote.Save(DebitNote); if (RowsAffected != -1) { PopulateHeaderGrid(); LoadDueBills(); txtNarration.Text = ""; DataTable DT = objDebitNote.GetAllById(DebitNote.DNHeaderID); txtVchNo.Text = DT.Rows[0]["DNVoucherNo"].ToString(); Message.IsSuccess = true; Message.Text = "Your request has been processed successfully!"; btnPrint.Attributes.Add("onclick", "javascript:openPopup('PrintDebitNote.aspx?id=" + DebitNote.DNHeaderID + "'); return false;"); } Message.Show = true; }
public static int Save(Entity.Accounts.TrnDebitNoteHeader DebitNote) { using (DataManager oDm = new DataManager()) { oDm.Add("@DNHeaderID", SqlDbType.Int, ParameterDirection.InputOutput, DebitNote.DNHeaderID); oDm.Add("@CompanyID_FK", SqlDbType.Int, ParameterDirection.Input, DebitNote.CompanyID_FK); oDm.Add("@FinYearID_FK", SqlDbType.Int, ParameterDirection.Input, DebitNote.FinYearID_FK); oDm.Add("@BranchID_FK", SqlDbType.Int, ParameterDirection.Input, DebitNote.BranchID_FK); oDm.Add("@DNVoucherDate", SqlDbType.DateTime, ParameterDirection.Input, DebitNote.DNVoucherDate); oDm.Add("@SupplierLedgerID_FK", SqlDbType.Int, ParameterDirection.Input, DebitNote.SupplierLedgerID_FK); oDm.Add("@TotalAmount", SqlDbType.Decimal, ParameterDirection.Input, DebitNote.TotalAmount); oDm.Add("@DNNarration", SqlDbType.NVarChar, 4000, ParameterDirection.Input, DebitNote.DNNarration); oDm.Add("@OperationBy", SqlDbType.Int, ParameterDirection.Input, DebitNote.OperationBy); oDm.Add("@XMLDebitNoteDetails", SqlDbType.NText, ParameterDirection.Input, DebitNote.XMLDebitNoteDetails); oDm.CommandType = CommandType.StoredProcedure; int RowsAffected = oDm.ExecuteNonQuery("usp_TrnDebitNoteHeader_Save"); DebitNote.DNHeaderID = (int)oDm["@DNHeaderID"].Value; return(RowsAffected); } }
public int Save(Entity.Accounts.TrnDebitNoteHeader DebitNote) { return(DataAccess.Accounts.TrnDebitNoteHeader.Save(DebitNote)); }