public static FootTraffic GetFTByKioskAndToday(int kioskid, string date)
{
var dal = new FootTrafficDAL();
var ins = new FootTraffic();
foreach (DataRow dr in dal.GetFTByKioskAndToday(kioskid, date).Rows)
{
ins.Bind(dr);
}
return(ins);
}
public static List <FootTraffic> ReportFTByDay(string from, string to, int kioskid)
{
var dal = new FootTrafficDAL();
var collection = new List <FootTraffic>();
foreach (DataRow row in dal.ReportFTByDay(from, to, kioskid).Rows)
{
var ins = new FootTraffic();
ins.Bind(row);
collection.Add(ins);
}
return(collection);
}
public static List <FootTraffic> ReportFTByMonth()
{
var dal = new FootTrafficDAL();
var collection = new List <FootTraffic>();
foreach (DataRow row in dal.ReportFTByMonth().Rows)
{
var instance = new FootTraffic();
instance.Bind(row);
collection.Add(instance);
}
return(collection);
}
internal void InsertFootTrafficCount(FootTraffic ins)
{
base.com.CommandText = "spPostFootTrafficCounter";
base.com.Parameters.AddWithValue("8am_", ins.i8am);
base.com.Parameters.AddWithValue("9am_", ins.i9am);
base.com.Parameters.AddWithValue("10am_", ins.i10am);
base.com.Parameters.AddWithValue("11am_", ins.i11am);
base.com.Parameters.AddWithValue("12pm_", ins.i12pm);
base.com.Parameters.AddWithValue("1pm_", ins.i1pm);
base.com.Parameters.AddWithValue("2pm_", ins.i2pm);
base.com.Parameters.AddWithValue("3pm_", ins.i3pm);
base.com.Parameters.AddWithValue("4pm_", ins.i4pm);
base.com.Parameters.AddWithValue("5pm_", ins.i5pm);
base.com.Parameters.AddWithValue("6pm_", ins.i6pm);
base.com.Parameters.AddWithValue("7pm_", ins.i7pm);
base.com.Parameters.AddWithValue("8pm_", ins.i8pm);
base.com.Parameters.AddWithValue("9pm_", ins.i9pm);
base.com.Parameters.AddWithValue("10pm_", ins.i10pm);
base.com.Parameters.AddWithValue("TotalFT_", ins.TotalFT);
base.com.Parameters.AddWithValue("KioskID_", ins.KioskID);
base.com.Parameters.AddWithValue("EmpCode_", ins.EmpCode);
try
{
int res = Convert.ToInt32(base.com.ExecuteScalar());
if (res <= 0)
{
throw new ArgumentException("Failed");
}
}
catch (Exception)
{
throw;
}
}
public static void InsertFootTrafficCount(FootTraffic ins)
{
var dal = new FootTrafficDAL();
dal.InsertFootTrafficCount(ins);
}
public static List<FootTraffic> ReportFTByMonth()
{
var dal = new FootTrafficDAL();
var collection = new List<FootTraffic>();
foreach (DataRow row in dal.ReportFTByMonth().Rows)
{
var instance = new FootTraffic();
instance.Bind(row);
collection.Add(instance);
}
return collection;
}
public static List<FootTraffic> ReportFTByDay(string from, string to, int kioskid)
{
var dal = new FootTrafficDAL();
var collection = new List<FootTraffic>();
foreach (DataRow row in dal.ReportFTByDay(from, to, kioskid).Rows)
{
var ins = new FootTraffic();
ins.Bind(row);
collection.Add(ins);
}
return collection;
}
public static void InsertFootTrafficCount(FootTraffic ins)
{
var dal = new FootTrafficDAL();
dal.InsertFootTrafficCount(ins);
}
public static FootTraffic GetFTByKioskAndToday(int kioskid, string date)
{
var dal = new FootTrafficDAL();
var ins = new FootTraffic();
foreach (DataRow dr in dal.GetFTByKioskAndToday(kioskid, date).Rows)
{
ins.Bind(dr);
}
return ins;
}
