public DataSet dal_ARCreditNoteDetail(bel_ARCreditNote obj_bel_CreditNote)
{
DataSet ds = new DataSet();
try
{
SqlCommand sqlcmd = new SqlCommand("spu_ARCreditNoteSearch");
sqlcmd.CommandTimeout = 0;
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Clear();
sqlcmd.Parameters.AddWithValue("@CreditNoteID", obj_bel_CreditNote._CreditNoteID);
sqlcmd.Parameters.AddWithValue("@CreditNote_DetailID", obj_bel_CreditNote._CreditNote_DetailID);
sqlcmd.Parameters.AddWithValue("@BranchID", Convert.ToInt32(HttpContext.Current.Session["BranchID"]));
sqlcmd.Parameters.AddWithValue("@ProductID", obj_bel_CreditNote._ProductID);
sqlcmd.Parameters.AddWithValue("@ProductCode", obj_bel_CreditNote._ProductCode);
sqlcmd.Parameters.AddWithValue("@JOBID", obj_bel_CreditNote._JOBID);
sqlcmd.Parameters.AddWithValue("@ScreenName", obj_bel_CreditNote._ScreenName);
sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"]));
sqlcmd.Parameters.AddWithValue("@iMode", obj_bel_CreditNote._iMode);
sqlcmd.Parameters.AddWithValue("@PartyID", obj_bel_CreditNote._PartyID);
sqlcmd.Parameters.AddWithValue("@Period", obj_bel_CreditNote._BillFromDate);
ds = DataFunctions.GetDataSet(sqlcmd);
}
catch (Exception ex)
{
}
return ds;
}
public DataSet dal_AutoGen(bel_ARCreditNote obj_bel_CreditNote)
{
DataSet ds = new DataSet();
try
{
SqlCommand sqlcmd = new SqlCommand("spu_AutoGenTransaction");
sqlcmd.CommandTimeout = 0;
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Clear();
sqlcmd.Parameters.AddWithValue("@ScreenName", obj_bel_CreditNote._ScreenName);
sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"]));
sqlcmd.Parameters.AddWithValue("@FromDate", obj_bel_CreditNote._BillFromDate);
sqlcmd.Parameters.AddWithValue("@ToDate", obj_bel_CreditNote._BillToDate);
sqlcmd.Parameters.AddWithValue("@Year", Convert.ToInt32(HttpContext.Current.Session["FinancialYear"]));
ds = DataFunctions.GetDataSet(sqlcmd);
}
catch (Exception ex)
{
}
return ds;
}
