public string Binding()
{
GridRequestParameters param = GridRequestParameters.Current;
List <Context.JnsTols> items = RepoJnsTol.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
List <JnsTol> ListModel = new List <JnsTol>();
foreach (Context.JnsTols item in items)
{
ListModel.Add(new JnsTol(item));
}
int total = RepoJnsTol.Count(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = ListModel.Select(d => new {
Id = d.Id,
NamaTol = d.NamaTol,
gol1 = d.GolonganTol1,
gol2 = d.GolonganTol2,
gol3 = d.GolonganTol3,
gol4 = d.GolonganTol4,
Keterangan = d.Keterangan
}) }));
}
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(string user_types)
{
GridRequestParameters param = GridRequestParameters.Current;
Context.User user = RepoUser.FindByPK(UserPrincipal.id);
List <SolarInap> ListModel = new List <SolarInap>();
List <Context.SolarInap> items = RepoSolarInap.FindAll(user_types);
foreach (Context.SolarInap item in items)
{
if (item.SalesOrderKontrakListSOId.HasValue)
{
var soKontrak = item.SO.SalesOrderKontrak.SalesOrderKontrakListSo.Where(d => d.Id == item.SalesOrderKontrakListSOId).FirstOrDefault();
ListModel.Add(new SolarInap(item, soKontrak));
}
else
{
ListModel.Add(new SolarInap(item));
}
}
int total = RepoSolarInap.CountTrans(user_types, param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = ListModel }));
}
public string GetRuteByCustomer(int idCust, DateTime TanggalMasuk)
{
GridRequestParameters param = GridRequestParameters.Current;
if (param.Filters.Filters == null)
{
param.Filters.Filters = new List <tms_mka_v2.Infrastructure.FilterInfo>();
}
param.Filters.Filters.Add(new tms_mka_v2.Infrastructure.FilterInfo
{
Field = "IdCust",
Operator = "eq",
Value = idCust.ToString(),
});
List <Rute> listRute = new List <Rute>();
List <Context.DaftarHargaKonsolidasi> dho = RepoDHKonsolidasi.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
List <DaftarHargaKonsolidasiItem> model = new List <DaftarHargaKonsolidasiItem>();
Context.DaftarHargaKonsolidasi dhoitem = dho.Where(d => TanggalMasuk >= d.PeriodStart && TanggalMasuk <= d.PeriodEnd).FirstOrDefault();
foreach (Context.DaftarHargaKonsolidasiItem item in dhoitem.DaftarHargaKonsolidasiItem.ToList())
{
model.Add(new DaftarHargaKonsolidasiItem(item));
}
return(new JavaScriptSerializer().Serialize(new { data = model }));
}
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 string BindingSalesOrder()
{
GridRequestParameters param = GridRequestParameters.Current;
List <Context.SalesOrder> items = RepoSalesOrder.FindAllKlaim();
List <ListOrder> ListModel = new List <ListOrder>();
foreach (Context.SalesOrder item in items)
{
if (item.SalesOrderKontrakId.HasValue)
{
if (item.SalesOrderKontrak.SalesOrderKontrakListSo.Any(p => p.IsProses))
{
foreach (var itemKontrak in item.SalesOrderKontrak.SalesOrderKontrakListSo.Where(s => s.Status == "dispatched" || s.Status == "settlement").GroupBy(d => new { d.IdDataTruck, d.Driver1Id, d.Status, d.Urutan }).Select(grp => grp.ToList()))
{
foreach (var itemKontrakPerOrder in itemKontrak.OrderBy(t => t.MuatDate).ToList())
{
ListModel.Add(new ListOrder(item, itemKontrakPerOrder));
}
}
}
else
{
ListModel.Add(new ListOrder(item));
}
}
else
{
ListModel.Add(new ListOrder(item));
}
}
return(new JavaScriptSerializer().Serialize(new { total = ListModel.Count, data = ListModel }));
}
public string BindingComboType(string type)
{
GridRequestParameters param = GridRequestParameters.Current;
param.Take = 5;
if (param.Filters.Filters == null)
{
param.Filters.Filters = new List <tms_mka_v2.Infrastructure.FilterInfo>();
}
param.Filters.Filters.Add(new tms_mka_v2.Infrastructure.FilterInfo
{
Field = "Type",
Operator = "eq",
Value = type,
});
List <Context.Location> dbitems = RepoLocation.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
//GridRequestParameters param = GridRequestParameters.Current;
//string str = param.Filters.Filters == null ? "" : param.Filters.Filters[0].Value;
//List<Context.Location> items = new List<Context.Location>();
//if (str != "")
// items = RepoLocation.FindAll().Where(d => d.Type == type && d.Nama.ToLower().Contains(str)).ToList();
List <Location> ListModel = new List <Location>();
foreach (Context.Location item in dbitems)
{
ListModel.Add(new Location(item));
}
return(new JavaScriptSerializer().Serialize(ListModel));
}
public string BindingComboKotaKec()
{
GridRequestParameters param = GridRequestParameters.Current;
param.Take = 50;
if (param.Filters.Filters == null)
{
param.Filters.Filters = new List <tms_mka_v2.Infrastructure.FilterInfo>();
param.Filters.Filters.Add(new tms_mka_v2.Infrastructure.FilterInfo
{
Field = "Type",
Operator = "eq",
Value = "Kab/Kota",
});
param.Filters.Filters.Add(new tms_mka_v2.Infrastructure.FilterInfo
{
Field = "Type",
Operator = "eq",
Value = "Kecamatan",
});
}
List <Context.Location> items = RepoLocation.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
//.Where(d => d.Nama.ToLower().Contains(str) && (d.Type == "Kab/Kota" || d.Type == "Kecamatan")).ToList();
List <Location> ListModel = new List <Location>();
foreach (Context.Location item in items)
{
ListModel.Add(new Location(item));
}
return(new JavaScriptSerializer().Serialize(ListModel));
}
public string Binding()
{
GridRequestParameters param = GridRequestParameters.Current;
//List<Context.SettlementReguler> items = RepoSettlementReg.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
List <Context.SettlementReguler> items = RepoSettlementReg.FindAll();
List <SettlementRegIndex> ListModel = new List <SettlementRegIndex>();
foreach (Context.SettlementReguler item in items)
{
if (item.SalesOrder.SalesOrderKontrakId.HasValue)
{
List <int> ListIdDumy = item.LisSoKontrak.Split(new string[] { "." }, StringSplitOptions.None).ToList().Select(int.Parse).ToList();
List <Context.SalesOrderKontrakListSo> dbsoDummy = item.SalesOrder.SalesOrderKontrak.SalesOrderKontrakListSo.Where(d => ListIdDumy.Contains(d.Id)).ToList();
ListModel.Add(new SettlementRegIndex(item, dbsoDummy));
}
else
{
ListModel.Add(new SettlementRegIndex(item));
}
}
//int total = RepoSettlementReg.Count(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = ListModel.Count(), data = ListModel }));
}
public string Binding()
{
GridRequestParameters param = GridRequestParameters.Current;
List <Context.SettlementBatal> items = RepoSettlementBatal.FindAll();
List <SettlementBatalIndex> ListModel = new List <SettlementBatalIndex>();
foreach (Context.SettlementBatal item in items)
{
if (item.IdSoKontrak != "" && item.IdSoKontrak != null)
{
var data = item.SalesOrder.SalesOrderKontrak.SalesOrderKontrakListSo.Where(p => p.IsBatalTruck && p.Id == int.Parse(item.IdSoKontrak)).ToList();
foreach (var itemGroup in data.ToList())
{
ListModel.Add(new SettlementBatalIndex(item, itemGroup));
}
}
else
{
ListModel.Add(new SettlementBatalIndex(item));
}
}
return(new JavaScriptSerializer().Serialize(new { total = ListModel.Count(), data = ListModel }));
}
public string Binding()
{
GridRequestParameters param = GridRequestParameters.Current;
List <currency> items = RepoCurrency.Find(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), (param.Filters != null ? param.Filters : null));
int total = RepoCurrency.Count(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = new CurrencyPresentationStub().MapList(items) }));
}
public string BindingCarModel()
{
GridRequestParameters param = GridRequestParameters.Current;
List <car_model> items = RepoCarModel.FindAll(null, null, null, (param.Filters != null ? param.Filters : null));
int total = items.Count();
return(new JavaScriptSerializer().Serialize(new { total = total, data = new CarModelPresentationStub().MapList(items).OrderBy(x => x.Name) }));
}
public string Binding()
{
//kamus
GridRequestParameters param = GridRequestParameters.Current;
List <owner> items = RepoOwner.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
int total = RepoOwner.Count(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = new OwnerPresentationStub().MapList(items) }));
}
public string BindingDetail()
{
//kamus
GridRequestParameters param = GridRequestParameters.Current;
List <expense_item> items = RepoExpense.FindAllItem(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
int total = RepoExpense.CountItem(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = new DetailStub().MapList(items) }));
}
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 }));
}
//adanya idCar bakal bikin aneh fungsi kalau dipanggil untuk kendo grid
public string Binding(Guid?idCar)
{
//kamus
GridRequestParameters param = GridRequestParameters.Current;
car car;
Business.Infrastructure.FilterInfo filters;
Guid?idCarModel;
//algoritma
if (param.Filters.Filters == null)
{
param.Filters.Filters = new List <Business.Infrastructure.FilterInfo>();
param.Filters.Logic = "and";
}
param.Filters.Filters.Add(new Business.Infrastructure.FilterInfo
{
Field = "id_owner",
Operator = "eq",
Value = GetOwnerId().ToString()
});
List <car> items = RepoCar.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
int total = RepoCar.Count(param.Filters);
if (idCar != null)
{
car = RepoCar.FindByPk(idCar.Value);
if (car != null)
{
filters = param.Filters.Filters.Where(m => m.Field == "id_car_model").FirstOrDefault();
if (filters == null) //menambahkan mobil jika car_model sama dengan param
{
items.Add(car);
++total;
}
else
{
idCarModel = Guid.Parse(filters.Value);
if (car.id_car_model == idCarModel)
{
items.Add(car);
++total;
}
}
}
}
return(new JavaScriptSerializer().Serialize(new { total = total, data = new CarPresentationStub().MapList(items) }));
}
public string Binding()
{
GridRequestParameters param = GridRequestParameters.Current;
List <Context.BAP> items = RepoBAP.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
List <BAP> ListModel = new List <BAP>();
foreach (Context.BAP item in items)
{
ListModel.Add(new BAP(item));
}
return(new JavaScriptSerializer().Serialize(new { total = ListModel.Count, data = ListModel }));
}
public string BindingPerCustomer(int CustId)
{
List <Rute> listRute = new List <Rute>();
GridRequestParameters param = GridRequestParameters.Current;
List <Context.Rute> rute = RepoRute.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters).Where(r => r.CustomerId == CustId || r.CustomerId.HasValue == false).ToList();
foreach (Context.Rute item in rute)
{
listRute.Add(new Rute(item));
}
int total = listRute.Count();
return(new JavaScriptSerializer().Serialize(new { total = total, data = listRute }));
}
public string BindingKet(int id)
{
GridRequestParameters param = GridRequestParameters.Current;
List <Context.Spk> items = RepoSpk.FindByWorkshop(id);
List <Spk> ListModel = new List <Spk>();
foreach (Context.Spk item in items)
{
ListModel.Add(new Spk(item));
}
int total = RepoSpk.Count(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = ListModel }));
}
public string Binding()
{
GridRequestParameters param = GridRequestParameters.Current;
List <Context.SalesOrder> items = RepoSalesOrder.FindAllKontrak().Where(d => d.Status == "save planning" || d.Status == "draft konfirmasi").ToList();
List <SalesOrderKontrak> ListModel = new List <SalesOrderKontrak>();
foreach (Context.SalesOrder item in items)
{
ListModel.Add(new SalesOrderKontrak(item));
}
int total = RepoSalesOrder.CountKontrak(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = ListModel }));
}
public string Binding()
{
GridRequestParameters param = GridRequestParameters.Current;
List <Context.SalesOrder> items = RepoSalesOrder.FindAllProsesKonsolidasi();
List <SalesOrderProsesKonsolidasi> ListModel = new List <SalesOrderProsesKonsolidasi>();
foreach (Context.SalesOrder item in items)
{
ListModel.Add(new SalesOrderProsesKonsolidasi(item));
}
int total = RepoSalesOrder.CountProsesKonsolidasi(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = ListModel }));
}
public string BindingDp(int id)
{
GridRequestParameters param = GridRequestParameters.Current;
Context.SalesOrder items = RepoSalesOrder.FindByOnCall(id);
return(new JavaScriptSerializer().Serialize(new { data = items.SalesOrderOncall.SalesOrderOncallDp.ToList().Select(d => new {
Id = d.Id,
Tanggal = d.Tanggal,
Penerima = d.Penerima,
IdRekening = d.RekeningId,
NoRekening = d.Rekenings.NoRekening,
Jenis = d.Jenis,
Jumlah = d.Jumlah
}) }));
}
public string Binding()
{
GridRequestParameters param = GridRequestParameters.Current;
Business.Infrastructure.FilterInfo filters = new Business.Infrastructure.FilterInfo
{
Field = "Action",
Operator = "startswith",
Value = "/Log"
};
//param.Filters = filters;
List <log> items = RepoLog.Find(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), (param.Filters != null ? param.Filters : null));
int total = RepoLog.Count(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = new LogPresentationStub().MapList(items) }));
}
public string Binding()
{
GridRequestParameters param = GridRequestParameters.Current;
List <Context.Auditrail> items = RepoAuditrail.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
List <Auditrail> ListModel = new List <Auditrail>();
foreach (Context.Auditrail item in items)
{
ListModel.Add(new Auditrail(item));
}
int total = RepoAuditrail.Count(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = ListModel }));
}
public string Binding()
{
GridRequestParameters param = GridRequestParameters.Current;
//List<Context.SalesOrder> items = RepoSalesOrder.FindAllKontrak(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
List <Context.SalesOrder> items = RepoSalesOrder.FindAllKontrak();
List <SalesOrderKontrak> ListModel = new List <SalesOrderKontrak>();
foreach (Context.SalesOrder item in items)
{
ListModel.Add(new SalesOrderKontrak(item));
}
int total = RepoSalesOrder.CountKontrak(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = ListModel }));
}
public string BindingDetail(int IdTruck, int idSo = 0)
{
GridRequestParameters param = GridRequestParameters.Current;
if (param.Filters.Filters == null)
{
param.Filters.Filters = new List <tms_mka_v2.Infrastructure.FilterInfo>();
param.Filters.Filters.Add(new tms_mka_v2.Infrastructure.FilterInfo
{
Field = "IdJenisTruck",
Operator = "eq",
Value = IdTruck.ToString(),
});
}
List <Context.PenetapanDriver> dbpenetapan = RepoPenetapan.FindAll();
List <Context.SalesOrder> dbso = RepoSalesOrder.FindAll().Where(s => s.Id != idSo).ToList();
List <DataTruckDetail> ListModel = new List <DataTruckDetail>();
List <Context.DataTruck> items = RepoDataTruck.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
foreach (Context.DataTruck item in items)
{
ListModel.Add(new DataTruckDetail(item, dbpenetapan, dbso));
}
GridRequestParameters param2 = GridRequestParameters.Current;
if (param2.Filters.Filters == null)
{
param2.Filters.Filters = new List <tms_mka_v2.Infrastructure.FilterInfo>();
param2.Filters.Filters.Add(new tms_mka_v2.Infrastructure.FilterInfo
{
Field = "IdJenisTruck",
Operator = "neq",
Value = IdTruck.ToString(),
});
}
items = RepoDataTruck.FindAll(param2.Skip, param2.Take, (param2.Sortings != null ? param2.Sortings.ToList() : null), param2.Filters);
foreach (Context.DataTruck item in items)
{
ListModel.Add(new DataTruckDetail(item, dbpenetapan, dbso));
}
return(new JavaScriptSerializer().Serialize(new { total = ListModel.Count(), data = ListModel }));
}
public string Binding()
{
//kamus
GridRequestParameters param = GridRequestParameters.Current;
if (param.Filters.Filters == null)
{
param.Filters.Filters = new List <Business.Infrastructure.FilterInfo>();
param.Filters.Logic = "and";
}
List <owner> items = RepoOwner.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
int total = RepoOwner.Count(param.Filters);
return(new JavaScriptSerializer().Serialize(new { total = total, data = new ProfilePresentationStub().MapList(items) }));
}
public string BindingCbo()
{
GridRequestParameters param = GridRequestParameters.Current;
List <Context.MasterProduct> items = RepoProduct.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
List <Product> ListModel = new List <Product>();
foreach (Context.MasterProduct item in items)
{
ListModel.Add(new Product(item));
}
int total = RepoProduct.Count(param.Filters);
return(new JavaScriptSerializer().Serialize(ListModel));
}
public string BindingCombo(int id = 0)
{
GridRequestParameters param = GridRequestParameters.Current;
param.Take = 50;
List <Context.Location> items = RepoLocation.FindAll(param.Skip, param.Take, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters);
List <Location> ListModel = new List <Location>();
foreach (Context.Location item in items)
{
ListModel.Add(new Location(item));
}
return(new JavaScriptSerializer().Serialize(ListModel));
}
