public info_ofdayPage(inoutDetailsPerDate Results, string totalInTime, string Ename, string date, string weekday) { InitializeComponent(); this.BackgroundColor = ColorResources.PageBackgroundColor; getData(Results, totalInTime, Ename, date, weekday); }
public void getData(inoutDetailsPerDate Results, string totalInTime, string ename, string date, string weekday) { foreach (inTimes time in Results.inTimes) { ListOf_IN_times.Add(time); } foreach (outTimes time in Results.outTimes) { ListOf_OUT_times.Add(time); } ListView_inTime.ItemsSource = ListOf_IN_times; ListView_outTime.ItemsSource = ListOf_OUT_times; Label_totalInTime.Text = "Total In Time " + totalInTime; Label_Details.Text = ename + ": " + date + " " + weekday; Label_Details.FontAttributes = FontAttributes.Bold; Label_totalInTime.FontAttributes = FontAttributes.Italic; }
public inoutDetailsPerDate get_inoutDetailsPerDate(get_inoutDetails obj) { inoutDetailsPerDate data = new inoutDetailsPerDate(); Debug.WriteLine(string.Format("{0:yyyy-MM-dd}", obj.choosedDate.ToString()) + " " + obj.userid.ToString()); Debug.WriteLine(" Universal Time :" + Convert.ToDateTime(obj.choosedDate).ToUniversalTime().ToString("yyyy-MM-dd")); string q4 = "select distinct inTime,isdevicechanged,deviceid,location,distancefromorigin from in_out where inTime != '00:00:00' and uid='" + obj.userid + "' and _date='" + Convert.ToDateTime(obj.choosedDate).ToString("yyyy-MM-dd") + "';"; string q5 = "select distinct outTime,isdevicechanged,deviceid,location,distancefromorigin from in_out where outTime != '00:00:00' and uid='" + obj.userid + "' and _date='" + Convert.ToDateTime(obj.choosedDate).ToString("yyyy-MM-dd") + "';"; MySqlCommand cmd4 = new MySqlCommand(q4, conn); MySqlCommand cmd5 = new MySqlCommand(q5, conn); List <inTimes> MYinT = new List <inTimes>(); List <outTimes> MYoutT = new List <outTimes>(); MySqlDataReader rdr4; MySqlDataReader rdr5; conn.Open(); rdr4 = cmd4.ExecuteReader(); while (rdr4.Read()) { inTimes A = new inTimes(); //MYinT.Add(getConvert(rdr4.GetString("inTime").Substring(10, 8))); //inT.Add((rdr4.getString("inTime").Substring(10,8))); A.INTIMES = getConvert(rdr4.GetString("inTime").Substring(10, 8)); A.deviceid = rdr4.GetString("deviceid"); A.location = rdr4.GetString("location"); if (rdr4.GetFloat("DistanceFromOrigin") > 100.000 || rdr4.GetInt16("IsDeviceChanged") == 1) { Debug.WriteLine(rdr4.GetFloat("DistanceFromOrigin").ToString()); A.IsDevice_or_LocationChanged = "Red"; } else { A.IsDevice_or_LocationChanged = "White"; } MYinT.Add(A); } conn.Close(); conn.Open(); rdr5 = cmd5.ExecuteReader(); while (rdr5.Read()) { outTimes B = new outTimes(); //MYoutT.Add(getConvert(rdr5.GetString("outTime").Substring(10, 8))); B.OUTTIMES = getConvert(rdr5.GetString("outTime").Substring(10, 8)); B.deviceid = rdr5.GetString("deviceid"); B.location = rdr5.GetString("location"); if (rdr5.GetFloat("DistanceFromOrigin") > 100.000 || rdr5.GetInt16("IsDeviceChanged") == 1) { Debug.WriteLine(rdr5.GetFloat("DistanceFromOrigin").ToString()); B.IsDevice_or_LocationChanged = "Red"; } else { B.IsDevice_or_LocationChanged = "White"; } MYoutT.Add(B); } conn.Close(); data.inTimes = MYinT; data.outTimes = MYoutT; return(data); }