public List <CashOfficeReport> GetCashOfficeReport(DateTimeFromToQuery query)
{
//...Create New Instance of Object...
List <CashOfficeReport> list = new List <CashOfficeReport>();
CashOfficeReport ins;
//...Database Connection...
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.SqlConn();
SqlCommand cmdI = new SqlCommand();
cmdI.CommandTimeout = 540;
cmdI.Connection = con;
cmdI.CommandText = "f_Admin_Report_CashOffice";
cmdI.CommandType = System.Data.CommandType.StoredProcedure;
cmdI.Parameters.AddWithValue("@SelectedDate", query.From);
cmdI.Connection.Open();
SqlDataReader drI = cmdI.ExecuteReader();
//...Retrieve Data...
if (drI.HasRows)
{
while (drI.Read())
{
ins = new CashOfficeReport();
ins.MoneyUnit = drI["MoneyUnit"].ToString();
ins.Sealed = Convert.ToDecimal(drI["Sealed"]);
ins.Opened = Convert.ToDecimal(drI["Opened"]);
ins.TotalInOffice = Convert.ToDecimal(drI["Notes"]);
ins.CashierTotal = Convert.ToDecimal(drI["Cashiers"]);
ins.Drop = Convert.ToDecimal(drI["Drops"]);
list.Add(ins);
}
}
//...Close Connections...
cmdI.Connection.Close();
con.Dispose();
//...Return...
return(list);
}
public List<CashOfficeReport> GetCashOfficeReport(DateTimeFromToQuery query)
{
//...Create New Instance of Object...
List<CashOfficeReport> list = new List<CashOfficeReport>();
CashOfficeReport ins;
//...Database Connection...
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.SqlConn();
SqlCommand cmdI = new SqlCommand();
cmdI.CommandTimeout = 540;
cmdI.Connection = con;
cmdI.CommandText = "f_Admin_Report_CashOffice";
cmdI.CommandType = System.Data.CommandType.StoredProcedure;
cmdI.Parameters.AddWithValue("@SelectedDate", query.From);
cmdI.Connection.Open();
SqlDataReader drI = cmdI.ExecuteReader();
//...Retrieve Data...
if (drI.HasRows)
{
while (drI.Read())
{
ins = new CashOfficeReport();
ins.MoneyUnit = drI["MoneyUnit"].ToString();
ins.Sealed = Convert.ToDecimal(drI["Sealed"]);
ins.Opened = Convert.ToDecimal(drI["Opened"]);
ins.TotalInOffice = Convert.ToDecimal(drI["Notes"]);
ins.CashierTotal = Convert.ToDecimal(drI["Cashiers"]);
ins.Drop = Convert.ToDecimal(drI["Drops"]);
list.Add(ins);
}
}
//...Close Connections...
cmdI.Connection.Close();
con.Dispose();
//...Return...
return list;
}
