public DataTable SaveProcess(UpdSuppAdvancePaymentModel objUpdAdvSupPayment)
{
//DataTable ItemRateDetail = objAdvSupPayDA.FillItemTaxRate(objAdvSupPayment);
DataTable AdvSaving = objUpdAdvSupPayDA.SearchProcess(objUpdAdvSupPayment);
return(AdvSaving);
}
internal DataSet AdUpdSuppPay(UpdSuppAdvancePaymentModel objUpdAdvSupPayment)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPAdvancePayment";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdAdvSupPayment.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdAdvSupPayment.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdAdvSupPayment.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdAdvSupPayment.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdAdvSupPayment.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsAdvUpdSuppPayment = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsAdvUpdSuppPayment);
//dtAdvSuppPayment.TableName = "success";
}
catch (Exception)
{
dsAdvUpdSuppPayment = new DataSet();
// dtAdvSuppPayment.TableName = "error";
return(dsAdvUpdSuppPayment);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsAdvUpdSuppPayment);
}
public DataTable FillItemRate(UpdSuppAdvancePaymentModel objUpdAdvSupPayment)
{
//DataTable ItemRateDetail = objAdvSupPayDA.FillItemTaxRate(objAdvSupPayment);
DataTable ItemRateDeatail = objUpdAdvSupPayDA.FillItemTaxRate(objUpdAdvSupPayment);
return(ItemRateDeatail);
}
public DataTable SearchingProcess(UpdSuppAdvancePaymentModel objUpdAdvSupPayment)
{
//DataTable ItemRateDetail = objAdvSupPayDA.FillItemTaxRate(objAdvSupPayment);
DataTable DtSearchProcess = objUpdAdvSupPayDA.SearchingAdvRec(objUpdAdvSupPayment);
return(DtSearchProcess);
}
internal DataTable SearchProcess(UpdSuppAdvancePaymentModel objUpdAdvSupPayment)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdAdvanceReceived";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdAdvSupPayment.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdAdvSupPayment.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdAdvSupPayment.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdAdvSupPayment.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdAdvSupPayment.VchType);
ClsCon.cmd.Parameters.AddWithValue("@VchDate", objUpdAdvSupPayment.VchDate);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdAdvSupPayment.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@CashBankCode", objUpdAdvSupPayment.CashBankCode);
ClsCon.cmd.Parameters.AddWithValue("@AcccountCode", objUpdAdvSupPayment.AccountCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objUpdAdvSupPayment.GSTIN);
ClsCon.cmd.Parameters.AddWithValue("@NetAmount", objUpdAdvSupPayment.NetAmount);
ClsCon.cmd.Parameters.AddWithValue("@TaxAmount", objUpdAdvSupPayment.TaxAmount);
ClsCon.cmd.Parameters.AddWithValue("@GrossAmount", objUpdAdvSupPayment.GrossAmount);
ClsCon.cmd.Parameters.AddWithValue("@ChequeNo", objUpdAdvSupPayment.ChequeNo);
ClsCon.cmd.Parameters.AddWithValue("@ChequeDate", objUpdAdvSupPayment.ChequeDate);
ClsCon.cmd.Parameters.AddWithValue("@UTRNo", objUpdAdvSupPayment.UTRNo);
ClsCon.cmd.Parameters.AddWithValue("@UTRDate", objUpdAdvSupPayment.UTRDate);
ClsCon.cmd.Parameters.AddWithValue("@UserID", objUpdAdvSupPayment.User);
ClsCon.cmd.Parameters.AddWithValue("@IP", objUpdAdvSupPayment.IP);
ClsCon.cmd.Parameters.AddWithValue("@VchNarration", objUpdAdvSupPayment.VchNarration);
ClsCon.cmd.Parameters.AddWithValue("@TblAdvItems", objUpdAdvSupPayment.TblAdvItems);
// ClsCon.cmd.Parameters.AddWithValue("@EntryType", objAdvSupReceived.EntryType);
//ClsCon.cmd.Parameters.AddWithValue("@ItemID", objAdvSupReceived.ItemID);
// ClsCon.cmd.Parameters.AddWithValue("@GSTIN", ObjSalesModel.GSTIN);
//ClsCon.cmd.Parameters.AddWithValue("@ByCash", ObjSalesModel.ByCashSale);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtSaving = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtSaving);
dtSaving.TableName = "success";
}
catch (Exception)
{
dtSaving = new DataTable();
dtSaving.TableName = "error";
return(dtSaving);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtSaving);
}
public DataSet AdUpdSuppPay(UpdSuppAdvancePaymentModel objUpdAdvSupPayment)
{
objUpdAdvSupPayment.Ind = 1;
DataSet DtAdsup = objUpdAdvSupPayDA.AdUpdSuppPay(objUpdAdvSupPayment);
DtAdsup.Tables[0].TableName = "CashBankAccount";
DtAdsup.Tables[1].TableName = "AccountHead";
DtAdsup.Tables[2].TableName = "ItemList";
DtAdsup.Tables[3].TableName = "Narration";
DtAdsup.Tables[4].TableName = "LastVoucherNo";
return(DtAdsup);
}
internal DataTable FillItemTaxRate(UpdSuppAdvancePaymentModel objUpdAdvSupPayment)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPItems";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdAdvSupPayment.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdAdvSupPayment.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdAdvSupPayment.BrID);
ClsCon.cmd.Parameters.AddWithValue("@PartyCode", objUpdAdvSupPayment.AccountCode);
ClsCon.cmd.Parameters.AddWithValue("@ItemID", objUpdAdvSupPayment.ItemID);
//ClsCon.cmd.Parameters.AddWithValue("@YrCD", ObjSalesModel.YrCD);
// ClsCon.cmd.Parameters.AddWithValue("@GSTIN", ObjSalesModel.GSTIN);
//ClsCon.cmd.Parameters.AddWithValue("@ByCash", ObjSalesModel.ByCashSale);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
AdvSuppaydt = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(AdvSuppaydt);
AdvSuppaydt.TableName = "success";
}
catch (Exception)
{
AdvSuppaydt = new DataTable();
AdvSuppaydt.TableName = "error";
return(AdvSuppaydt);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(AdvSuppaydt);
}
internal DataTable CancelVoucher(UpdSuppAdvancePaymentModel objUpdAdvSupPayment)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdAdvanceReceived";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdAdvSupPayment.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdAdvSupPayment.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdAdvSupPayment.BrID);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdAdvSupPayment.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdAdvSupPayment.VchType);
ClsCon.cmd.Parameters.AddWithValue("@CancelReason", objUpdAdvSupPayment.CancelReason);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtCancel = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtCancel);
dtCancel.TableName = "success";
}
catch (Exception)
{
dtCancel = new DataTable();
dtCancel.TableName = "error";
return(dtCancel);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtCancel);
}
public DataTable CancelVoucher(UpdSuppAdvancePaymentModel objUpdAdvSupPayment)
{
DataTable dtCancel = objUpdAdvSupPayDA.CancelVoucher(objUpdAdvSupPayment);
return(dtCancel);
}
