internal DataTable UpdatePV(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdatePurchaseVoucher";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdPVModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdPVModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdPVModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdPVModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdPVModel.VchType);
ClsCon.cmd.Parameters.AddWithValue("@EntryType", objUpdPVModel.EntryType);
ClsCon.cmd.Parameters.AddWithValue("@User", objUpdPVModel.User);
ClsCon.cmd.Parameters.AddWithValue("@IP", objUpdPVModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@ByCashSale", objUpdPVModel.ByCashSale);
ClsCon.cmd.Parameters.AddWithValue("@PartyName", objUpdPVModel.PartyName);
ClsCon.cmd.Parameters.AddWithValue("@PartyGSTIN", objUpdPVModel.PartyGSTIN);
ClsCon.cmd.Parameters.AddWithValue("@PartyAddress", objUpdPVModel.PartyAddress);
ClsCon.cmd.Parameters.AddWithValue("@WareHouseID", objUpdPVModel.WareHouseID);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", objUpdPVModel.AccCode);
ClsCon.cmd.Parameters.AddWithValue("@PONo", objUpdPVModel.PONo);
ClsCon.cmd.Parameters.AddWithValue("@PODate", objUpdPVModel.PODate);
ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillNo", objUpdPVModel.PurchaseBillNo);
ClsCon.cmd.Parameters.AddWithValue("@PurchaseBillDate", objUpdPVModel.PurchaseBillDate);
ClsCon.cmd.Parameters.AddWithValue("@GRNNo", objUpdPVModel.GRNNo);
ClsCon.cmd.Parameters.AddWithValue("@GRNDate", objUpdPVModel.GRNDate);
ClsCon.cmd.Parameters.AddWithValue("@PurchaseSaleRecordID", objUpdPVModel.PurchaseSaleRecordID);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdPVModel.VoucherNo);
ClsCon.cmd.Parameters.AddWithValue("@DocDate", objUpdPVModel.VoucherDate);
ClsCon.cmd.Parameters.AddWithValue("@TblPurchase", objUpdPVModel.DtUpdPurchase);
ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseItems", objUpdPVModel.DtUpdItems);
ClsCon.cmd.Parameters.AddWithValue("@TblPurchaseSundries", objUpdPVModel.DtUpdSundries);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdPV = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdPV);
dtUpdPV.TableName = "success";
}
catch (Exception)
{
dtUpdPV = new DataTable();
dtUpdPV.TableName = "error";
return(dtUpdPV);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdPV);
}
//internal DataTable LoadPurchaseVoucherDetails(UpdatePurchaseVoucherModel objUpdPVModel)
//{
// try
// {
// ClsCon.cmd = new SqlCommand();
// ClsCon.cmd.CommandType = CommandType.StoredProcedure;
// ClsCon.cmd.CommandText = "SPUpdatePurchaseVoucher";
// ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdPVModel.Ind);
// ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdPVModel.OrgID);
// ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdPVModel.BrID);
// ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdPVModel.YrCD);
// ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdPVModel.VchType);
// ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdPVModel.VoucherNo);
// con = ClsCon.SqlConn();
// ClsCon.cmd.Connection = con;
// dtUpdPV = new DataTable();
// ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
// ClsCon.da.Fill(dtUpdPV);
// dtUpdPV.TableName = "success";
// }
// catch (Exception)
// {
// dtUpdPV = new DataTable();
// dtUpdPV.TableName = "error";
// return dtUpdPV;
// }
// finally
// {
// con.Close();
// con.Dispose();
// ClsCon.da.Dispose();
// ClsCon.cmd.Dispose();
// }
// return dtUpdPV;
//}
internal DataSet LoadPurchaseVoucherDetails(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdatePurchaseVoucher";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdPVModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdPVModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdPVModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdPVModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdPVModel.VchType);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdPVModel.VoucherNo);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsUpdPV = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsUpdPV);
dsUpdPV.DataSetName = "success";
dsUpdPV.Tables[0].TableName = "Basic";
dsUpdPV.Tables[1].TableName = "ItemDetails";
dsUpdPV.Tables[2].TableName = "FreeItems";
dsUpdPV.Tables[3].TableName = "Sundries";
}
catch (Exception)
{
dsUpdPV = new DataSet();
dsUpdPV.DataSetName = "error";
return(dsUpdPV);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsUpdPV);
}
internal DataSet FillItemPurchaseRate(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPItems";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdPVModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdPVModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdPVModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@PartyCode", objUpdPVModel.PartyCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objUpdPVModel.GSTIN);
ClsCon.cmd.Parameters.AddWithValue("@ItemID", objUpdPVModel.ItemID);
ClsCon.cmd.Parameters.AddWithValue("@ByCash", objUpdPVModel.ByCashSale);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsUpdPV = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsUpdPV);
dsUpdPV.DataSetName = "success";
}
catch (Exception)
{
dsUpdPV = new DataSet();
dsUpdPV.DataSetName = "error";
return(dsUpdPV);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsUpdPV);
}
internal DataTable CancelVoucher(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdatePurchaseVoucher";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdPVModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdPVModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdPVModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdPVModel.VchType);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdPVModel.VoucherNo);
ClsCon.cmd.Parameters.AddWithValue("@CancelReason", objUpdPVModel.CancelReason);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdPV = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdPV);
dtUpdPV.TableName = "success";
}
catch (Exception)
{
dtUpdPV = new DataTable();
dtUpdPV.TableName = "error";
return(dtUpdPV);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdPV);
}
internal DataTable FillShippingAddress(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPSearchByAccount";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdPVModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdPVModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdPVModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdPVModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@AccCode", objUpdPVModel.AccCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objUpdPVModel.GSTIN);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtUpdPV = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtUpdPV);
dtUpdPV.TableName = "success";
}
catch (Exception)
{
dtUpdPV = new DataTable();
dtUpdPV.TableName = "error";
return(dtUpdPV);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtUpdPV);
}
internal DataSet BindAll(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPPurchaseVoucherChange";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdPVModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdPVModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdPVModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdPVModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdPVModel.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsUpdPV = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsUpdPV);
dsUpdPV.DataSetName = "success";
}
catch (Exception)
{
dsUpdPV = new DataSet();
dsUpdPV.DataSetName = "error";
return(dsUpdPV);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsUpdPV);
}
public DataTable CancelVoucher(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
DataTable dtUpdate = objPVDA.CancelVoucher(objUpdPVModel);
return(dtUpdate);
}
public DataTable UpdatePV(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
DataTable dtUpdPV = objPVDA.UpdatePV(objUpdPVModel);
return(dtUpdPV);
}
public DataSet LoadPurchaseVoucherDetails(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
DataSet dsPVDetails = objPVDA.LoadPurchaseVoucherDetails(objUpdPVModel);
return(dsPVDetails);
}
public DataTable FillShippingAddress(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
DataTable dtShippingAddress = objPVDA.FillShippingAddress(objUpdPVModel);
return(dtShippingAddress);
}
public DataSet FillItemPurchaseRate(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
DataSet dsItemList = objPVDA.FillItemPurchaseRate(objUpdPVModel);
return(dsItemList);
}
public DataTable FillGistnNo(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
DataTable IncomeHeadList = objPVDA.FillGistnNo(objUpdPVModel);
return(IncomeHeadList);
}
public DataTable FillLocation(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
DataTable dtFillLocation = objPVDA.Filllocation(objUpdPVModel);
return(dtFillLocation);
}
public DataSet BindAll(UpdateCompositionPurchaseVoucherModel objUpdPVModel)
{
DataSet dsBindAll = objPVDA.BindAll(objUpdPVModel);
return(dsBindAll);
}
