internal DataTable LoadIncomeHead(CompositionSalesModel ObjCompositionSalesModel) //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", ObjCompositionSalesModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjCompositionSalesModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjCompositionSalesModel.YrCD);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtSales = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtSales);
dtSales.TableName = "success";
}
catch (Exception)
{
dtSales = new DataTable();
dtSales.TableName = "error";
return(dtSales);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtSales);
}
internal DataTable CancelSalesVoucherNo(CompositionSalesModel ObjCompositionSalesModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSaleVoucher";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjCompositionSalesModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjCompositionSalesModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjCompositionSalesModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjCompositionSalesModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjCompositionSalesModel.VchType);
ClsCon.cmd.Parameters.AddWithValue("@EntryType", ObjCompositionSalesModel.EntryType);
ClsCon.cmd.Parameters.AddWithValue("@User", ObjCompositionSalesModel.User);
ClsCon.cmd.Parameters.AddWithValue("@IP", ObjCompositionSalesModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", ObjCompositionSalesModel.ByCashSale);
ClsCon.cmd.Parameters.AddWithValue("@PartyName", ObjCompositionSalesModel.PartyName);
ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", ObjCompositionSalesModel.PartyGSTIN);
ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", ObjCompositionSalesModel.PartyAddress);
ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", ObjCompositionSalesModel.WareHouseID);
ClsCon.cmd.Parameters.AddWithValue("@TransName", ObjCompositionSalesModel.TransName);
ClsCon.cmd.Parameters.AddWithValue("@PONo", ObjCompositionSalesModel.PONo);
ClsCon.cmd.Parameters.AddWithValue("@CancelReason", ObjCompositionSalesModel.CancelReason);
ClsCon.cmd.Parameters.AddWithValue("@InvoiceSeries", ObjCompositionSalesModel.InvoiceSeries);
ClsCon.cmd.Parameters.AddWithValue("@TblSale", ObjCompositionSalesModel.DtSales);
ClsCon.cmd.Parameters.AddWithValue("@TblItems", ObjCompositionSalesModel.DtItems);
//ClsCon.cmd.Parameters.AddWithValue("@TblSundries", objSalesModel.DtSundries);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtSales = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtSales);
dtSales.TableName = "success";
}
catch (Exception)
{
dtSales = new DataTable();
dtSales.TableName = "error";
return(dtSales);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtSales);
}
internal DataTable FillItemSellingRate(CompositionSalesModel ObjCompositionSalesModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPItems";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjCompositionSalesModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjCompositionSalesModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjCompositionSalesModel.BrID);
//ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjSalesModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@PartyCode", ObjCompositionSalesModel.PartyCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", ObjCompositionSalesModel.GSTIN);
ClsCon.cmd.Parameters.AddWithValue("@ItemID", ObjCompositionSalesModel.ItemID);
ClsCon.cmd.Parameters.AddWithValue("@ByCash", ObjCompositionSalesModel.ByCashSale);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtSales = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtSales);
dtSales.TableName = "success";
}
catch (Exception)
{
dtSales = new DataTable();
dtSales.TableName = "error";
return(dtSales);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtSales);
}
internal DataTable FillShippingAddress(CompositionSalesModel ObjCompositionSalesModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSearchByAccount";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjCompositionSalesModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjCompositionSalesModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjCompositionSalesModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjCompositionSalesModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", ObjCompositionSalesModel.AccCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", ObjCompositionSalesModel.GSTIN);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtSales = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtSales);
dtSales.TableName = "success";
}
catch (Exception)
{
dtSales = new DataTable();
dtSales.TableName = "error";
return(dtSales);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtSales);
}
internal DataSet FillGistnNoWithDetail(CompositionSalesModel ObjCompositionSalesModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSearchByAccount";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjCompositionSalesModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjCompositionSalesModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjCompositionSalesModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjCompositionSalesModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", ObjCompositionSalesModel.AccCode);
ClsCon.cmd.Parameters.AddWithValue("@AdvRecPayID", ObjCompositionSalesModel.AdvRecPayID);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsSales = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsSales);
dsSales.DataSetName = "success";
}
catch (Exception)
{
dsSales = new DataSet();
dsSales.DataSetName = "error";
return(dsSales);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsSales);
}
internal DataSet BindAll(CompositionSalesModel ObjCompositionSalesModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSaleVoucher";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjCompositionSalesModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjCompositionSalesModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjCompositionSalesModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjCompositionSalesModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjCompositionSalesModel.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsSales = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsSales);
dsSales.DataSetName = "success";
}
catch (Exception)
{
dsSales = new DataSet();
dsSales.DataSetName = "error";
return(dsSales);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsSales);
}
public DataTable SalesTo(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable dtSalesTo = ObjCompositionSalesDA.LoadSalesTo(ObjCompositionSalesModel);
return(dtSalesTo);
}
public DataTable IncomeHead(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable IncomeHeadList = ObjCompositionSalesDA.LoadIncomeHead(ObjCompositionSalesModel);
return(IncomeHeadList);
}
public DataTable LoadNarration(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable NarrationList = ObjCompositionSalesDA.LoadNarration(ObjCompositionSalesModel);
return(NarrationList);
}
public DataTable CancelSalesVoucherNo(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable dtCancelCashSales = ObjCompositionSalesDA.CancelSalesVoucherNo(ObjCompositionSalesModel);
return(dtCancelCashSales);
}
public DataTable FillItemSellingRate(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable ItemList = ObjCompositionSalesDA.FillItemSellingRate(ObjCompositionSalesModel);
return(ItemList);
}
public DataSet FillGistnNoWithDetail(CompositionSalesModel ObjCompositionSalesModel)
{
DataSet dsFillGistnNoWithDetail = ObjCompositionSalesDA.FillGistnNoWithDetail(ObjCompositionSalesModel);
return(dsFillGistnNoWithDetail);
}
public DataTable FillTransportation(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable dtLastVoucherNo = ObjCompositionSalesDA.FillTransportation(ObjCompositionSalesModel);
return(dtLastVoucherNo);
}
public DataTable LastVoucherNo(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable AccHeadList = ObjCompositionSalesDA.LastVoucherNo(ObjCompositionSalesModel);
return(AccHeadList);
}
public DataTable SaveSalesVoucher(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable AccHeadList = ObjCompositionSalesDA.SaveSalesVoucher(ObjCompositionSalesModel);
return(AccHeadList);
}
public DataTable FillLocation(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable dtFillLocation = ObjCompositionSalesDA.Filllocation(ObjCompositionSalesModel);
return(dtFillLocation);
}
public DataTable FillGistnNo(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable IncomeHeadList = ObjCompositionSalesDA.FillGistnNo(ObjCompositionSalesModel);
return(IncomeHeadList);
}
public DataTable InvoiceSeries(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable dtLastVoucherNo = ObjCompositionSalesDA.InvoiceSeries(ObjCompositionSalesModel);
return(dtLastVoucherNo);
}
public DataTable FillItemName(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable dtFillItemName = ObjCompositionSalesDA.FillItemName(ObjCompositionSalesModel);
return(dtFillItemName);
}
public DataSet BindAll(CompositionSalesModel ObjCompositionSalesModel)
{
DataSet dsBindAll = ObjCompositionSalesDA.BindAll(ObjCompositionSalesModel);
return(dsBindAll);
}
public DataTable FillShippingAddress(CompositionSalesModel ObjCompositionSalesModel)
{
DataTable ItemList = ObjCompositionSalesDA.FillShippingAddress(ObjCompositionSalesModel);
return(ItemList);
}
public DataSet FillItemSellRate(CompositionSalesModel ObjCompositionSalesModel)
{
DataSet ItemList = ObjCompositionSalesDA.FillItemSellRate(ObjCompositionSalesModel);
return(ItemList);
}
