private async void GetUserTimeSheet(DateTime selectedMonth, DateTime lastdate) { ShowLoading(true); VMUserDailyLogin objvmuserlogin = null; DateTime firstDayOfMonth = selectedMonth; try { if (App.Current.Properties.ContainsKey("LoginUser") && App.Current.Properties.ContainsKey("apitoken")) { var objloginuser = (User)App.Current.Properties["LoginUser"]; UserDailyLogin objdailylogin = new UserDailyLogin(); if (pickerOperator.SelectedItem != null) { var objselectedOperator = (User)pickerOperator.SelectedItem; objdailylogin.UserID.UserID = objselectedOperator.UserID; } objdailylogin.HistoryFromDate = firstDayOfMonth; objdailylogin.HistoryToDate = lastdate; await Task.Run(() => { objvmuserlogin = dal_menubar.GetUserDailyLoginHistory(Convert.ToString(App.Current.Properties["apitoken"]), objdailylogin); }); if (objvmuserlogin != null && objvmuserlogin.UserDailyLoginID.Count > 0) { lvTimeSheetSummary.ItemsSource = objvmuserlogin.UserDailyLoginID; spanWorkedDays.Text = Convert.ToString(objvmuserlogin.WorkedDays); spanAbsentDays.Text = Convert.ToString(objvmuserlogin.AbsentDays); spanTotalHours.Text = objvmuserlogin.TotalHours; spanOperatorName.Text = objloginuser.UserName + "-#" + objloginuser.UserCode; spanSupervisorName.Text = objvmuserlogin.SuperVisorName; } else { lvTimeSheetSummary.ItemsSource = null; spanWorkedDays.Text = spanAbsentDays.Text = spanTotalHours.Text = spanOperatorName.Text = ""; } } } catch (Exception ex) { ShowLoading(false); dal_Exceptionlog.InsertException(Convert.ToString(App.Current.Properties["apitoken"]), "Operator App", ex.Message, "TimeSheet.xaml.cs", "", "GetUserTimeSheet"); } ShowLoading(false); }
public VMUserDailyLogin GetUserDailyLoginHistory(string accessToken, UserDailyLogin objDailyLogin) { VMUserDailyLogin objtimesheet = new VMUserDailyLogin(); try { string baseUrl = Convert.ToString(App.Current.Properties["BaseURL"]); using (var client = new HttpClient()) { client.BaseAddress = new Uri(baseUrl); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); // Add the Authorization header with the AccessToken. client.DefaultRequestHeaders.Add("Authorization", "bearer " + accessToken); // create the URL string. string url = "api/InstaOperator/postOPAPPUserDailyLoginHistory"; // make the request var json = JsonConvert.SerializeObject(objDailyLogin); var content = new StringContent(json, Encoding.UTF8, "application/json"); HttpResponseMessage response = client.PostAsync(url, content).Result; if (response.IsSuccessStatusCode) { string jsonString = response.Content.ReadAsStringAsync().Result; if (jsonString != null) { APIResponse apiResult = JsonConvert.DeserializeObject <APIResponse>(jsonString); if (apiResult.Result) { objtimesheet = JsonConvert.DeserializeObject <VMUserDailyLogin>(Convert.ToString(apiResult.Object)); } } } } } catch (Exception ex) { } return(objtimesheet); }
public VMUserDailyLogin GetUserDailyLoginHistory(UserDailyLogin objDailyLogin) { VMUserDailyLogin vmuserlogin = new VMUserDailyLogin(); DataSet dslogins = new DataSet(); try { using (SqlConnection sqlconn_obj = new SqlConnection(SqlHelper.GetDBConnectionString())) { using (SqlCommand sqlcmd_obj = new SqlCommand("OPAPP_PROC_GetUserDailyLoginHistory", sqlconn_obj)) { sqlcmd_obj.CommandType = CommandType.StoredProcedure; sqlcmd_obj.Parameters.AddWithValue("@UserID", (objDailyLogin.UserID.UserID == null || objDailyLogin.UserID.UserID == 0) ? (object)DBNull.Value : objDailyLogin.UserID.UserID); sqlcmd_obj.Parameters.AddWithValue("@LocationParkingLotID", (objDailyLogin.LocationParkingLotID.LocationParkingLotID == null || objDailyLogin.LocationParkingLotID.LocationParkingLotID == 0) ? (object)DBNull.Value : objDailyLogin.LocationParkingLotID.LocationParkingLotID); sqlcmd_obj.Parameters.AddWithValue("@HistoryFromDate", (objDailyLogin.HistoryFromDate == null ? (object)DBNull.Value : objDailyLogin.HistoryFromDate)); sqlcmd_obj.Parameters.AddWithValue("@HistoryToDate", (objDailyLogin.HistoryToDate == null ? (object)DBNull.Value : objDailyLogin.HistoryToDate)); sqlconn_obj.Open(); SqlDataAdapter sqldap = new SqlDataAdapter(sqlcmd_obj); sqldap.Fill(dslogins); if (dslogins.Tables.Count > 0) { DataTable dtUserLogins = new DataTable(); DataTable dtSummary = new DataTable(); dtUserLogins = dslogins.Tables[0]; dtSummary = dslogins.Tables[1]; List <UserDailyLogin> lstlogins = new List <UserDailyLogin>(); for (var i = 0; i < dtUserLogins.Rows.Count; i++) { UserDailyLogin objUserDailyLogin = new UserDailyLogin(); //objUserDailyLogin.UserID.UserID = dtUserLogins.Rows[i]["UserID"] == DBNull.Value ? 0 : Convert.ToInt32(dtUserLogins.Rows[i]["UserID"]); //objUserDailyLogin.UserID.UserName = Convert.ToString(dtUserLogins.Rows[i]["UserName"]); objUserDailyLogin.LocationParkingLotID.LocationParkingLotID = dtUserLogins.Rows[i]["LocationParkingLotID"] == DBNull.Value ? 0 : Convert.ToInt32(dtUserLogins.Rows[i]["LocationParkingLotID"]); objUserDailyLogin.LocationParkingLotID.LocationParkingLotName = Convert.ToString(dtUserLogins.Rows[i]["LocationParkingLotName"]); objUserDailyLogin.LocationParkingLotID.LocationID.LocationID = dtUserLogins.Rows[i]["LocationID"] == DBNull.Value ? 0 : Convert.ToInt32(dtUserLogins.Rows[i]["LocationID"]); objUserDailyLogin.LocationParkingLotID.LocationID.LocationName = Convert.ToString(dtUserLogins.Rows[i]["LocationName"]); //objUserDailyLogin.HistoryFromDate = dtUserLogins.Rows[i]["LoginTime"] == DBNull.Value ? (Nullable<DateTime>)null : Convert.ToDateTime(dtUserLogins.Rows[i]["LoginTime"]); objUserDailyLogin.TimeSheetDate = dtUserLogins.Rows[i]["TimeSheetDate"] == DBNull.Value ? (Nullable <DateTime>)null : Convert.ToDateTime(dtUserLogins.Rows[i]["TimeSheetDate"]); objUserDailyLogin.LoginTime = dtUserLogins.Rows[i]["LoginTime"] == DBNull.Value ? "" : Convert.ToString(dtUserLogins.Rows[i]["LoginTime"]); objUserDailyLogin.LogoutTime = dtUserLogins.Rows[i]["LogoutTime"] == DBNull.Value ? "" : Convert.ToString(dtUserLogins.Rows[i]["LogoutTime"]); objUserDailyLogin.NoofHours = dtUserLogins.Rows[i]["NoofHours"] == DBNull.Value ? "0" : Convert.ToString(dtUserLogins.Rows[i]["NoofHours"]); lstlogins.Add(objUserDailyLogin); } if (dtSummary.Rows.Count > 0) { vmuserlogin.WorkedDays = dtSummary.Rows[0]["WorkedDays"] == DBNull.Value ? 0 : Convert.ToInt32(dtSummary.Rows[0]["WorkedDays"]); vmuserlogin.AbsentDays = dtSummary.Rows[0]["AbsentDays"] == DBNull.Value ? 0 : Convert.ToInt32(dtSummary.Rows[0]["AbsentDays"]); vmuserlogin.TotalHours = dtSummary.Rows[0]["TotalHours"] == DBNull.Value ? "0" : Convert.ToString(dtSummary.Rows[0]["TotalHours"]); vmuserlogin.SuperVisorName = dtSummary.Rows[0]["SuperVisorName"] == DBNull.Value ? "0" : Convert.ToString(dtSummary.Rows[0]["SuperVisorName"]); } vmuserlogin.UserDailyLoginID = lstlogins; } } } } catch (Exception ex) { objExceptionlog.InsertException("WebAPI", ex.Message, "DALUserLoginVerification", "Proc: " + "OPAPP_PROC_GetUserDailyLoginHistory", "GetUserDailyLoginHistory"); } return(vmuserlogin); }