internal DataTable CheckState(UpdateCompositionSalesModel ObjSalesModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", ObjSalesModel.Ind);
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 FillItemSellRate(UpdateCompositionSalesModel ObjSalesModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPItems";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjSalesModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjSalesModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjSalesModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@PartyCode", ObjSalesModel.PartyCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", ObjSalesModel.GSTIN);
ClsCon.cmd.Parameters.AddWithValue("@ItemID", ObjSalesModel.ItemID);
ClsCon.cmd.Parameters.AddWithValue("@ByCash", ObjSalesModel.ByCashSale);
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 SearchSaleInvoice(UpdateCompositionSalesModel ObjSalesModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdateSaleVoucher";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjSalesModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjSalesModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjSalesModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjSalesModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjSalesModel.VchType);
ClsCon.cmd.Parameters.AddWithValue("@InvoiceNo", ObjSalesModel.InvoiceNo);
ClsCon.cmd.Parameters.AddWithValue("@InvoiceSeries", ObjSalesModel.InvoiceSeries);
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 DataTable CancelVoucher(UpdateCompositionSalesModel ObjSalesModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdateSaleVoucher";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjSalesModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjSalesModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjSalesModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@InvoiceSeries", ObjSalesModel.InvoiceSeries);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", ObjSalesModel.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@InvoiceNo", ObjSalesModel.InvoiceNo);
ClsCon.cmd.Parameters.AddWithValue("@CancelReason", ObjSalesModel.CancelReason);
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(UpdateCompositionSalesModel ObjSalesModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSearchByAccount";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjSalesModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjSalesModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjSalesModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjSalesModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", ObjSalesModel.AccCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", ObjSalesModel.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 DataTable UpdateSaleVoucher(UpdateCompositionSalesModel ObjSalesModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdateSaleVoucher";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjSalesModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjSalesModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjSalesModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjSalesModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjSalesModel.VchType);
ClsCon.cmd.Parameters.AddWithValue("@EntryType", ObjSalesModel.EntryType);
ClsCon.cmd.Parameters.AddWithValue("@User", ObjSalesModel.User);
ClsCon.cmd.Parameters.AddWithValue("@IP", ObjSalesModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", ObjSalesModel.ByCashSale);
ClsCon.cmd.Parameters.AddWithValue("@PartyName", ObjSalesModel.PartyName);
ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", ObjSalesModel.PartyGSTIN);
ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", ObjSalesModel.PartyAddress);
ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", ObjSalesModel.WareHouseID);
ClsCon.cmd.Parameters.AddWithValue("@TransName", ObjSalesModel.TransName);
ClsCon.cmd.Parameters.AddWithValue("@PONo", ObjSalesModel.PONo);
ClsCon.cmd.Parameters.AddWithValue("@InvoiceSeries", ObjSalesModel.InvoiceSeries);
ClsCon.cmd.Parameters.AddWithValue("@PartyBank", ObjSalesModel.PartyBank);
ClsCon.cmd.Parameters.AddWithValue("@PartyIFSC", ObjSalesModel.PartyIFSC);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", ObjSalesModel.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@TblSale", ObjSalesModel.DtSales);
ClsCon.cmd.Parameters.AddWithValue("@TblItems", ObjSalesModel.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);
}
public DataTable UpdateSaleVoucher(UpdateCompositionSalesModel ObjSalesModel)
{
DataTable dtUpdate = ObjSalesDA.UpdateSaleVoucher(ObjSalesModel);
return(dtUpdate);
}
public DataTable CancelVoucher(UpdateCompositionSalesModel ObjSalesModel)
{
DataTable dtCancel = ObjSalesDA.CancelVoucher(ObjSalesModel);
return(dtCancel);
}
public DataTable FillShippingAddress(UpdateCompositionSalesModel ObjSalesModel)
{
DataTable dtFillShippingAddress = ObjSalesDA.FillShippingAddress(ObjSalesModel);
return(dtFillShippingAddress);
}
public DataSet FillItemSellRate(UpdateCompositionSalesModel ObjSalesModel)
{
DataSet dsItemRate = ObjSalesDA.FillItemSellRate(ObjSalesModel);
return(dsItemRate);
}
public DataTable FillGistnNo(UpdateCompositionSalesModel ObjSalesModel)
{
DataTable dtFillGistnNo = ObjSalesDA.FillGistnNo(ObjSalesModel);
return(dtFillGistnNo);
}
public DataTable CheckState(UpdateCompositionSalesModel ObjSalesModel)
{
DataTable dtCheckState = ObjSalesDA.CheckState(ObjSalesModel);
return(dtCheckState);
}
public DataTable FillLocation(UpdateCompositionSalesModel ObjSalesModel)
{
DataTable dtFillLocation = ObjSalesDA.Filllocation(ObjSalesModel);
return(dtFillLocation);
}
public DataSet SearchSaleInvoice(UpdateCompositionSalesModel ObjSalesModel)
{
DataSet dsSaleInvoice = ObjSalesDA.SearchSaleInvoice(ObjSalesModel);
return(dsSaleInvoice);
}
public DataSet BindAll(UpdateCompositionSalesModel ObjSalesModel)
{
DataSet dsBindAll = ObjSalesDA.BindAll(ObjSalesModel);
return(dsBindAll);
}
