private async void ShtoShpenzim_Clicked(object sender, EventArgs e)
{
if (shpenzimetPicker.SelectedItem != null)
{
UserExpenseVM userInc = new UserExpenseVM();
userInc.UserId = (int)Application.Current.Properties["userId"];
userInc.ExpenseId = shpenzimetPicker.SelectedIndex + 1;
userInc.ExpenseValue = Convert.ToDecimal(shpenzimiEntry.Text);
HttpClient httpClient = new HttpClient();
var json = JsonConvert.SerializeObject(userInc);
var uri = new Uri("https://personalexpensesapi.conveyor.cloud/api/usersexpens");
var content = new StringContent(json, Encoding.UTF8, "application/json");
HttpResponseMessage response = await httpClient.PostAsync(uri, content);
if (response.IsSuccessStatusCode)
{
shpenzimiEntry.Text = null;
Vibration.Vibrate();
await DisplayAlert("Sukses", "Shpenzimi u shtua me sukses", "OK");
await Navigation.PopAsync();
}
else
{
await DisplayAlert("DESHTOI", "Ka deshtuar " + json, "OK");
}
}
}
public ActionResult UserExpenseList(DataTablesViewModel param, string fromDate, string toDate)
{
try
{
if (!PermissionControl.CheckPermission(UserAppPermissions.ALP_Costing_View))
{
return(RedirectToAction("Restricted", "Home"));
}
DateTime frdate = DateTime.Now;
if (!string.IsNullOrWhiteSpace(fromDate))
{
frdate = DateTime.Parse(fromDate);
}
DateTime tdate = DateTime.Now;
if (!string.IsNullOrWhiteSpace(toDate))
{
tdate = DateTime.Parse(toDate);
}
logger.DebugFormat("Getting Users Expense List with From Date [{0}] and To date [{1}]", frdate.ToShortDateString(), tdate.ToShortDateString());
UserExpenseVM userExpenseVM = new UserExpenseVM();
userExpenseVM.DTObject = param;
var list = userExpenseManagement.GetAllUserExpensesByParam(userExpenseVM, frdate, tdate);
logger.DebugFormat("Successfully Retrieve Users Expense List Records [{2}] with From Date [{0}] and To date [{1}]", frdate.ToShortDateString(), tdate.ToShortDateString(), list.Count());
return(Json(new
{
sEcho = param.draw,
iTotalRecords = list.Select(i => i.DTObject.TotalRecordsCount).FirstOrDefault(),
iTotalDisplayRecords = list.Select(i => i.DTObject.TotalRecordsCount).FirstOrDefault(), // Filtered Count
aaData = list
}));
}
catch (Exception ex)
{
logger.ErrorFormat("Exception Raised : Message[{0}] Stack Trace [{1}] ", ex.Message, ex.StackTrace);
return(null);
}
}
public IEnumerable <UserExpenseVM> GetAllUserExpensesByParam(UserExpenseVM param, DateTime fromDate, DateTime toDate)
{
return(userExpenseRepository.GetAllUserExpensesByParam(param, fromDate, toDate));
}
private IQueryable <UserExpenseVM> GetUserExpenseFiltersOrderQuery(IQueryable <UserExpenseVM> query, UserExpenseVM param)
{
try
{
// var expression = PredicateBuilder.True<AssetsEntity>();
if (param == null)
{
return(query);
}
int index = -1;
foreach (var columnData in param.DTObject.columns)
{
index += 1;
if (columnData.orderable)
{
foreach (var row in param.DTObject.order.Where(i => i.column == index))
{
if (row.dir == "asc")
{
query = query.OrderBy(columnData.data);
}
else
{
query = query.OrderByDescending(columnData.data);
}
}
}
}
// string id = Utility.CovertID(param.DTObject.search.value, "UE-");
if (param.DTObject.search.value != null && !string.IsNullOrEmpty(param.DTObject.search.value))
{
query = query.Where(col => (
col.DepartmentName.ToUpper().Contains(param.DTObject.search.value.ToUpper()) ||
col.UserName.ToUpper().Contains(param.DTObject.search.value.ToUpper()) ||
col.UserNumber.ToUpper().Contains(param.DTObject.search.value.ToUpper()) ||
col.Billable_Salary_PKR.ToString().Contains(param.DTObject.search.value.ToUpper()) ||
col.Billable_Salary_USD.ToString().Contains(param.DTObject.search.value.ToUpper())
));
}
return(query);
}
catch (Exception ex)
{
logger.ErrorFormat("Exception Raised : Message[{0}] Stack Trace [{1}] ", ex.Message, ex.StackTrace);
return(null);
}
}
public IEnumerable <UserExpenseVM> GetAllUserExpensesByParam(UserExpenseVM param, DateTime fromDate, DateTime toDate)
{
try
{
IQueryable <UserExpenseVM> query = (from ue in DbContext.UserExpenses.AsNoTracking()
join user in DbContext.Users.AsNoTracking() on ue.UserID.ToString() equals user.Id
join dept in DbContext.Departments.AsNoTracking() on ue.DepartmentID equals dept.DepartmentID
orderby ue.ExpenseDate descending
where (DbFunctions.TruncateTime(ue.ExpenseDate) >= DbFunctions.TruncateTime(fromDate) && DbFunctions.TruncateTime(ue.ExpenseDate) <= DbFunctions.TruncateTime(toDate) && ue.IsActive)
select new UserExpenseVM
{
UserExpenseID = ue.UserExpenseID,
SerialNumber = ue.SerialNumber,
UserName = user.FirstName + " " + user.LastName,
UserNumber = user.EmployeeNumber,
DepartmentName = dept.Name,
ExpenseDate = ue.ExpenseDate,
Monthly_Salary = ue.Monthly_Salary,
Monthly_Salary2 = ue.Monthly_Salary2,
EOBI_Employer = ue.EOBI_Employer,
PF_Employer = ue.PF_Employer,
Mobile_Allowance = ue.Mobile_Allowance,
Bonus = ue.Bonus,
Meal_Reimbursement = ue.Meal_Reimbursement,
Transportation = ue.Transportation,
Leave_Encashment = ue.Leave_Encashment,
Incentive_PSM = ue.Incentive_PSM,
Health_Insurance = ue.Health_Insurance,
Medical_OPD = ue.Medical_OPD,
Billable_Salary_PKR = ue.Billable_Salary_PKR,
Billable_Salary_USD = ue.Billable_Salary_USD
});
query = GetUserExpenseFiltersOrderQuery(query, param);
int totalRecord = query.Count();
var userExpenseVM = query.Skip(param.DTObject.start).Take(param.DTObject.length).ToList().Select(index => new UserExpenseVM
{
UserExpenseID = index.UserExpenseID,
SerialNumber = index.SerialNumber,
UserName = index.UserName,
UserNumber = index.UserNumber,
DepartmentName = index.DepartmentName,
ExpenseDate = index.ExpenseDate,
Monthly_Salary = index.Monthly_Salary,
Monthly_Salary2 = index.Monthly_Salary2,
EOBI_Employer = index.EOBI_Employer,
PF_Employer = index.PF_Employer,
Mobile_Allowance = index.Mobile_Allowance,
Bonus = index.Bonus,
Meal_Reimbursement = index.Meal_Reimbursement,
Transportation = index.Transportation,
Leave_Encashment = index.Leave_Encashment,
Incentive_PSM = index.Incentive_PSM,
Health_Insurance = index.Health_Insurance,
Medical_OPD = index.Medical_OPD,
Billable_Salary_PKR = index.Billable_Salary_PKR,
Billable_Salary_USD = index.Billable_Salary_USD,
DTObject = new DataTablesViewModel()
{
TotalRecordsCount = totalRecord
}
}).ToList();
return(userExpenseVM);
}
catch (Exception ex)
{
logger.ErrorFormat("Exception Raised : Message[{0}] Stack Trace [{1}] ", ex.Message, ex.StackTrace);
return(null);
}
}
