private DailyFilterModel ParseFilterInfo(Business.Infrastructure.FilterInfo filter)
{
DailyFilterModel fm = new DailyFilterModel();
Business.Infrastructure.FilterInfo single;
DateTime start, end;
if (filter != null && filter.Filters != null)
{
single = filter.Filters.Where(m => m.Field == "StartDate").FirstOrDefault();
if (single != null)
{
start = DateTime.Parse(single.Value);
fm.StartDate = new DateTime(start.Year, start.Month, start.Day, 0, 0, 0);
}
single = filter.Filters.Where(m => m.Field == "EndDate").FirstOrDefault();
if (single != null)
{
end = DateTime.Parse(single.Value);
fm.EndDate = new DateTime(end.Year, end.Month, end.Day, 23, 59, 59);
}
single = filter.Filters.Where(m => m.Field == "CarModelName").FirstOrDefault();
if (single != null)
{
fm.CarModelName = single.Value;
}
}
return(fm);
}
public string Clear()
{
Guid idOwner = new Guid("156c2cde-2c19-46c3-bcba-a27f9d1e4998");
Guid idCustomer = new Guid("54612b5e-611f-4b71-9dbd-ed35b6f2976b");
Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo
{
Filters = new List <Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = idOwner.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "id_customer", Operator = "eq", Value = idCustomer.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "created_by", Operator = "eq", Value = "dummy"
}
},
Logic = "and"
};
List <rent> rents = RepoRent.FindAll(null, null, null, filters);
int count = rents.Count();
foreach (rent row in rents)
{
RepoRent.Delete(row);
}
return(count.ToString() + " dihapus");
}
private DailyFilterModel ParseFilterInfo(Business.Infrastructure.FilterInfo filter)
{
DailyFilterModel fm = new DailyFilterModel();
Business.Infrastructure.FilterInfo single;
if (filter != null && filter.Filters != null)
{
single = filter.Filters.Where(m => m.Field == "StartDate").FirstOrDefault();
if (single != null)
{
fm.StartDate = DateTime.Parse(single.Value);
fm.StartDate = new DateTime(fm.StartDate.Year, fm.StartDate.Month, 1, 0, 0, 0);
}
single = filter.Filters.Where(m => m.Field == "EndDate").FirstOrDefault();
if (single != null)
{
fm.EndDate = DateTime.Parse(single.Value);
fm.EndDate = fm.EndDate.AddMonths(1);
fm.EndDate = new DateTime(fm.EndDate.Year, fm.EndDate.Month, 1, 23, 59, 59);
fm.EndDate = fm.EndDate.AddDays(-1);
}
}
return(fm);
}
private void SetModelOptionsOnCreate(DriverFormStub formStub)
{
//kamus
Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo {
Filters = new List <Business.Infrastructure.FilterInfo>(), Logic = "and"
};
List <owner_user> ownerUser;
List <driver> ownerDriverList; //driver punya owner
List <string> driverUsernameList; //username milik driver
//algoritma
formStub.FillTypeOptions();
//mengisi pilihan username
filters.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = formStub.IdOwner.ToString()
});
ownerUser = RepoOwner.FindAllUser(null, null, null, filters);
ownerDriverList = RepoDriver.FindAll(null, null, null, filters);
driverUsernameList = ownerDriverList.Select(m => m.username).ToList();
//menghapus data dari ownerUser yang username nya ada di driverUsernameList
ownerUser.RemoveAll(m => driverUsernameList.Contains(m.username));
formStub.FillUsernameOptions(ownerUser);
}
private void SetModelOptionsOnEdit(DriverFormStub model)
{
//kamus
Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo {
Filters = new List <Business.Infrastructure.FilterInfo>(), Logic = "and"
};
List <owner_user> ownerUser;
List <driver> ownerDriverList; //driver punya owner
List <string> driverUsernameList; //username milik driver
//algoritma
filters.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = model.IdOwner.ToString()
});
ownerUser = RepoOwner.FindAllUser(null, null, null, filters);
ownerDriverList = RepoDriver.FindAll(null, null, null, filters);
driverUsernameList = ownerDriverList.Select(m => m.username).ToList();
//hapus di driverUsernameList yang isinya sama dengan Username yang di edit
driverUsernameList.Remove(model.Username);
ownerUser.RemoveAll(m => driverUsernameList.Contains(m.username));
model.FillUsernameOptions(ownerUser);
model.FillTypeOptions();
}
private void AddOwnerFilterRent(Business.Infrastructure.FilterInfo filters, Guid idOwner)
{
if (filters == null)
{
filters = new Business.Infrastructure.FilterInfo {
Filters = new List <Business.Infrastructure.FilterInfo>(), Logic = "and"
}
}
;
if (filters.Filters == null)
{
filters.Filters = new List <Business.Infrastructure.FilterInfo>();
}
if (idOwner != null)
{
filters.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = idOwner.ToString()
});
}
}
#endregion
}
public string Get()
{
//kamus
List <d_notification> notificationList;
CustomPrincipal user = User as CustomPrincipal;
Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo {
Filters = new List <Business.Infrastructure.FilterInfo>(), Logic = "and"
};
List <string> messageList;
string response;
//algoritma
filters.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = user.IdOwner.Value.ToString()
});
filters.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "is_read", Operator = "eq", Value = false.ToString()
});
notificationList = RepoDummyNotification.FindAll(null, null, null, filters);
foreach (d_notification n in notificationList)
{
if (n.is_read == false)
{
n.is_read = true;
}
RepoDummyNotification.Save(n);
}
messageList = notificationList.Select(m => m.message).ToList();
response = string.Join("<br>", messageList);
return(response);
}
public HttpResponseMessage FindRent([FromBody] GetRentParam param)
{
//kamus
Rent rent = null;
rent dbRent;
HttpStatusCode status = HttpStatusCode.OK;
HttpResponseMessage response;
string message = null;
Business.Infrastructure.FilterInfo filters;
//algoritma
filters = new Business.Infrastructure.FilterInfo {
Field = "code", Operator = "eq", Value = param.RentCode
};
dbRent = RepoRent.Find(filters);
if (dbRent != null)
{
rent = new Rent(dbRent);
}
else
{
message = "Kode Booking tidak ditemukan";
status = HttpStatusCode.BadRequest;
}
response = Request.CreateResponse(status, rent);
if (message != null)
{
response.Content.Headers.Add("ResponseMessage", message);
}
return(response);
}
public string BindingCarModel()
{
//kamus
GridRequestParameters param = GridRequestParameters.Current;
Business.Infrastructure.FilterInfo filters = param.Filters;
Business.Infrastructure.FilterInfo carFilters;
Guid? idOwner = (User as CustomPrincipal).IdOwner;
List <car_model> carModels;
List <CarModelPresentationStub> result = new List <CarModelPresentationStub>();
int total = 0;
List <car> cars;
//algoritma
carFilters = new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = idOwner.ToString()
};
//filters.Filters = new List<Business.Infrastructure.FilterInfo>();
//filters.Filters.Add(new Business.Infrastructure.FilterInfo { Field = "id_owner", Operator = "eq", Value = idOwner.Value.ToString() });
//filters.Filters.Add(new Business.Infrastructure.FilterInfo { Field = "is_active", Operator = "eq", Value = "true" });
cars = RepoCar.FindAll(null, null, null, carFilters).ToList();
carModels = cars.Select(m => m.car_model).Distinct().ToList();
total = carModels.Count();
result = new CarModelPresentationStub().MapList(carModels).OrderBy(x => x.Name).ToList();
return(new JavaScriptSerializer().Serialize(new { total = total, data = result }));
}
public HttpResponseMessage Submit([FromBody] GetRentParam param)
{
//kamus
HttpResponseMessage response;
HttpStatusCode status = HttpStatusCode.OK;
Business.Infrastructure.FilterInfo filters;
rent rent;
api_rent apiRent;
ApiRentStatus apiStatus;
string message = null;
//algoritma
filters = new Business.Infrastructure.FilterInfo {
Field = "code", Operator = "eq", Value = param.RentCode
};
rent = RepoRent.Find(filters);
if (rent == null)
{
status = HttpStatusCode.BadRequest;
message = WebServiceMessage.OrderNotFoundAlert;
}
else
{
filters = new Business.Infrastructure.FilterInfo {
Field = "id_rent", Operator = "eq", Value = rent.id.ToString()
};
apiRent = RepoApiRent.Find(filters);
if (apiRent == null)
{
status = HttpStatusCode.BadRequest;
message = WebServiceMessage.OrderNotFoundAlert;
}
else
{
apiStatus = (ApiRentStatus)Enum.Parse(typeof(ApiRentStatus), apiRent.status);
if (apiRent.cancellation_status != null)
{
status = HttpStatusCode.BadRequest;
message = WebServiceMessage.CancelAlert;
}
else
{
apiRent.cancellation_status = ApiRentCancellationStatus.CANCEL.ToString();
RepoApiRent.Save(apiRent);
}
}
}
response = Request.CreateResponse(status);
if (message != null)
{
response.Headers.Add("ResponseMessage", message);
}
return(response);
}
public JsonResult BindingDetail(FilterModelDetail model)
{
if (ModelState.IsValid)
{
//kasmus
Business.Infrastructure.FilterInfo filters;
List <expense_item> expenseItems;
List <car_expense> carExpenses;
DateTime dtStart, dtEnd;
//algoritma
dtStart = new DateTime(model.StartDate.Year, model.StartDate.Month, model.StartDate.Day, 0, 0, 0);
dtEnd = new DateTime(model.EndDate.Year, model.EndDate.Month, model.EndDate.Day, 23, 59, 59);
//mengambil expense_item (pemasukan kendaraan)
filters = new Business.Infrastructure.FilterInfo
{
Filters = new List <Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo {
Field = "expense.date", Operator = "gte", Value = dtStart.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "expense.date", Operator = "lte", Value = dtEnd.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "category", Operator = "eq", Value = ExpenseItemCategory.VEHICLE.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "expense.rent.id_car", Operator = "eq", Value = model.IdCar.ToString()
}
}
};
expenseItems = RepoExpense.FindAllItem(null, null, null, filters);
//mengambil carExpense (biaya kendaraan)
filters = new Business.Infrastructure.FilterInfo
{
Filters = new List <Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo {
Field = "expense_date", Operator = "gte", Value = dtStart.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "expense_date", Operator = "lte", Value = dtEnd.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "id_car", Operator = "eq", Value = model.IdCar.ToString()
}
}
};
carExpenses = RepoCarExpense.FindAll(null, null, null, filters);
return(Json(new CarDetailReportPresentationStub().MapList(expenseItems, carExpenses), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public string BindingToday()
{
//kamus
GridRequestParameters param = GridRequestParameters.Current;
Business.Infrastructure.FilterInfo filters;
filters = new Business.Infrastructure.FilterInfo
{
Filters = new List <Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo {
Field = "tanggal_awal", Operator = "lte", Value = DateTime.Now.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "tanggal_akhir", Operator = "gte", Value = DateTime.Now.ToString()
},
},
Logic = "and"
};
List <Whitelist> items = RepoWhitelist.FindAll(null, null, null, filters);
int total = items.Count();
return(new JavaScriptSerializer().Serialize(new { total = total, data = new WhitelistPresentationStub().MapList(items) }));
}
public string Binding(DailyFilterModel model)
{
//kamus
List <rent> rents;
List <driver> drivers;
List <expense_item> expenseItems;
Guid idOwner = (User as CustomPrincipal).IdOwner.Value;
DateTime dtStart, dtEnd;
Business.Infrastructure.FilterInfo filters;
//algoritma
//items = RepoExpense.GetDriverReport(idOwner, model.StartDate, model.EndDate);
dtStart = new DateTime(model.StartDate.Year, model.StartDate.Month, model.StartDate.Day, 0, 0, 0);
dtEnd = new DateTime(model.EndDate.Year, model.EndDate.Month, model.EndDate.Day, 23, 59, 59);
//mengambil data booking
rents = RepoRent.FindAll(idOwner, dtStart, dtEnd);
//mengambil data driver
filters = new Business.Infrastructure.FilterInfo
{
Filters = new List <Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = idOwner.ToString()
},
}
};
drivers = RepoDriver.FindAll(null, null, null, filters);
//mengambil data epneseItem untuk pemasukan
filters = new Business.Infrastructure.FilterInfo
{
Filters = new List <Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo {
Field = "expense.date", Operator = "gte", Value = dtStart.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "expense.date", Operator = "lte", Value = dtEnd.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "category", Operator = "eq", Value = ExpenseItemCategory.DRIVER.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "expense.rent.id_owner", Operator = "eq", Value = idOwner.ToString()
},
}
};
expenseItems = RepoExpense.FindAllItem(null, null, null, filters);
return(new JavaScriptSerializer().Serialize(new SummaryStub().MapList(drivers, rents, expenseItems)));
}
private void FillModelOptions(CarExpenseFormStub model)
{
Guid?idOwner = (User as CustomPrincipal).IdOwner;
Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = idOwner.ToString()
};
List <car> cars = RepoCar.FindAll(null, null, null, filters);
model.FillCarOptions(cars);
}
public string Binding()
{
//kamus
GridRequestParameters param = GridRequestParameters.Current;
Business.Infrastructure.FilterInfo filters = param.Filters;
List <car_model> items = RepoCarModel.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
int total = RepoCarModel.Count(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = new CarModelPresentationStub().MapList(items) }));
}
public string BindingRent(Guid id, string action)
{
GridRequestParameters param = GridRequestParameters.Current;
Business.Infrastructure.FilterInfo filters = param.Filters;
Guid? idOwner = (User as CustomPrincipal).IdOwner;
List <rent> listRent = new List <rent>();
List <expense> listExpense = new List <expense>();
List <BookingPresentationStub> result = new List <BookingPresentationStub>();
Business.Infrastructure.FilterInfo filtersExpense = new Business.Infrastructure.FilterInfo {
Filters = new List <Business.Infrastructure.FilterInfo>(), Logic = "and"
};
int total = 0;
filtersExpense.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "rent.id_owner", Operator = "eq", Value = idOwner.ToString()
});
listExpense = RepoExpense.FindAll().Where(n => n.rent.id_owner == idOwner).ToList();
if (idOwner.HasValue)
{
GridRequestParameters paramRent = new GridRequestParameters();
paramRent = GridRequestParameters.Current;
Business.Infrastructure.FilterInfo rentFilters = paramRent.Filters;
AddOwnerFilterRent(rentFilters, idOwner.Value);
listRent = RepoRent.FindAll(paramRent.Skip, paramRent.Take, (paramRent.Sortings != null ? paramRent.Sortings.ToList() : null), paramRent.Filters);
//menghapus booking yang sudah memiliki invoice
rent idRent;
foreach (expense r in listExpense)
{
idRent = listRent.Where(n => n.id == r.id_rent).FirstOrDefault();
if (idRent != null)
{
listRent.Remove(idRent);
if (action == "Edit" && idRent.id == id)
{
listRent.Add(idRent);
}
}
}
total = listRent.Count();
}
result = new BookingPresentationStub().MapList(listRent);
return(new JavaScriptSerializer().Serialize(new { total = total, data = result }));
}
//[HttpPost]
//public JsonResult Delete(Guid id)
//{
// string template = "";
// ResponseModel response = new ResponseModel(true);
// car_package dbItem = RepoCarPackage.FindByPk(id);
// RepoCarPackage.Delete(dbItem);
// return Json(response);
//}
//public string BindingCarBrand()
//{
// Guid idOwner = (User as CustomPrincipal).IdOwner.Value;
// List<car_brand> items = new List<car_brand>();
// items = RepoCar.FindAll().Where(x => x.id_owner == idOwner).Select(x => x.car_model.car_brand).Distinct().ToList();
// int total = items.Count();
// return new JavaScriptSerializer().Serialize(new { total = total, data = new CarBrandPresentationStub().MapList(items).OrderBy(x => x.Name) });
//}
//public string BindingCarModel(Guid? id)
//{
// GridRequestParameters param = GridRequestParameters.Current;
// Guid idOwner = (User as CustomPrincipal).IdOwner.Value;
// //Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo { Filters = new List<Business.Infrastructure.FilterInfo>(), Logic = "and" };
// //filters.Filters.Add(new Business.Infrastructure.FilterInfo { Field = "id_owner", Operator = "eq", Value = idOwner.ToString() });
// //List<car> cars = RepoCar.FindAll(null, null, null, filters);
// //List<car> cars = RepoCar.FindAll().Where(x => x.id_owner == idOwner).ToList();
// ///var n dari car_model sedangkan x dari cars
// //List<car_model> items = RepoCarModel.FindAll().Where(n=>cars.Any(x=>x.id_car_model == n.id) && n.id_car_brand == id).ToList();
// List<car_model> items = RepoCar.FindAll().Where(n => n.car_model.car_brand.id == id && n.id_owner == idOwner).Select(x => x.car_model).Distinct().ToList();
// int total = items.Count();
// return new JavaScriptSerializer().Serialize(new { total = total, data = new CarModelPresentationStub().MapList(items).OrderBy(x => x.Name) });
//}
#region private
private void FillModelOptions(CarPackageFormStub model)
{
Guid?idOwner = (User as CustomPrincipal).IdOwner;
Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = idOwner.ToString()
};
List <car> cars = RepoCar.FindAll(null, null, null, filters);
List <car_model> models = cars.Select(m => m.car_model).Distinct().ToList();
List <car_brand> brands = models.Select(m => m.car_brand).Distinct().ToList();
model.SetCarBrandOptions(brands);
model.SetCarModelOptions(models);
}
public ActionResult Index()
{
//kamus
Guid? idOwner = (User as CustomPrincipal).IdOwner;
List <car> dbCarList = new List <car>();
List <CarPresentationStub> pCarList = new List <CarPresentationStub>();
Dictionary <string, string> jsonCarListByModel = new Dictionary <string, string>();
List <string> carModels;
List <GenericModel> gCarList;
Boolean active = true;
Business.Infrastructure.FilterInfo filters;
//algoritma
filters = new Business.Infrastructure.FilterInfo
{
Filters = new List <Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = idOwner.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "is_active", Operator = "eq", Value = active.ToString()
},
},
Logic = "and"
};
dbCarList = RepoCar.FindAll(null, null, null, filters);
pCarList = new CarPresentationStub().MapList(dbCarList);
carModels = pCarList.Select(m => m.CarModelName).Distinct().ToList();
foreach (string cm in carModels)
{
gCarList = new List <GenericModel>();
foreach (CarPresentationStub single in pCarList.Where(n => n.CarModelName == cm).ToList())
{
gCarList.Add(new GenericModel {
text = single.LicensePlate, value = single.LicensePlate
});
}
jsonCarListByModel.Add(cm.Replace(" ", "_"), new JavaScriptSerializer().Serialize(gCarList));
}
//viewbag
ViewBag.JsonCarListByModel = jsonCarListByModel;
return(View(new DailyFilterModel()));
}
public string BindingItem()
{
//kamus
GridRequestParameters param = GridRequestParameters.Current;
Business.Infrastructure.FilterInfo filters = param.Filters;
int total = 0;
//expense expenseSet = new expense();
//List<expense_item> items = RepoExpense.FindAllItem().Where(x => x.id_expense == expenseSet.id).ToList();
List <expense_item> items = new List <expense_item>();
items = RepoExpense.FindAllItem(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
total = RepoExpense.CountItem(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = new CostPresentationStub().MapListItem(items) }));
}
public string Binding()
{
//kamus
GridRequestParameters param = GridRequestParameters.Current;
Business.Infrastructure.FilterInfo filters = param.Filters;
List <rent> items;
List <RentPresentationStub> result = new List <RentPresentationStub>();
int total;
//algoritma
items = RepoRent.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), filters);
total = RepoRent.Count(param.Filters);
result = new RentPresentationStub().MapList(items);
return(new JavaScriptSerializer().Serialize(new { total = total, data = result }));
}
private void FillModelOptions(BookingFormStub model)
{
Guid idOwner = (User as CustomPrincipal).IdOwner.Value;
List <car_package> result = new List <car_package>();
Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo {
Filters = new List <Business.Infrastructure.FilterInfo>(), Logic = "and"
};
filters.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = idOwner.ToString()
});
filters.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "is_active", Operator = "eq", Value = true.ToString()
});
result = RepoCarPackage.FindAll(null, null, null, filters);
model.SetCarPackageOptions(result);
}
private void AddActiveFilter(Business.Infrastructure.FilterInfo filters, Boolean active)
{
if (filters == null)
{
filters = new Business.Infrastructure.FilterInfo {
Filters = new List <Business.Infrastructure.FilterInfo>(), Logic = "and"
}
}
;
if (filters.Filters == null)
{
filters.Filters = new List <Business.Infrastructure.FilterInfo>();
}
filters.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "is_active", Operator = "eq", Value = active.ToString()
});
}
/// <summary>
/// start: ... - ... - 01
/// end: ... - ... - 30/31
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
private DailyMonthlyFilterModel ParseFilterInfo(Business.Infrastructure.FilterInfo filter)
{
DailyMonthlyFilterModel fm = new DailyMonthlyFilterModel();
Business.Infrastructure.FilterInfo single;
if (filter != null && filter.Filters != null)
{
single = filter.Filters.Where(m => m.Field == "ReportType").FirstOrDefault();
if (single != null)
{
fm.ReportType = (ReportType)Enum.Parse(typeof(ReportType), single.Value);
}
single = filter.Filters.Where(m => m.Field == "StartDate").FirstOrDefault();
if (single != null)
{
fm.StartDate = DateTime.Parse(single.Value);
if (fm.ReportType == ReportType.MONTHLY)
{
fm.StartDate = new DateTime(fm.StartDate.Year, fm.StartDate.Month, 1);
}
}
single = filter.Filters.Where(m => m.Field == "EndDate").FirstOrDefault();
if (single != null)
{
fm.EndDate = DateTime.Parse(single.Value);
if (fm.ReportType == ReportType.MONTHLY)
{
fm.EndDate = fm.EndDate.AddMonths(1);
fm.EndDate = new DateTime(fm.EndDate.Year, fm.EndDate.Month, 1);
fm.EndDate = fm.EndDate.AddDays(-1);
}
}
}
return(fm);
}
public string Binding()
{
//kamus
GridRequestParameters param = GridRequestParameters.Current;
Business.Infrastructure.FilterInfo filters = param.Filters;
Guid? idOwner = (User as CustomPrincipal).IdOwner;
int total = 0;
List <invoice> items = new List <invoice>();
if (idOwner.HasValue)
{
AddOwnerFilter(filters, idOwner.Value);
items = RepoInvoice.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
total = RepoInvoice.Count(param.Filters);
}
return(new JavaScriptSerializer().Serialize(new { total = total, data = new InvoicePresentationStub().MapList(items) }));
}
public HttpResponseMessage Find([FromBody] GridRequestParameters param)
{
//kamus
HttpStatusCode httpStatus = HttpStatusCode.OK;
string responseMessage = null;
List <rent> listRent = new List <rent>();
IEnumerable <string> headerValues;
Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo {
Filters = new List <Business.Infrastructure.FilterInfo>(), Logic = "and"
};
List <BookingPresentationStub> results;
//algoritma
if (Request.Headers.TryGetValues("Username", out headerValues))
{
//mengambil order berdasarkan status = 'finish'
filters.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "driver.username", Operator = "eq", Value = headerValues.FirstOrDefault()
});
filters.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "status", Operator = "eq", Value = RentStatus.FINISH.ToString()
});
//mengambil order finish sesuai param
listRent = RepoRent.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), filters);
}
else
{
httpStatus = HttpStatusCode.Forbidden;
}
//result
results = new BookingPresentationStub().MapList(listRent);
if (responseMessage != null)
{
HttpContext.Current.Response.AppendHeader("ResponseMessage", responseMessage);
}
return(Request.CreateResponse(httpStatus, results));
}
public ActionResult Create() //get
{
Guid?idOwner = (User as CustomPrincipal).IdOwner;
List <Business.Entities.rent> listRent = new List <rent>();
Business.Infrastructure.FilterInfo rentFilters = new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = idOwner.ToString()
};
if (idOwner.HasValue)
{
//listRent = RepoRent.FindAll().Where(x => x.id_owner == idOwner.Value).ToList();
//rentFilters.Filters.Add(new Business.Infrastructure.FilterInfo { Field = "id_owner", Operator = "eq", Value = idOwner.ToString() });
listRent = RepoRent.FindAll(null, null, null, rentFilters);
}
CostFormStub formStub = new CostFormStub(listRent);
formStub.Date = DateTime.Now;
return(View("Form", formStub));
}
public string BindingMap()
{
// Kamus
List <RentPositionPresentationStub> result = new List <RentPositionPresentationStub>();
List <rent_position> rentPositionList = new List <rent_position>();
List <rent> rentList;
CustomPrincipal user = User as CustomPrincipal;
Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo {
Filters = new List <Business.Infrastructure.FilterInfo>(), Logic = "and"
};
rent_position rentPosition;
// algoritma
//ambil rent yang GO untuk user login
filters.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "status", Operator = "eq", Value = RentStatus.GO.ToString()
});
filters.Filters.Add(new Business.Infrastructure.FilterInfo {
Field = "id_owner", Operator = "eq", Value = user.IdOwner.Value.ToString()
});
rentList = RepoRent.FindAll(null, null, null, filters);
//ambil rent position terakhir dari setiap rent
foreach (rent r in rentList)
{
rentPosition = r.rent_position.OrderByDescending(m => m.created_time).FirstOrDefault();
//dimasukin ke rentPosition
if (rentPosition != null)
{
rentPositionList.Add(rentPosition);
}
}
//mengisi RentPositionPresentationStub list
result = new RentPositionPresentationStub().Map(rentPositionList);
return(new JavaScriptSerializer().Serialize(result));
}
public ActionResult Edit(DriverFormStub model)
{
//bool isNameExist = RepoKompetitor.Find().Where(p => p.name == model.Name && p.id != model.Id).Count() > 0;
Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo {
Filters = new List <Business.Infrastructure.FilterInfo>(), Logic = "and"
};
List <owner_user> ownerUser;
List <driver> ownerDriverList; //driver punya owner
List <string> driverUsernameList; //username milik driver
if (ModelState.IsValid)
{
driver dbItem = RepoDriver.FindByPk(model.Id);
dbItem = model.GetDbObject(dbItem);
try
{
RepoDriver.Save(dbItem);
}
catch (Exception e)
{
model.FillOwnerOptions(RepoOwner.FindAll());
model.FillTypeOptions();
model.FillUsernameOptions(RepoOwner.FindAllUser());
return(View("Form", model));
}
//message
string template = HttpContext.GetGlobalResourceObject("MyGlobalMessage", "CreateSuccess").ToString();
this.SetMessage(model.Name, template);
return(RedirectToAction("Index"));
}
else
{
SetModelOptionsOnEdit(model);
return(View("Form", model));
}
}
public string Binding()
{
//kamus
DisplayFormatHelper dfh = new DisplayFormatHelper();
GridRequestParameters param = GridRequestParameters.Current;
List <ChartAttribute> result;
List <invoice> items = null;
DailyMonthlyFilterModel fm;
Business.Infrastructure.FilterInfo filters;
Guid idOwner = (Guid)(User as CustomPrincipal).IdOwner;
//algoritma
fm = ParseFilterInfo(param.Filters);
filters = new Business.Infrastructure.FilterInfo
{
Filters = new List <Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo {
Field = "rent.id_owner", Operator = "eq", Value = idOwner.ToString()
},
new Business.Infrastructure.FilterInfo {
Field = "invoice_date", Operator = "gte", Value = fm.StartDate.ToString(dfh.SqlDateFormat)
},
new Business.Infrastructure.FilterInfo {
Field = "invoice_date", Operator = "lte", Value = fm.EndDate.ToString(dfh.SqlDateFormat)
},
new Business.Infrastructure.FilterInfo {
Field = "status", Operator = "neq", Value = InvoiceStatus.CANCEL.ToString()
}
},
Logic = "and"
};
items = RepoInvoice.FindAll(null, null, null, filters);
result = GenerateReport(fm.ReportType, items, fm.StartDate, fm.EndDate);
return(new JavaScriptSerializer().Serialize(result));
}
public string BindingDriver()
{
//kamus
GridRequestParameters param = GridRequestParameters.Current;
Business.Infrastructure.FilterInfo filters = param.Filters;
Guid? idOwner = (User as CustomPrincipal).IdOwner;
List <driver> items;
List <DriverPresentationStub> result = new List <DriverPresentationStub>();
int total = 0;
//algoritma
if (idOwner.HasValue)
{
AddOwnerFilter(filters, idOwner.Value);
items = RepoDriver.FindAll(null, null, null, filters);
total = items.Count();
result = new DriverPresentationStub().MapList(items).OrderBy(x => x.Name).ToList();
}
return(new JavaScriptSerializer().Serialize(new { total = total, data = result }));
}
public int Test1()
{
//Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo
//{
// Field = "application",
// Operator = "eq",
// Value = "Test"
//};
//Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo
//{
// Filters = new List<Business.Infrastructure.FilterInfo>
// {
// new Business.Infrastructure.FilterInfo { Field = "application", Operator = "eq", Value = "Test"},
// new Business.Infrastructure.FilterInfo { Field = "user", Operator = "eq", Value = "chandra"}
// },
// Logic = "or"
//};
//Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo
//{
// Filters = new List<Business.Infrastructure.FilterInfo>
// {
// new Business.Infrastructure.FilterInfo
// {
// Filters = new List<Business.Infrastructure.FilterInfo>
// {
// new Business.Infrastructure.FilterInfo { Field = "user", Operator = "eq", Value = "chandra"},
// new Business.Infrastructure.FilterInfo { Field = "user", Operator = "eq", Value = "yosef"}
// },
// Logic = "or"
// },
// new Business.Infrastructure.FilterInfo { Field = "application", Operator = "eq", Value = "Minibank"}
// },
// Logic = "and"
//};
//Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo
//{
// Filters = new List<Business.Infrastructure.FilterInfo>
// {
// new Business.Infrastructure.FilterInfo
// {
// Filters = new List<Business.Infrastructure.FilterInfo>
// {
// new Business.Infrastructure.FilterInfo { Field = "user", Operator = "eq", Value = "chandra"},
// new Business.Infrastructure.FilterInfo { Field = "user", Operator = "eq", Value = "yosef"}
// },
// Logic = "or"
// },
// new Business.Infrastructure.FilterInfo
// {
// Filters = new List<Business.Infrastructure.FilterInfo>
// {
// new Business.Infrastructure.FilterInfo { Field = "application", Operator = "eq", Value = "Test"},
// new Business.Infrastructure.FilterInfo { Field = "application", Operator = "eq", Value = "Test1"}
// },
// Logic = "or"
// }
// },
// Logic = "and"
//};
Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo
{
Filters = new List<Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo
{
Filters = new List<Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo { Field = "user", Operator = "eq", Value = "chandra"},
new Business.Infrastructure.FilterInfo { Field = "application", Operator = "eq", Value = "Test"}
},
Logic = "and"
},
new Business.Infrastructure.FilterInfo
{
Filters = new List<Business.Infrastructure.FilterInfo>
{
new Business.Infrastructure.FilterInfo { Field = "user", Operator = "eq", Value = "yosef"},
new Business.Infrastructure.FilterInfo { Field = "application", Operator = "eq", Value = "Minibank"}
},
Logic = "and"
}
},
Logic = "or"
};
List<log> l = RepoLog.FindAll(null, null, null, filters);
return l.Count();
}
