internal DataTable LoadIncomeHead(UpdateSalesReturnModel objUpdSRModel) //IncomeHeadFill
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objUpdSRModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdSRModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdSRModel.YrCD);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdSalesReturn = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdSalesReturn);
dtUpdSalesReturn.TableName = "success";
}
catch (Exception)
{
dtUpdSalesReturn = new DataTable();
dtUpdSalesReturn.TableName = "error";
return(dtUpdSalesReturn);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdSalesReturn);
}
internal DataTable FillItemSellingRate(UpdateSalesReturnModel objUpdSRModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPItems";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdSRModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdSRModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdSRModel.BrID);
//ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdSRModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@PartyCode", objUpdSRModel.PartyCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objUpdSRModel.GSTIN);
ClsCon.cmd.Parameters.AddWithValue("@ItemID", objUpdSRModel.ItemID);
ClsCon.cmd.Parameters.AddWithValue("@ByCash", objUpdSRModel.ByCashSale);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdSalesReturn = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdSalesReturn);
dtUpdSalesReturn.TableName = "success";
}
catch (Exception)
{
dtUpdSalesReturn = new DataTable();
dtUpdSalesReturn.TableName = "error";
return(dtUpdSalesReturn);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdSalesReturn);
}
internal DataTable FillShippingAddress(UpdateSalesReturnModel objUpdSRModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSearchByAccount";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdSRModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdSRModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdSRModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdSRModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", objUpdSRModel.AccCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objUpdSRModel.GSTIN);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdSalesReturn = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdSalesReturn);
dtUpdSalesReturn.TableName = "success";
}
catch (Exception)
{
dtUpdSalesReturn = new DataTable();
dtUpdSalesReturn.TableName = "error";
return(dtUpdSalesReturn);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdSalesReturn);
}
internal DataSet LoadSRBasicDetails(UpdateSalesReturnModel objUpdSRModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdateSalesReturnVoucher";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdSRModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdSRModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdSRModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdSRModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdSRModel.DocNo);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsUpdSalesReturn = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsUpdSalesReturn);
dsUpdSalesReturn.DataSetName = "success";
}
catch (Exception)
{
dsUpdSalesReturn = new DataSet();
dsUpdSalesReturn.DataSetName = "error";
return(dsUpdSalesReturn);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsUpdSalesReturn);
}
public DataTable LastVoucherNo(UpdateSalesReturnModel objUpdSRModel)
{
DataTable AccHeadList = objUpdSRDA.LastVoucherNo(objUpdSRModel);
return(AccHeadList);
}
public DataTable FillShippingAddress(UpdateSalesReturnModel objUpdSRModel)
{
DataTable ItemList = objUpdSRDA.FillShippingAddress(objUpdSRModel);
return(ItemList);
}
public DataTable FillItemSellingRate(UpdateSalesReturnModel objUpdSRModel)
{
DataTable ItemList = objUpdSRDA.FillItemSellingRate(objUpdSRModel);
return(ItemList);
}
public DataTable FillItemName(UpdateSalesReturnModel objUpdSRModel)
{
DataTable dtFillItemName = objUpdSRDA.FillItemName(objUpdSRModel);
return(dtFillItemName);
}
public DataTable InvoiceSeries(UpdateSalesReturnModel objUpdSRModel)
{
DataTable dtLastVoucherNo = objUpdSRDA.InvoiceSeries(objUpdSRModel);
return(dtLastVoucherNo);
}
public DataTable SalesTo(UpdateSalesReturnModel objUpdSRModel)
{
DataTable dtSalesTo = objUpdSRDA.LoadSalesTo(objUpdSRModel);
return(dtSalesTo);
}
public DataTable IncomeHead(UpdateSalesReturnModel objUpdSRModel)
{
DataTable IncomeHeadList = objUpdSRDA.LoadIncomeHead(objUpdSRModel);
return(IncomeHeadList);
}
public DataTable LoadNarration(UpdateSalesReturnModel objUpdSRModel)
{
DataTable NarrationList = objUpdSRDA.LoadNarration(objUpdSRModel);
return(NarrationList);
}
public DataTable UpdateSalesReturnVoucher(UpdateSalesReturnModel objUpdSRModel)
{
DataTable AccHeadList = objUpdSRDA.UpdateSalesReturnVoucher(objUpdSRModel);
return(AccHeadList);
}
public DataSet LoadSRBasicDetails(UpdateSalesReturnModel objUpdSRModel)
{
DataSet dsSRBasicDetails = objUpdSRDA.LoadSRBasicDetails(objUpdSRModel);
return(dsSRBasicDetails);
}
public DataSet FillItemSellRate(UpdateSalesReturnModel objUpdSRModel)
{
DataSet ItemList = objUpdSRDA.FillItemSellRate(objUpdSRModel);
return(ItemList);
}
public DataSet BindAll(UpdateSalesReturnModel objUpdSRModel)
{
DataSet dsBindAll = objUpdSRDA.BindAll(objUpdSRModel);
return(dsBindAll);
}
public DataTable FillLocation(UpdateSalesReturnModel objUpdSRModel)
{
DataTable dtFillLocation = objUpdSRDA.Filllocation(objUpdSRModel);
return(dtFillLocation);
}
public DataTable FillGistnNo(UpdateSalesReturnModel objUpdSRModel)
{
DataTable IncomeHeadList = objUpdSRDA.FillGistnNo(objUpdSRModel);
return(IncomeHeadList);
}
internal DataTable UpdateSalesReturnVoucher(UpdateSalesReturnModel objUpdSRModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdateSalesReturnVoucher";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdSRModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdSRModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdSRModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdSRModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdSRModel.VchType);
ClsCon.cmd.Parameters.AddWithValue("@EntryType", objUpdSRModel.EntryType);
ClsCon.cmd.Parameters.AddWithValue("@User", objUpdSRModel.User);
ClsCon.cmd.Parameters.AddWithValue("@IP", objUpdSRModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", objUpdSRModel.ByCashSale);
ClsCon.cmd.Parameters.AddWithValue("@PartyName", objUpdSRModel.PartyName);
ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", objUpdSRModel.PartyGSTIN);
ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", objUpdSRModel.PartyAddress);
ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", objUpdSRModel.WareHouseID);
ClsCon.cmd.Parameters.AddWithValue("@TransName", objUpdSRModel.TransName);
ClsCon.cmd.Parameters.AddWithValue("@PONo", objUpdSRModel.PONo);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdSRModel.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@DocDate", objUpdSRModel.DocDate);
ClsCon.cmd.Parameters.AddWithValue("@InvoiceSeries", objUpdSRModel.InvoiceSeries);
ClsCon.cmd.Parameters.AddWithValue("@PurchaseSalesRecordID", objUpdSRModel.PurchaseSalesRecordID);
ClsCon.cmd.Parameters.AddWithValue("@OrgVoucherNo", objUpdSRModel.OrgVoucherNo);
ClsCon.cmd.Parameters.AddWithValue("@OrgVoucherDate", objUpdSRModel.OrgVoucherDate);
ClsCon.cmd.Parameters.AddWithValue("@CCCode", objUpdSRModel.CCCode);
ClsCon.cmd.Parameters.AddWithValue("@TblSale", objUpdSRModel.DtSales);
ClsCon.cmd.Parameters.AddWithValue("@TblItems", objUpdSRModel.DtItems);
ClsCon.cmd.Parameters.AddWithValue("@TblSundries", objUpdSRModel.DtSundries);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdSalesReturn = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdSalesReturn);
dtUpdSalesReturn.TableName = "success";
}
catch (Exception)
{
dtUpdSalesReturn = new DataTable();
dtUpdSalesReturn.TableName = "error";
return(dtUpdSalesReturn);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdSalesReturn);
}
public DataTable FillTransportation(UpdateSalesReturnModel objUpdSRModel)
{
DataTable dtLastVoucherNo = objUpdSRDA.FillTransportation(objUpdSRModel);
return(dtLastVoucherNo);
}