public Decimal GetAverageTurnOverMonthByYear(int year)
{
TurnOverObjectCollection turnOvers = new TurnOverObjectCollection();
Decimal turnOver = new Decimal();
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("TAS_TurnOver_ByYear");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@YEAR", year));
turnOvers = TurnOverConvertor.DataTableToCollection(this.ExecuteNonQuery(cmd, false).Tables[0]);
for (int i = 0; i < turnOvers.Count; i++)
{
turnOver += turnOvers[i].TurnOver;
}
int months = 1;
if (year != System.DateTime.Now.Year)
{
months = 12;
}
else
{
months = System.DateTime.Now.Month;
}
turnOver = turnOver / months;
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return(turnOver);
}
public TurnOverObjectCollection GetAll()
{
TurnOverObjectCollection turnOvers = new TurnOverObjectCollection();
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("TAS_TurnOver");
cmd.CommandType = CommandType.StoredProcedure;
turnOvers = TurnOverConvertor.DataTableToCollection(this.ExecuteNonQuery(cmd, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return(turnOvers);
}
public TurnOverObjectCollection GetByCustomer(CustomerObject customer)
{
TurnOverObjectCollection turnOvers = new TurnOverObjectCollection();
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("TAS_TurnOver_ByCustomer");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@TNR_ID", customer.TasID));
turnOvers = TurnOverConvertor.DataTableToCollection(this.ExecuteNonQuery(cmd, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return(turnOvers);
}
public TurnOverObjectCollection GetByGreaterThanDate(DateTime date)
{
TurnOverObjectCollection turnOvers = new TurnOverObjectCollection();
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("TAS_TurnOver_ByGreaterThanDate");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@DATE", date));
turnOvers = TurnOverConvertor.DataTableToCollection(this.ExecuteNonQuery(cmd, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return(AddZeroTurnOvers(turnOvers));
}
public TurnOverObjectCollection GetByMonth(int year, int month)
{
TurnOverObjectCollection turnOvers = new TurnOverObjectCollection();
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("TAS_TurnOver_ByMonth");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@YEAR", year));
cmd.Parameters.Add(new SqlParameter("@MONTH", month));
turnOvers = TurnOverConvertor.DataTableToCollection(this.ExecuteNonQuery(cmd, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return(turnOvers);
}
public TurnOverObjectCollection GetByVehicleByYear(int year, string vehicle)
{
TurnOverObjectCollection turnOvers = new TurnOverObjectCollection();
SqlCommand cmd = null;
try
{
cmd = new SqlCommand("TAS_TurnOver_ByVehicleByYear");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@YEAR", year));
cmd.Parameters.Add(new SqlParameter("@VEHICLE", vehicle));
turnOvers = TurnOverConvertor.DataTableToCollection(this.ExecuteNonQuery(cmd, false).Tables[0]);
}
catch (System.Exception exception1)
{
throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
}
return(AddZeroTurnOvers(turnOvers));
}
