private string CollectionSelect(string username, string strdate)
{
Common cm = new Common();
dailycollection_Prop dailycollectionprop = new dailycollection_Prop();
dailycollectionprop.UserName = username;
dailycollectionprop.CDate = cm.MMDDYYYY(strdate);
dailycollection_bal dailycollectionbal = new dailycollection_bal();
DataTable dt = dailycollectionbal.DailyCollectionSelect(dailycollectionprop);
string strMsg = "";
if (dailycollectionbal.ErrMessage != "" && dailycollectionbal.ErrMessage != null)
{
return(dailycollectionbal.ErrMessage);
}
else
{
if (dt.Rows.Count > 0)
{
strMsg = dt.Rows[0]["ThosandNotes"].ToString() + "#" + dt.Rows[0]["FiveHundredNotes"].ToString() + "#" + dt.Rows[0]["HundredNotes"].ToString() + "#" + dt.Rows[0]["FiftyNote"].ToString() + "#" + dt.Rows[0]["TwentyNotes"].ToString() + "#" + dt.Rows[0]["TenNotes"].ToString() + "#" + dt.Rows[0]["FiveNotes"].ToString() + "#" + dt.Rows[0]["TwoNotes"].ToString() + "#" + dt.Rows[0]["OneNotes"].ToString();
}
else
{
return("No Record Found");
}
}
return(strMsg);
}
private string DailyCollectionInsert(double OneThousand, double FiveHundred, double ConHundred, double fifty, double twenty, double Ten, double Five, double Two, double One, string username, string cdate, double cashAmt, double chequeAmt)
{
dailycollection_Prop dailycollectionprop = new dailycollection_Prop();
Common cm = new Common();
dailycollectionprop.ThosandNotes = OneThousand;
dailycollectionprop.FiveHundredNotes = FiveHundred;
dailycollectionprop.HundredNotes = ConHundred;
dailycollectionprop.FiftyNote = fifty;
dailycollectionprop.TwentyNotes = twenty;
dailycollectionprop.TenNotes = Ten;
dailycollectionprop.FiveNotes = Five;
dailycollectionprop.TwoNotes = Two;
dailycollectionprop.OneNotes = One;
dailycollectionprop.UserName = username;
dailycollectionprop.CDate = cdate;
dailycollectionprop.CashAmt = cashAmt;
dailycollectionprop.ChequeAmt = chequeAmt;
string strMsg = "";
dailycollection_bal dailycollectionbal = new dailycollection_bal();
strMsg = dailycollectionbal.DailyCollectionInsert(dailycollectionprop);
if (dailycollectionbal.ErrMessage != "" && dailycollectionbal.ErrMessage != null)
{
return(dailycollectionbal.ErrMessage);
}
else
{
return(strMsg);
}
}
private string CashAmountSelect(string username)
{
dailycollection_Prop dailycollectionprop = new dailycollection_Prop();
dailycollectionprop.UserName = username;
dailycollection_bal dailycollectionbal = new dailycollection_bal();
DataTable dt = dailycollectionbal.DailyCashSelect(dailycollectionprop);
string strMsg = "";
if (dailycollectionbal.ErrMessage != "" && dailycollectionbal.ErrMessage != null)
{
return(dailycollectionbal.ErrMessage);
}
else
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
strMsg += dt.Rows[i]["Mode"].ToString() + "#" + dt.Rows[i]["Amount"].ToString() + "~";
}
}
else
{
return("No Record Found");
}
}
return(strMsg);
}
private string DailyCollectionDetails(string cdateDailyCollection, string username)
{
dailycollection_Prop dailycollectionprop = new dailycollection_Prop();
dailycollectionprop.CDate = cdateDailyCollection;
dailycollectionprop.UserName = username;
dailycollection_bal dailycollectionbal = new dailycollection_bal();
DataSet ds = dailycollectionbal.DailyCollectionDetails(dailycollectionprop);
string strMsg = "";
if (dailycollectionbal.ErrMessage != "" && dailycollectionbal.ErrMessage != null)
{
return(dailycollectionbal.ErrMessage);
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
strMsg += ds.Tables[0].Rows[i][0].ToString() + "#" + ds.Tables[0].Rows[i][1].ToString() + "#";
}
if (ds.Tables[1].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
strMsg += ds.Tables[1].Rows[i]["ThosandNotes"].ToString() + "#" + ds.Tables[1].Rows[i]["FiveHundredNotes"].ToString() + "#" + ds.Tables[1].Rows[i]["HundredNotes"].ToString() + "#" + ds.Tables[1].Rows[i]["FiftyNote"].ToString() + "#" + ds.Tables[1].Rows[i]["TwentyNotes"].ToString() + "#" + ds.Tables[1].Rows[i]["TenNotes"].ToString() + "#" + ds.Tables[1].Rows[i]["FiveNotes"].ToString() + "#" + ds.Tables[1].Rows[i]["TwoNotes"].ToString() + "#" + ds.Tables[1].Rows[i]["OneNotes"].ToString() + "#" + ds.Tables[1].Rows[i]["Amount"].ToString();
}
}
}
else
{
return("No Record Found");
}
}
return(strMsg);
}