public DataTable SaveProcess(UpdateAdvSuppReceivedModel objUpdAdvSupReceived)
{
//DataTable ItemRateDetail = objAdvSupPayDA.FillItemTaxRate(objAdvSupPayment);
DataTable AdvSaving = objUpdAdvSupPayDA.SearchProcess(objUpdAdvSupReceived);
return(AdvSaving);
}
public DataTable SearchingProcess(UpdateAdvSuppReceivedModel objUpdAdvSupReceived)
{
//DataTable ItemRateDetail = objAdvSupPayDA.FillItemTaxRate(objAdvSupPayment);
DataTable DtSearchProcess = objUpdAdvSupPayDA.SearchingAdvRec(objUpdAdvSupReceived);
return(DtSearchProcess);
}
public DataTable FillItemRate(UpdateAdvSuppReceivedModel objUpdAdvSupReceived)
{
//DataTable ItemRateDetail = objAdvSupPayDA.FillItemTaxRate(objAdvSupPayment);
DataTable ItemRateDeatail = objUpdAdvSupPayDA.FillItemTaxRate(objUpdAdvSupReceived);
return(ItemRateDeatail);
}
internal DataSet AdvSuupReceived(UpdateAdvSuppReceivedModel objUpdAdvSupReceived)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdAdvanceReceived";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdAdvSupReceived.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdAdvSupReceived.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdAdvSupReceived.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdAdvSupReceived.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdAdvSupReceived.VchType);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dsAdvSuppReceived = new DataSet();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dsAdvSuppReceived);
//dtAdvSuppReceived.TableName = "success";
}
catch (Exception)
{
dsAdvSuppReceived = new DataSet();
// dtAdvSuppReceived.TableName = "error";
return(dsAdvSuppReceived);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dsAdvSuppReceived);
}
internal DataTable SearchProcess(UpdateAdvSuppReceivedModel objUpdAdvSupReceived)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdAdvanceReceived";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdAdvSupReceived.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdAdvSupReceived.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdAdvSupReceived.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objUpdAdvSupReceived.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdAdvSupReceived.VchType);
ClsCon.cmd.Parameters.AddWithValue("@VchDate", objUpdAdvSupReceived.VchDate);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdAdvSupReceived.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@CashBankCode", objUpdAdvSupReceived.CashBankCode);
ClsCon.cmd.Parameters.AddWithValue("@AcccountCode", objUpdAdvSupReceived.AccountCode);
ClsCon.cmd.Parameters.AddWithValue("@GSTIN", objUpdAdvSupReceived.GSTIN);
ClsCon.cmd.Parameters.AddWithValue("@NetAmount", objUpdAdvSupReceived.NetAmount);
ClsCon.cmd.Parameters.AddWithValue("@TaxAmount", objUpdAdvSupReceived.TaxAmount);
ClsCon.cmd.Parameters.AddWithValue("@GrossAmount", objUpdAdvSupReceived.GrossAmount);
ClsCon.cmd.Parameters.AddWithValue("@ChequeNo", objUpdAdvSupReceived.ChequeNo);
ClsCon.cmd.Parameters.AddWithValue("@ChequeDate", objUpdAdvSupReceived.ChequeDate);
ClsCon.cmd.Parameters.AddWithValue("@UTRNo", objUpdAdvSupReceived.UTRNo);
ClsCon.cmd.Parameters.AddWithValue("@UTRDate", objUpdAdvSupReceived.UTRDate);
ClsCon.cmd.Parameters.AddWithValue("@UserID", objUpdAdvSupReceived.User);
ClsCon.cmd.Parameters.AddWithValue("@IP", objUpdAdvSupReceived.IP);
ClsCon.cmd.Parameters.AddWithValue("@VchNarration", objUpdAdvSupReceived.VchNarration);
// ClsCon.cmd.Parameters.AddWithValue("@EntryType", objAdvSupReceived.EntryType);
//ClsCon.cmd.Parameters.AddWithValue("@ItemID", objAdvSupReceived.ItemID);
ClsCon.cmd.Parameters.AddWithValue("@TblAdvItems", objUpdAdvSupReceived.TblAdvItems);
// 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 AdUpdSuppRec(UpdateAdvSuppReceivedModel objUpdAdvSupReceived)
{
objUpdAdvSupReceived.Ind = 1;
DataSet DtAdsup = objUpdAdvSupPayDA.AdvSuupReceived(objUpdAdvSupReceived);
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(UpdateAdvSuppReceivedModel objUpdAdvSupReceived)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPItems";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdAdvSupReceived.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdAdvSupReceived.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdAdvSupReceived.BrID);
ClsCon.cmd.Parameters.AddWithValue("@PartyCode", objUpdAdvSupReceived.AccountCode);
ClsCon.cmd.Parameters.AddWithValue("@ItemID", objUpdAdvSupReceived.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;
AdvUpdSupreceiveddt = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(AdvUpdSupreceiveddt);
AdvUpdSupreceiveddt.TableName = "success";
}
catch (Exception)
{
AdvUpdSupreceiveddt = new DataTable();
AdvUpdSupreceiveddt.TableName = "error";
return(AdvUpdSupreceiveddt);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(AdvUpdSupreceiveddt);
}
internal DataTable CancelVoucher(UpdateAdvSuppReceivedModel objUpdAdvSupReceived)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPUpdAdvanceReceived";
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.Parameters.AddWithValue("@Ind", objUpdAdvSupReceived.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objUpdAdvSupReceived.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objUpdAdvSupReceived.BrID);
ClsCon.cmd.Parameters.AddWithValue("@DocNo", objUpdAdvSupReceived.DocNo);
ClsCon.cmd.Parameters.AddWithValue("@VchType", objUpdAdvSupReceived.VchType);
ClsCon.cmd.Parameters.AddWithValue("@CancelReason", objUpdAdvSupReceived.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(UpdateAdvSuppReceivedModel objUpdAdvSupReceived)
{
DataTable dtCancel = objUpdAdvSupPayDA.CancelVoucher(objUpdAdvSupReceived);
return(dtCancel);
}
