public DataSet DailyCollectionDetails(dailycollection_Prop dailycollectionprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_dailycollectiondetails", new object[] { dailycollectionprop.CDate, dailycollectionprop.UserName }));
}
catch (Exception e)
{
throw e;
}
}
public DataTable DailyCashSelect(dailycollection_Prop dailycollectionprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_CashAmount_Select", new object[] { dailycollectionprop.UserName }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public DataSet DailyCollectionDetails(dailycollection_Prop dailycollectionprop)
{
try
{
dailycollectiondal = new dailycollection_dal();
DataSet ds = dailycollectiondal.DailyCollectionDetails(dailycollectionprop);
return(ds);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}
public DataTable DailyCashSelect(dailycollection_Prop dailycollectionprop)
{
try
{
dailycollectiondal = new dailycollection_dal();
DataTable dt = dailycollectiondal.DailyCashSelect(dailycollectionprop);
return(dt);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}
public string DailyCollectionInsert(dailycollection_Prop dailycollectionprop)
{
try
{
dailycollectiondal = new dailycollection_dal();
string strMsg = dailycollectiondal.DailyCollectionInsert(dailycollectionprop);
return(strMsg);
}
catch (Exception e)
{
ErrMessage = e.Message;
return("");
}
}
public string DailyCollectionInsert(dailycollection_Prop dailycollectionprop)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_DailyCollection_INSERT", new object[] { dailycollectionprop.ThosandNotes, dailycollectionprop.FiveHundredNotes,
dailycollectionprop.HundredNotes, dailycollectionprop.FiftyNote, dailycollectionprop.TwentyNotes,
dailycollectionprop.TenNotes, dailycollectionprop.FiveNotes, dailycollectionprop.TwoNotes,
dailycollectionprop.OneNotes, dailycollectionprop.UserName, dailycollectionprop.CDate, dailycollectionprop.CashAmt, dailycollectionprop.ChequeAmt }).Tables[0].Rows[0][0].ToString());
}
catch (Exception e)
{
throw e;
}
}