internal DataTable LoadPartyAccount(UpdCreditNoteModel objUpdCNModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPMasters"; ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdCNModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCNModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCNModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCNModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCNModel.VchType); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtCreditNote = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtCreditNote); dtCreditNote.TableName = "success"; } catch (Exception) { dtCreditNote = new DataTable(); dtCreditNote.TableName = "error"; return(dtCreditNote); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtCreditNote); }
internal DataTable UpdateCreditNote(UpdCreditNoteModel objUpdCNModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPCreditNote"; ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdCNModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCNModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCNModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCNModel.VchType); ClsCon.cmd.Parameters.AddWithValue("@DocDate", objUpdCNModel.VoucherDate); ClsCon.cmd.Parameters.AddWithValue("@GSTOpted", objUpdCNModel.GSTOpted); ClsCon.cmd.Parameters.AddWithValue("@DocDesc", objUpdCNModel.DocDesc); ClsCon.cmd.Parameters.AddWithValue("@EntryType", objUpdCNModel.EntryType); ClsCon.cmd.Parameters.AddWithValue("@User", objUpdCNModel.User); ClsCon.cmd.Parameters.AddWithValue("@IP", objUpdCNModel.IP); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCNModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdCNModel.VoucherNo); ClsCon.cmd.Parameters.AddWithValue("@IssueReasonId", objUpdCNModel.issueReasonId); ClsCon.cmd.Parameters.AddWithValue("@PreGstId", objUpdCNModel.PreGstId); ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUpdCNModel.CCCode); ClsCon.cmd.Parameters.AddWithValue("@TblCredit", objUpdCNModel.DtCreditNote); ClsCon.cmd.Parameters.AddWithValue("@TblItems", objUpdCNModel.DtItems); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtCreditNote = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtCreditNote); dtCreditNote.TableName = "success"; } catch (Exception) { dtCreditNote = new DataTable(); dtCreditNote.TableName = "error"; return(dtCreditNote); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtCreditNote); }
internal DataSet BindAllCreditNote(UpdCreditNoteModel objUpdCNModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPCreditNote"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdCNModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCNModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCNModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCNModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCNModel.VchType); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; DsCreditNote = new DataSet(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(DsCreditNote); DsCreditNote.DataSetName = "success"; DsCreditNote.Tables[0].TableName = "AccountHead"; DsCreditNote.Tables[1].TableName = "Narration"; DsCreditNote.Tables[2].TableName = "LastVoucherNo"; DsCreditNote.Tables[3].TableName = "ItemUnit"; DsCreditNote.Tables[4].TableName = "Issue Reason"; } catch (Exception) { DsCreditNote = new DataSet(); DsCreditNote.DataSetName = "error"; return(DsCreditNote); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(DsCreditNote); }
internal DataTable ItemsBinding(UpdCreditNoteModel objUpdCNModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPCreditNote"; ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdCNModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCNModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCNModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCNModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@PartyCode", objUpdCNModel.PartyCode); ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdCNModel.InvoiceNo); ClsCon.cmd.Parameters.AddWithValue("@DocDate", objUpdCNModel.InvoiceDate); ClsCon.cmd.Parameters.AddWithValue("@ByPurchaseSale", objUpdCNModel.ByPurchaseSale); ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCNModel.VchType); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtCreditNote = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtCreditNote); dtCreditNote.TableName = "success"; } catch (Exception) { dtCreditNote = new DataTable(); dtCreditNote.TableName = "error"; return(dtCreditNote); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtCreditNote); }
internal DataSet SearchData(UpdCreditNoteModel objUpdCNModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPCreditNote"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdCNModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCNModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCNModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdCNModel.YrCD); ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdCNModel.VoucherNo); ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCNModel.VchType); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; DsCreditNote = new DataSet(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(DsCreditNote); DsCreditNote.DataSetName = "success"; } catch (Exception) { DsCreditNote = new DataSet(); DsCreditNote.DataSetName = "error"; return(DsCreditNote); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(DsCreditNote); }
internal DataTable CancelVoucher(UpdCreditNoteModel objUpdCNModel) { try { ClsCon.cmd = new SqlCommand(); ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.CommandText = "SPCreditNote"; ClsCon.cmd.CommandType = CommandType.StoredProcedure; ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdCNModel.Ind); ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdCNModel.OrgID); ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdCNModel.BrID); ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdCNModel.VoucherNo); ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdCNModel.VchType); ClsCon.cmd.Parameters.AddWithValue("@CancelReason", objUpdCNModel.CancelReason); con = ClsCon.SqlConn(); ClsCon.cmd.Connection = con; dtCancel = new DataTable(); ClsCon.da = new SqlDataAdapter(ClsCon.cmd); ClsCon.da.Fill(dtCancel); dtCancel.TableName = "success"; } catch (Exception) { dtCancel = new DataTable(); dtCancel.TableName = "error"; return(dtCancel); } finally { con.Close(); con.Dispose(); ClsCon.da.Dispose(); ClsCon.cmd.Dispose(); } return(dtCancel); }
public DataTable CancelVoucher(UpdCreditNoteModel objUpdCNModel) { DataTable dtCancel = objUpdCnModel.CancelVoucher(objUpdCNModel); return(dtCancel); }
public DataTable UpdateCreditNote(UpdCreditNoteModel objUpdCNModel) { DataTable dtUpdCreditNote = objUpdCnModel.UpdateCreditNote(objUpdCNModel); return(dtUpdCreditNote); }
public DataSet SearchData(UpdCreditNoteModel objUpdCNModel) { DataSet dsSearchdata = objUpdCnModel.SearchData(objUpdCNModel); return(dsSearchdata); }
public DataTable ItemsBinding(UpdCreditNoteModel objUpdCNModel) { DataTable dtItemsBinding = objUpdCnModel.ItemsBinding(objUpdCNModel); return(dtItemsBinding); }
public DataTable FillGistnNo(UpdCreditNoteModel objUpdCNModel) { DataTable dtNarration = objUpdCnModel.FillGistnNo(objUpdCNModel); return(dtNarration); }
public DataTable LoadPartyAccount(UpdCreditNoteModel objUpdCNModel) { DataTable dtPartyAccount = objUpdCnModel.LoadPartyAccount(objUpdCNModel); return(dtPartyAccount); }
public DataSet BindAllCreditNoteDDL(UpdCreditNoteModel objUpdCNModel) { DataSet dsCN = objUpdCnModel.BindAllCreditNote(objUpdCNModel); return(dsCN); }