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