public DataSet BindAllDebitNoteDDL(UpdDebitNoteModel objUpdDNModel)
{
///objDNModel.Ind = 11;
DataSet dsDN = objUpdDebitNoteDA.BindAllDebitNote(objUpdDNModel);
dsDN.Tables[0].TableName = "AccountHead";
dsDN.Tables[1].TableName = "Narration";
dsDN.Tables[2].TableName = "LastVoucherNo";
dsDN.Tables[3].TableName = "ItemUnit";
dsDN.Tables[4].TableName = "Issue Reason";
return(dsDN);
}
internal DataTable UpdateDebitNote(UpdDebitNoteModel objUpdDNModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPDebitNote";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdDNModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdDNModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdDNModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdDNModel.VchType);
ClsCon.cmd.Parameters.AddWithValue("@DocDate", objUpdDNModel.VoucherDate);
ClsCon.cmd.Parameters.AddWithValue("@GSTOpted", objUpdDNModel.GSTOpted);
ClsCon.cmd.Parameters.AddWithValue("@DocDesc", objUpdDNModel.DocDesc);
ClsCon.cmd.Parameters.AddWithValue("@EntryType", objUpdDNModel.EntryType);
ClsCon.cmd.Parameters.AddWithValue("@User", objUpdDNModel.User);
ClsCon.cmd.Parameters.AddWithValue("@IP", objUpdDNModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdDNModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdDNModel.VoucherNo);
ClsCon.cmd.Parameters.AddWithValue("@IssueReasonId", objUpdDNModel.issueReasonId);
ClsCon.cmd.Parameters.AddWithValue("@PreGstId", objUpdDNModel.PreGstId);
ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUpdDNModel.CCCode);
ClsCon.cmd.Parameters.AddWithValue("@TblDebit", objUpdDNModel.DtDebitNote);
ClsCon.cmd.Parameters.AddWithValue("@TblItems", objUpdDNModel.DtItems);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtDebitNote = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtDebitNote);
dtDebitNote.TableName = "success";
}
catch (Exception)
{
dtDebitNote = new DataTable();
dtDebitNote.TableName = "error";
return(dtDebitNote);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtDebitNote);
}
internal DataTable ItemsBinding(UpdDebitNoteModel objUpdDNModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPDebitNote";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdDNModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdDNModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdDNModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdDNModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@PartyCode", objUpdDNModel.PartyCode);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdDNModel.InvoiceNo);
ClsCon.cmd.Parameters.AddWithValue("@DocDate", objUpdDNModel.InvoiceDate);
ClsCon.cmd.Parameters.AddWithValue("@ByPurchaseSale", objUpdDNModel.ByPurchaseSale);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdDNModel.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtDebitNote = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtDebitNote);
dtDebitNote.TableName = "success";
}
catch (Exception)
{
dtDebitNote = new DataTable();
dtDebitNote.TableName = "error";
return(dtDebitNote);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtDebitNote);
}
internal DataSet SearchData(UpdDebitNoteModel objUpdDNModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPDebitNote";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdDNModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdDNModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdDNModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdDNModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdDNModel.VoucherNo);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdDNModel.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsDebitNote = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsDebitNote);
dsDebitNote.DataSetName = "success";
}
catch (Exception)
{
dsDebitNote = new DataSet();
dsDebitNote.DataSetName = "error";
return(dsDebitNote);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsDebitNote);
}
internal DataTable FillGistnNo(UpdDebitNoteModel objUpdDNModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSearchByAccount";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdDNModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdDNModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdDNModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdDNModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", objUpdDNModel.AccCode);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtDebitNote = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtDebitNote);
dtDebitNote.TableName = "success";
}
catch (Exception)
{
dtDebitNote = new DataTable();
dtDebitNote.TableName = "error";
return(dtDebitNote);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtDebitNote);
}
public DataTable UpdateDebitNote(UpdDebitNoteModel objUpdDNModel)
{
DataTable dtUpdDebitNote = objUpdDebitNoteDA.UpdateDebitNote(objUpdDNModel);
return(dtUpdDebitNote);
}
public DataSet SearchData(UpdDebitNoteModel objUpdDNModel)
{
DataSet dsSearchdata = objUpdDebitNoteDA.SearchData(objUpdDNModel);
return(dsSearchdata);
}
public DataTable FillGistnNo(UpdDebitNoteModel objUpdDNModel)
{
DataTable dtNarration = objUpdDebitNoteDA.FillGistnNo(objUpdDNModel);
return(dtNarration);
}
public DataTable LoadPartyAccount(UpdDebitNoteModel objUpdDNModel)
{
DataTable dtPartyAccount = objUpdDebitNoteDA.LoadPartyAccount(objUpdDNModel);
return(dtPartyAccount);
}
