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);
}
