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 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; }