internal DataTable LoadExpenseHead(CompositionPurchaseModel ObjPurchaseModel) //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", ObjPurchaseModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtPurchase = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtPurchase);
dtPurchase.TableName = "success";
}
catch (Exception)
{
dtPurchase = new DataTable();
dtPurchase.TableName = "error";
return(dtPurchase);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtPurchase);
}
internal DataTable SavePurchase(CompositionPurchaseModel ObjPurchaseModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPPurchaseVoucherChange";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjPurchaseModel.VchType);
ClsCon.cmd.Parameters.AddWithValue("@EntryType", ObjPurchaseModel.EntryType);
ClsCon.cmd.Parameters.AddWithValue("@User", ObjPurchaseModel.User);
ClsCon.cmd.Parameters.AddWithValue("@IP", ObjPurchaseModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", ObjPurchaseModel.ByCashSale);
ClsCon.cmd.Parameters.AddWithValue("@PartyName", ObjPurchaseModel.PartyName);
ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", ObjPurchaseModel.PartyGSTIN);
ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", ObjPurchaseModel.PartyAddress);
ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", ObjPurchaseModel.WareHouseID);
ClsCon.cmd.Parameters.AddWithValue("@PONo", ObjPurchaseModel.PONo);
ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillNo", ObjPurchaseModel.PurchaseBillNo);
ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillDate", ObjPurchaseModel.PurchaseBillDate);
ClsCon.cmd.Parameters.AddWithValue("@GRNNo", ObjPurchaseModel.GRNNo);
ClsCon.cmd.Parameters.AddWithValue("@DocDate", ObjPurchaseModel.VoucherDate);
ClsCon.cmd.Parameters.AddWithValue("@TblPurchase", ObjPurchaseModel.DtPurchase);
ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseItems", ObjPurchaseModel.DtItems);
ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseSundries", ObjPurchaseModel.DtSundries);
ClsCon.cmd.Parameters.AddWithValue("@TblAdvanceDetail", ObjPurchaseModel.DtAdjAdvance);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtPurchase = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtPurchase);
dtPurchase.TableName = "success";
}
catch (Exception)
{
dtPurchase = new DataTable();
dtPurchase.TableName = "error";
return(dtPurchase);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtPurchase);
}
internal DataSet FillItemPurchaseRate(CompositionPurchaseModel ObjPurchaseModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPItems";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID);
//ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@PartyCode", ObjPurchaseModel.PartyCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", ObjPurchaseModel.GSTIN);
ClsCon.cmd.Parameters.AddWithValue("@ItemID", ObjPurchaseModel.ItemID);
ClsCon.cmd.Parameters.AddWithValue("@ByCash", ObjPurchaseModel.ByCashSale);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsPurchase = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsPurchase);
dsPurchase.DataSetName = "success";
}
catch (Exception)
{
dsPurchase = new DataSet();
dsPurchase.DataSetName = "error";
return(dsPurchase);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsPurchase);
}
internal DataTable FillShippingAddress(CompositionPurchaseModel ObjPurchaseModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSearchByAccount";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", ObjPurchaseModel.AccCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", ObjPurchaseModel.GSTIN);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtPurchase = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtPurchase);
dtPurchase.TableName = "success";
}
catch (Exception)
{
dtPurchase = new DataTable();
dtPurchase.TableName = "error";
return(dtPurchase);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtPurchase);
}
internal DataSet FillGistnNoWithDetail(CompositionPurchaseModel ObjPurchaseModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSearchByAccount";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", ObjPurchaseModel.AccCode);
ClsCon.cmd.Parameters.AddWithValue("@AdvRecPayID", ObjPurchaseModel.AdvRecPayID);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsPurchase = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsPurchase);
dsPurchase.DataSetName = "success";
}
catch (Exception)
{
dsPurchase = new DataSet();
dsPurchase.DataSetName = "error";
return(dsPurchase);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsPurchase);
}
internal DataSet BindAll(CompositionPurchaseModel ObjPurchaseModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPPurchaseVoucherChange";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", ObjPurchaseModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", ObjPurchaseModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", ObjPurchaseModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjPurchaseModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", ObjPurchaseModel.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsPurchase = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsPurchase);
dsPurchase.DataSetName = "success";
}
catch (Exception)
{
dsPurchase = new DataSet();
dsPurchase.DataSetName = "error";
return(dsPurchase);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsPurchase);
}
public DataTable FillShippingAddress(CompositionPurchaseModel ObjPurchaseModel)
{
DataTable dtShippingAddress = objPurchaseDA.FillShippingAddress(ObjPurchaseModel);
return(dtShippingAddress);
}
public DataTable LoadNarration(CompositionPurchaseModel ObjPurchaseModel)
{
DataTable NarrationList = objPurchaseDA.LoadNarration(ObjPurchaseModel);
return(NarrationList);
}
public DataTable LastVoucherNo(CompositionPurchaseModel ObjPurchaseModel)
{
DataTable AccHeadList = objPurchaseDA.LastVoucherNo(ObjPurchaseModel);
return(AccHeadList);
}
public DataSet FillGistnNoWithDetail(CompositionPurchaseModel ObjPurchaseModel)
{
DataSet dsFillGistnNoWithDetail = objPurchaseDA.FillGistnNoWithDetail(ObjPurchaseModel);
return(dsFillGistnNoWithDetail);
}
public DataTable FillGistnNo(CompositionPurchaseModel ObjPurchaseModel)
{
DataTable IncomeHeadList = objPurchaseDA.FillGistnNo(ObjPurchaseModel);
return(IncomeHeadList);
}
public DataTable FillHeadName(CompositionPurchaseModel ObjPurchaseModel)
{
DataTable dtFillHeadName = objPurchaseDA.FillHeadName(ObjPurchaseModel);
return(dtFillHeadName);
}
public DataTable FillLocation(CompositionPurchaseModel ObjPurchaseModel)
{
DataTable dtFillLocation = objPurchaseDA.Filllocation(ObjPurchaseModel);
return(dtFillLocation);
}
public DataTable PurchaseFrom(CompositionPurchaseModel ObjPurchaseModel)
{
DataTable dtSalesTo = objPurchaseDA.PurchaseFrom(ObjPurchaseModel);
return(dtSalesTo);
}
public DataTable ExpenseHead(CompositionPurchaseModel ObjPurchaseModel)
{
DataTable IncomeHeadList = objPurchaseDA.LoadExpenseHead(ObjPurchaseModel);
return(IncomeHeadList);
}
public DataSet BindAll(CompositionPurchaseModel ObjPurchaseModel)
{
DataSet dsBindAll = objPurchaseDA.BindAll(ObjPurchaseModel);
return(dsBindAll);
}
public DataSet FillItemPurchaseRate(CompositionPurchaseModel ObjPurchaseModel)
{
DataSet ItemList = objPurchaseDA.FillItemPurchaseRate(ObjPurchaseModel);
return(ItemList);
}
public DataTable SavePurchase(CompositionPurchaseModel ObjPurchaseModel)
{
DataTable dtShippingAddress = objPurchaseDA.SavePurchase(ObjPurchaseModel);
return(dtShippingAddress);
}
