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