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