internal DataTable CheckState(UpdateCashSalesModel 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;
dtCashSales = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtCashSales);
dtCashSales.TableName = "success";
}
catch (Exception)
{
dtCashSales = new DataTable();
dtCashSales.TableName = "error";
return(dtCashSales);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtCashSales);
}
internal DataSet FillItemSellRate(UpdateCashSalesModel 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);
ClsCon.cmd.Parameters.AddWithValue("@PartyState", ObjSalesModel.PartyState);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsCashSales = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsCashSales);
dsCashSales.DataSetName = "success";
}
catch (Exception)
{
dsCashSales = new DataSet();
dsCashSales.DataSetName = "error";
return(dsCashSales);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsCashSales);
}
internal DataSet SearchSaleInvoice(UpdateCashSalesModel 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;
dsCashSales = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsCashSales);
dsCashSales.DataSetName = "success";
}
catch (Exception)
{
dsCashSales = new DataSet();
dsCashSales.DataSetName = "error";
return(dsCashSales);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsCashSales);
}
internal DataTable FillShippingAddress(UpdateCashSalesModel 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;
dtCashSales = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtCashSales);
dtCashSales.TableName = "success";
}
catch (Exception)
{
dtCashSales = new DataTable();
dtCashSales.TableName = "error";
return(dtCashSales);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtCashSales);
}
internal DataTable UpdateSaleVoucher(UpdateCashSalesModel 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("@PartyMobileNo", ObjSalesModel.PartyMobileNo);
ClsCon.cmd.Parameters.AddWithValue("@PayMode", ObjSalesModel.PayMode);
ClsCon.cmd.Parameters.AddWithValue("@PayModeRemark", ObjSalesModel.PayModeRemark);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", ObjSalesModel.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@PartyState", ObjSalesModel.PartyState);
ClsCon.cmd.Parameters.AddWithValue("@CCCode", ObjSalesModel.CCCode);
ClsCon.cmd.Parameters.AddWithValue("@BrokerageID", ObjSalesModel.BrokerageID);
ClsCon.cmd.Parameters.AddWithValue("@BrokerageRate", ObjSalesModel.BrokerageRate);
ClsCon.cmd.Parameters.AddWithValue("@BrokerageGSTIN", ObjSalesModel.BrokerageGSTIN);
ClsCon.cmd.Parameters.AddWithValue("@BrokerageAmount", ObjSalesModel.BrokerageAmount);
ClsCon.cmd.Parameters.AddWithValue("@TblSale", ObjSalesModel.DtCashSales);
ClsCon.cmd.Parameters.AddWithValue("@TblItems", ObjSalesModel.DtItems);
ClsCon.cmd.Parameters.AddWithValue("@TblSundries", ObjSalesModel.DtSundries);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtCashSales = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtCashSales);
dtCashSales.TableName = "success";
}
catch (Exception)
{
dtCashSales = new DataTable();
dtCashSales.TableName = "error";
return(dtCashSales);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtCashSales);
}
public DataTable UpdateSaleVoucher(UpdateCashSalesModel ObjSalesModel)
{
DataTable dtUpdate = objCashSalesDA.UpdateSaleVoucher(ObjSalesModel);
return(dtUpdate);
}
public DataTable FillShippingAddress(UpdateCashSalesModel ObjSalesModel)
{
DataTable dtFillShippingAddress = objCashSalesDA.FillShippingAddress(ObjSalesModel);
return(dtFillShippingAddress);
}
public DataSet FillItemSellRate(UpdateCashSalesModel ObjSalesModel)
{
DataSet dsItemRate = objCashSalesDA.FillItemSellRate(ObjSalesModel);
return(dsItemRate);
}
public DataTable FillGistnNo(UpdateCashSalesModel ObjSalesModel)
{
DataTable dtFillGistnNo = objCashSalesDA.FillGistnNo(ObjSalesModel);
return(dtFillGistnNo);
}
public DataTable CheckState(UpdateCashSalesModel ObjSalesModel)
{
DataTable dtCheckState = objCashSalesDA.CheckState(ObjSalesModel);
return(dtCheckState);
}
public DataTable FillLocation(UpdateCashSalesModel ObjSalesModel)
{
DataTable dtFillLocation = objCashSalesDA.Filllocation(ObjSalesModel);
return(dtFillLocation);
}
public DataSet SearchSaleInvoice(UpdateCashSalesModel ObjSalesModel)
{
DataSet dsSaleInvoice = objCashSalesDA.SearchSaleInvoice(ObjSalesModel);
return(dsSaleInvoice);
}
public DataSet BindAll(UpdateCashSalesModel ObjSalesModel)
{
DataSet dsBindAll = objCashSalesDA.BindAll(ObjSalesModel);
return(dsBindAll);
}
