public ActionResult VendorSelectAll([DataSourceRequest] DataSourceRequest request) { BL.Vendors blVendors = new BL.Vendors(); List <Vendor> model = blVendors.SelectAll(); return(Json(model.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
public ActionResult CreateRating([DataSourceRequest]DataSourceRequest request, IEnumerable<AdministrationRatingsViewModel> models) { var result = new List<AdministrationRatingsViewModel>(); if (this.ModelState.IsValid && models != null) { foreach (var model in models) { var ratingUser = this.users.GetByUsername(model.UserName).FirstOrDefault(); var petToUpdate = this.pets.GetByIntId(model.PetId).FirstOrDefault(); if (ratingUser != null && petToUpdate != null) { var newRating = new Rating { RatingValue = model.RatingValue, PetId = model.PetId, Author = ratingUser }; this.ratings.Add(newRating); petToUpdate.CurrentRating = petToUpdate.Ratings.Average(r => r.RatingValue); this.pets.Update(petToUpdate); model.CreatedOn = newRating.CreatedOn; model.Id = newRating.Id; result.Add(model); } } return this.Json(result.ToDataSourceResult(request), JsonRequestBehavior.AllowGet); } return null; }
public IActionResult GetAtividade([DataSourceRequest] DataSourceRequest request) { List <AtividadeViewModel> atividadeViewModels = new List <AtividadeViewModel>(); var atividadeServ = serviceProvider.GetServices(typeof(Microsoft.Extensions.Hosting.IHostedService)); foreach (var itemTask in atividadeServ) { if (itemTask is IAtividade atividade) { atividadeViewModels.Add(new AtividadeViewModel() { DescricaoAtividade = atividade.GetDescricaoAtividade(), NomeAtividade = atividade.GetNomeAtividade(), Status = atividade.GetStatus(), ProximaExecucao = atividade.GetProximaExecucao().ToLocalTime(), UltimaExecucao = atividade.GetUltimaExecucao(), UltimoTempo = new DateTime(atividade.GetUltimoTempo().Ticks) }); } } DataSourceResult result = atividadeViewModels.ToDataSourceResult(request); return(Json(result)); }
public JsonResult GetEmployee([DataSourceRequest] DataSourceRequest request, string perfil, string solicitud) { try { var listPeriodoNomina = new List <SolicitudEmpleadosxPerfilSel_Result>(); if (!string.IsNullOrEmpty(perfil)) { using (ASNContext context = new ASNContext()) { context.Database.CommandTimeout = int.Parse(ConfigurationManager.AppSettings["TimeOutMinutes"]); listPeriodoNomina = context.SolicitudEmpleadosxPerfilSel(0, int.Parse(solicitud)).ToList(); DataSourceResult ok = listPeriodoNomina.ToDataSourceResult(request); return(Json(ok)); } } else { return(Json("")); } } catch (Exception ex) { MyCustomIdentity usuario = (MyCustomIdentity)User.Identity; LogError log = new LogError(); log.RecordError(ex, usuario.UserInfo.Ident.Value); return(Json("")); } }
public JsonResult ReadH([DataSourceRequest] DataSourceRequest request) { List <HorseOdd> byRaceId = SessionService.DbContainer.Resolve <HorseODDDataManager>().GetByRaceId(SessionService.CurrentRaceId); List <HorseOddModel> horseOddModels = byRaceId.Select(Mapper.Map <HorseOdd, HorseOddModel>).ToList(); return(Json(horseOddModels.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
public ActionResult GetDataListAjax([DataSourceRequest] DataSourceRequest request, int id = 0) { IEnumerable <Cats.Models.RegionalPSNPPlanDetail> filledData = new List <RegionalPSNPPlanDetail>(); IEnumerable <PSNPPlanDetailView> allFDPData = new List <PSNPPlanDetailView>(); RegionalPSNPPlan plan = _regionalPSNPPlanService.FindById(id); if (plan != null) { IEnumerable <AdminUnit> allWoredas = _adminUnitService.FindBy(m => m.AdminUnitTypeID == 4); filledData = plan.RegionalPSNPPlanDetails; allFDPData = from woreda in allWoredas join plandetail in filledData on woreda.AdminUnitID equals plandetail.PlanedWoredaID select new PSNPPlanDetailView { //FDPID = fdp.FDPID, //FDPName = fdp.Name, WoredaID = woreda.AdminUnitID, WoredaName = woreda.Name, ZoneID = woreda.AdminUnit2.AdminUnitID, ZoneName = woreda.AdminUnit2.Name, RegionName = woreda.AdminUnit2.AdminUnit2.Name, RegionalPSNPPlanDetailID = plandetail.RegionalPSNPPlanDetailID, BeneficiaryCount = plandetail.BeneficiaryCount, RegionalPSNPPlanID = plan.RegionalPSNPPlanID, FoodRatio = plandetail.FoodRatio, CashRatio = plandetail.CashRatio, StartingMonthName = RequestHelper.MonthName(plandetail.StartingMonth) }; } return(Json(allFDPData.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> GetTaxes([DataSourceRequest] DataSourceRequest request) { List <Tax> _Taxes = new List <Tax>(); try { string baseadress = config.Value.urlbase; HttpClient _client = new HttpClient(); _client.DefaultRequestHeaders.Add("Authorization", "Bearer " + HttpContext.Session.GetString("token")); var result = await _client.GetAsync(baseadress + "api/Tax/GetTax"); string valorrespuesta = ""; if (result.IsSuccessStatusCode) { valorrespuesta = await(result.Content.ReadAsStringAsync()); _Taxes = JsonConvert.DeserializeObject <List <Tax> >(valorrespuesta); } } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); throw ex; } return(Json(_Taxes.ToDataSourceResult(request))); }
public ActionResult CreatePet([DataSourceRequest]DataSourceRequest request, IEnumerable<AdministrationPetsViewModel> models) { var result = new List<AdministrationPetsViewModel>(); if (this.ModelState.IsValid && models != null) { foreach (var model in models) { var owner = this.users.GetByUsername(model.Owner).FirstOrDefault(); var breed = this.breeds.GetById(model.BreedId).FirstOrDefault(); var location = this.locations.GetById(model.LocationId).FirstOrDefault(); var status = this.petStatuses.GetById(model.PetStatusId).FirstOrDefault(); if (owner != null && breed != null && location != null && status != null) { var newPet = new Pet { Name = model.Name, Description = model.Description, Breed = breed, Owner = owner, Location = location, PetStatus = status, ImageUrl = model.ImageUrl, PetGender = model.PetGenderType }; this.pets.Add(newPet); model.CreatedOn = newPet.CreatedOn; model.Id = newPet.Id; result.Add(model); } } return this.Json(result.ToDataSourceResult(request), JsonRequestBehavior.AllowGet); } return null; }
public JsonResult ReadRT([DataSourceRequest] DataSourceRequest request) { var raceType = SessionService.DbContainer.Resolve <RaceTypeDataManager>(); List <DTORaceType> raceTypes = raceType.GetAllDto(Convert.ToInt32(SessionService.SearchModel.Country)).Select(Mapper.Map <DTORaceType2, DTORaceType>).ToList(); return(Json(raceTypes.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
public ActionResult ImportFromExcel_Position_read([DataSourceRequest] DataSourceRequest request, string data) { dynamic newdata = Newtonsoft.Json.JsonConvert.DeserializeObject(data, typeof(ExpandoObject)); List <CRM_Position> list = new List <CRM_Position>(); return(Json(list.ToDataSourceResult(request))); }
public JsonResult GetClasses([DataSourceRequest] DataSourceRequest request) { List <Classes> classes = _ClassesBL.GetAllClass(); List <Classes> oList = new List <Classes>(); foreach (Classes classItem in classes) { oList.Add(new Classes() { ID = classItem.ID, Class_name = classItem.Class_name, Caption = classItem.Caption, Class_type = classItem.Class_type, SpatialRefrence = classItem.SpatialRefrence, Scale = classItem.Scale, FillColor = classItem.FillColor, StrokColor = classItem.StrokColor, Width = classItem.Width, StrokWidth = classItem.StrokWidth, UniqueField = classItem.UniqueField, HasFlow = classItem.HasFlow, SupervisorDateOfField = classItem.SupervisorDateOfField, SupervisorField = classItem.SupervisorField, DateOf = classItem.DateOf, TimeOf = classItem.TimeOf, UserId = classItem.UserId, RequieredPhoto = classItem.RequieredPhoto }); } return(Json(oList.ToDataSourceResult(request))); }
public ActionResult Client_Read([DataSourceRequest] DataSourceRequest request) { List <Client> Clients = clientFactory.GetClients(); DataSourceResult result = Clients.ToDataSourceResult(request); return(Json(result)); }
public ActionResult Sponsors_ReadById([DataSourceRequest] DataSourceRequest request) { var id = 1; var person = _Service.GetSponsorById(id); var persons = new List <Sponsor>(); persons.Add(person); DataSourceResult result = persons.ToDataSourceResult(request, sponsor => new SponsorViewModel { Id = sponsor.Id, PersonId = sponsor.PersonId, OrphanGenderChoice = sponsor.OrphanGenderChoice, OrphanCityChoiceId = sponsor.OrphanCityChoiceId, NumberOfOrphans = sponsor.NumberOfOrphans, SStartDate = sponsor.SStartDate, SEndDate = sponsor.SEndDate, LanguagePref = sponsor.LanguagePref, EthnicityId = sponsor.EthnicityId, ReferralType = sponsor.ReferralType, Notes = sponsor.Notes, LastUpdated = sponsor.LastUpdated, LastUpdatedBy = sponsor.LastUpdatedBy }); return(Json(result)); }
public ActionResult TrackingRequestByCustomer([DataSourceRequest] DataSourceRequest request, string CustomerID) { var data = new List <DC_RequestCredit>(); data = DC_RequestCredit.GetCustomerCreditRequestByCustomerID(CustomerID); return(Json(data.ToDataSourceResult(request))); }
public ActionResult FDP_Create([DataSourceRequest] DataSourceRequest request, FDPViewModel fdpViewModel , int? adminUnitID) { var result = new List<FDPViewModel>(); if (fdpViewModel != null && ModelState.IsValid && adminUnitID.HasValue) { try { //foreach (var viewModel in fdpViewModel) //{ if (CheckIfDFPExists((int)adminUnitID, fdpViewModel.Name)) { fdpViewModel.AdminUnitID = adminUnitID.Value; var fdp = FDPViewModelBinder.BindFDP(fdpViewModel); _fdpService.AddFDP(fdp); //result.Add(fdpViewModel); } // } } catch (Exception ex) { ModelState.AddModelError("Errors", @"Error: FDP not registered. All fields need to be filled."); } } return Json(result.ToDataSourceResult(request, ModelState)); }
public async Task <ActionResult> DistRead([DataSourceRequest] DataSourceRequest request, string strDist) { try { var distId = 0; List <StateMasterModel.District> model = new List <StateMasterModel.District>(); var DistIdParam = new SqlParameter { ParameterName = "DistId", DbType = DbType.Int32, Value = distId }; var StringDistParam = new SqlParameter { ParameterName = "StringDist", DbType = DbType.String, Value = strDist }; model = context.Database.SqlQuery <StateMasterModel.District>("Sp_DistMaster_GetAllDist @DistId,@StringDist", DistIdParam, StringDistParam).ToList(); return(Json(model.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { Message = CommonHelper.GetErrorMessage(ex), IsError = Convert.ToString((int)Enums.NotifyType.Error) }, JsonRequestBehavior.AllowGet)); } }
public ActionResult deptDetailQuery([DataSourceRequest] DataSourceRequest request) { DataTable dtResult = aDeptDetailAccess.getAllDeptDetail(); List <eDepartmentDetailItem> lstResult = new List <eDepartmentDetailItem>(); foreach (DataRow dtr in dtResult.Rows) { eDepartmentDetailItem item = new eDepartmentDetailItem(); item.LEVEL1_CODE = dtr["LEVEL1_CODE"].ToString(); item.LEVEL1_NAME = dtr["LEVEL1_NAME"].ToString(); item.LEVEL2_CODE = dtr["LEVEL2_CODE"].ToString(); item.LEVEL2_NAME = dtr["LEVEL2_NAME"].ToString(); item.LEVEL3_CODE = dtr["LEVEL3_CODE"].ToString(); item.LEVEL3_NAME = dtr["LEVEL3_NAME"].ToString(); item.LEVEL4_CODE = dtr["LEVEL4_CODE"].ToString(); item.LEVEL4_NAME = dtr["LEVEL4_NAME"].ToString(); item.LEVEL5_CODE = dtr["LEVEL5_CODE"].ToString(); item.LEVEL5_NAME = dtr["LEVEL5_NAME"].ToString(); item.DEPTLEVEL = dtr["DEPTLEVEL"].ToString(); item.DEPTCODE = dtr["DEPTCODE"].ToString(); item.DEPTNAME = dtr["DEPTNAME"].ToString(); lstResult.Add(item); } var jsonResult = Json(lstResult.ToDataSourceResult(request)); jsonResult.MaxJsonLength = int.MaxValue; //return Json(lstResult.ToDataSourceResult(request)); return(jsonResult); }
public ActionResult SalesOrderLine_Delete([DataSourceRequest] DataSourceRequest request, salesOrderLineModel modelSalesOrderLine) { var iResult = new List <salesOrderLineModel>(); if (!ModelState.IsValid) { iResult.Add(modelSalesOrderLine); } else { try { var iUri = new Uri(ODataWebService.BuildODataUrl()); var iWebService = new NAV(iUri) { Credentials = ODataWebService.CreateCredentials(iUri.ToString()) }; var salesOrderLine = (from lsalesOrderLine in iWebService.salesOrderLines where lsalesOrderLine.id == modelSalesOrderLine.id select lsalesOrderLine).FirstOrDefault(); if (salesOrderLine != null) { iWebService.DeleteObject(salesOrderLine); iWebService.SaveChanges(); } } catch (DataServiceRequestException ex) { ModelState.AddModelError("", ex.Message); iResult.Add(modelSalesOrderLine); } } return(Json(iResult.ToDataSourceResult(request, ModelState))); }
public JsonResult Search([DataSourceRequest] DataSourceRequest request, Int64 projectid, int grantId) { GetDropdownList(); try { //projectid = projectid == 0 ? 0 : projectid; //grantId = grantId == 0 ? 0 : grantId; //Int64 empid = (Int64)Session[Constants.SessionEmpID]; //var GetDetails = DB.Database.SqlQuery<SearchList>( // @"exec " + Constants.P_GetEmpTimesheetBy_Grant + " @EmpID,@ProjectID,@GradeId", // new object[] { // new SqlParameter("@EmpID", empid), // new SqlParameter("@ProjectID", projectid), // new SqlParameter("@GradeId", grantId) // }).ToList(); long empid = (long)Session[Constants.SessionEmpID]; List <SearchList> result = GetProjects(projectid, grantId, empid); return(Json(result.ToDataSourceResult(request))); //return Json(new //{ // data = result //}); } catch (Exception ex) { LogHelper.ErrorLog(ex); throw ex; } }
/// <summary> /// This action is used for treelist for the connection and its child point/element /// </summary> /// <param name="request"></param> /// <param name="id"></param> /// <returns></returns> public JsonResult Connection_Point_Select([DataSourceRequest] DataSourceRequest request, int?id, string row_type, string element_source_id, int?connector_id) { IList <DiscoveryPoint_DTO> list_discovery_point = new List <DiscoveryPoint_DTO>(); DiscoverPoint_Type discoverypoint_type; if (id == null) { list_discovery_point = objDiscoveryRep.Get_Connection_Points(id); } else if (Enum.TryParse(row_type, out discoverypoint_type)) { if (discoverypoint_type == DiscoverPoint_Type.Connection) { list_discovery_point = objDiscoveryRep.GetNonDiscoverElementByConnectorID((int)id); } else { list_discovery_point = objDiscoveryRep.GetNonDiscoverElementByConnectorID((int)connector_id, element_source_id, (int)id); } } else { list_discovery_point = objDiscoveryRep.GetNonDiscoverElementByConnectorID((int)id); } DataSourceResult result = list_discovery_point.ToDataSourceResult(request); return(new JsonResult() { Data = result, JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = Int32.MaxValue }); }
public ActionResult Products_Create([DataSourceRequest]DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<ProductViewModel> products) { // Will keep the inserted entitites here. Used to return the result later. var entities = new List<Product>(); if (ModelState.IsValid) { using (var northwind = new NorthwindEntities()) { foreach (var product in products) { // Create a new Product entity and set its properties from the posted ProductViewModel var entity = new Product { ProductName = product.ProductName, UnitsInStock = product.UnitsInStock }; // Add the entity northwind.Products.Add(entity); // Store the entity for later use entities.Add(entity); } // Insert the entities in the database northwind.SaveChanges(); } } // Return the inserted entities. The grid needs the generated ProductID. Also return any validation errors. return Json(entities.ToDataSourceResult(request, ModelState, product => new ProductViewModel { ProductID = product.ProductID, ProductName = product.ProductName, UnitsInStock = product.UnitsInStock })); }
public ActionResult ListShippingCityAll_Read([DataSourceRequest] DataSourceRequest request, string RegionID) { var data = new List <DC_Location_MappingLocation>(); data = DC_Location_MappingLocation.GetAllDC_Location_Mapping_City(RegionID).ToList(); return(Json(data.ToDataSourceResult(request))); }
public ActionResult MappingLocation_Read([DataSourceRequest] DataSourceRequest request) { var data = new List <DC_Location_MappingLocation>(); data = DC_Location_MappingLocation.GetAllDC_Location_Regions(); return(Json(data.ToDataSourceResult(request))); }
public async Task <DataSourceResult> Get([DataSourceRequest] DataSourceRequest request) { List <FundingInterestRate> _FundingInterestRate = new List <FundingInterestRate>(); try { string baseadress = config.Value.urlbase; HttpClient _client = new HttpClient(); _client.DefaultRequestHeaders.Add("Authorization", "Bearer " + HttpContext.Session.GetString("token")); var result = await _client.GetAsync(baseadress + "api/FundingInterestRate/GetFundingInterestRate"); string valorrespuesta = ""; if (result.IsSuccessStatusCode) { valorrespuesta = await(result.Content.ReadAsStringAsync()); _FundingInterestRate = JsonConvert.DeserializeObject <List <FundingInterestRate> >(valorrespuesta); _FundingInterestRate = _FundingInterestRate.OrderByDescending(q => q.Id).ToList(); } } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); throw ex; } return(_FundingInterestRate.ToDataSourceResult(request)); }
public ActionResult empDeptQuery([DataSourceRequest] DataSourceRequest request) { DataTable dtResult = aDeptDetailAccess.getAllDeptDetail(); List <eEmployeeDept> lstResult = new List <eEmployeeDept>(); /* * foreach (DataRow dtr in dtResult.Rows) * { * eEmployeeDept item = new eEmployeeDept(); * item.SYS_EMPID = dtr["SYS_EMPID"].ToString(); * item.EMPID = dtr["EMPID"].ToString(); * item.EMPNAME = dtr["EMPNAME"].ToString(); * item.DEPTCODE = dtr["DEPTCODE"].ToString(); * item.DEPTNAME = dtr["DEPTNAME"].ToString(); * lstResult.Add(item); * } */ for (int i = 0; i < 10000; i++) { DataRow dtr = dtResult.Rows[i] as DataRow; eEmployeeDept item = new eEmployeeDept(); item.SYS_EMPID = dtr["SYS_EMPID"].ToString(); item.EMPID = dtr["EMPID"].ToString(); item.EMPNAME = dtr["EMPNAME"].ToString(); item.DEPTCODE = dtr["DEPTCODE"].ToString(); item.DEPTNAME = dtr["DEPTNAME"].ToString(); lstResult.Add(item); } var jsonResult = Json(lstResult.ToDataSourceResult(request)); jsonResult.MaxJsonLength = int.MaxValue; //return Json(lstResult.ToDataSourceResult(request)); return(jsonResult); }
public async Task <DataSourceResult> GetRoles([DataSourceRequest] DataSourceRequest request) { List <ApplicationRole> _roles = new List <ApplicationRole>(); try { string baseadress = config.Value.urlbase; HttpClient _client = new HttpClient(); string token = ""; token = HttpContext.Session.GetString("token"); _client.DefaultRequestHeaders.Add("Authorization", "Bearer " + token); var result = await _client.GetAsync(baseadress + "api/Roles/GetRoles"); string valorrespuesta = ""; if (result.IsSuccessStatusCode) { valorrespuesta = await(result.Content.ReadAsStringAsync()); _roles = JsonConvert.DeserializeObject <List <ApplicationRole> >(valorrespuesta); _roles = _roles.OrderBy(q => q.Name).ToList(); } } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); //return BadRequest($"Ocurrio un error{ex.Message}"); } return(_roles.ToDataSourceResult(request)); }
public JsonResult GetData([DataSourceRequest] DataSourceRequest request) { List <DepartmentsModel> departlst = new List <DepartmentsModel>(); var lst = NT.Department; foreach (var depts in lst) { var departments = new DepartmentsModel { DepartmentId = depts.DepartmentId, NameAr = depts.NameAr, NameEn = depts.NameEn, ShortcutAr = depts.ShortcutAr, ShortcutEn = depts.ShortcutEn }; //Departments.CreatedAt = Depts.CreatedAt; //Departments.CreatedBy = Depts.CreatedBy; //Departments.ModifiedAt = Depts.ModifiedAt; //Departments.ModifiedBy = Depts.ModifiedBy; departlst.Add(departments); NT.SaveChanges(); } //Fill Distribution Method Object return(Json(departlst.ToDataSourceResult(request))); }
public JsonResult GetFields([DataSourceRequest] DataSourceRequest request, int ClassID) { Classes classes = _ClassesBL.getClass(ClassID); List <Fields> fields = _FieldsBL.getClassFields(classes); List <FieldsModel> oList = new List <FieldsModel>(); foreach (Fields fieldItem in fields) { oList.Add(new FieldsModel() { ID = fieldItem.ID, FIELD_Name = fieldItem.FIELD_Name, FIELD_Caption = fieldItem.FIELD_Caption, DEF_VAL = fieldItem.DEF_VAL, FIELD_Type = fieldItem.FIELD_Type, MAX_VALUE = fieldItem.MAX_VALUE, MIN_VALUE = fieldItem.MIN_VALUE, ORDER = fieldItem.ORDER, REQUIERD = fieldItem.REQUIERD, Class_ID = fieldItem.Class_ID, Domain_ID = fieldItem.Domain_ID }); } return(Json(oList.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
public IActionResult CustomerCoordinates_Insert([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <CustomerCoordinatesModel> customerCoordinates) { var results = new List <CustomerCoordinatesModel>(); if (customerCoordinates != null && ModelState.IsValid) { foreach (var customerCoordinate in customerCoordinates) { bool isValidCustNum = false; //check if the cust num is valid isValidCustNum = CheckCustNum(customerCoordinate.CustNum); //check if the custnum is not a dupe isValidCustNum = CheckCustNumDupes(customerCoordinate.CustNum); if (isValidCustNum == true) { int recordsCreated = InsertCustomerCoordinates(customerCoordinate.CustNum, customerCoordinate.Latitude, customerCoordinate.Longitude); results.Add(customerCoordinate); } else { results.Remove(customerCoordinate); ModelState.AddModelError("Invalid Customer Number", $"{customerCoordinate.CustNum} is an invalid Customer Number."); } } } else { ModelState.AddModelError("Error", "There was an error adding the customer coordinantes. Please verify customer data and try again."); } return(Json(results.ToDataSourceResult(request, ModelState))); }
public ActionResult ShippingItemSelectAll([DataSourceRequest] DataSourceRequest request) { BL.ShippingItems blShippingItems = new BL.ShippingItems(); List <ShippingItem> model = blShippingItems.SelectAll(); return(Json(model.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
public JsonResult List_Read(DataSourceRequest request) { var items = _activityBusinessLogic.GetAllEntities().ToArray();//.Select(x => new ActivityModel //{ // Id = x.Id, // ActivityDate = x.CreateDate, // UserName = x.Author.Name, // Type = x.Type.Name, // UserAgent = x.UserAgent, // //Tags = x.GetAllTags(), //}).ToList(); items.FirstOrDefault(); var act = new List<ActivityModel>(); foreach (var activity in items) { act.Add(new ActivityModel { Tags = activity.GetAllTags(), Id = activity.Id, UserAgent = activity.UserAgent, ActivityDate = activity.CreateDate, UserName = activity.Author.Name, //Type = activity.Type.Name }); } DataSourceResult result = act.ToDataSourceResult(request); return Json(result, JsonRequestBehavior.AllowGet); }
public ActionResult ListRegionMappingedAll_Read([DataSourceRequest] DataSourceRequest request, string RegionID) { var data = new List <DC_Location_City>(); data = DC_Location_City.GetDC_Location_Citys("1=1", "").Where(s => s.RegionID == RegionID).ToList(); return(Json(data.ToDataSourceResult(request))); }
public DataSourceResult WHS_Owner_Label_Create(IEnumerable <WHS_Owner_Label> items, string CreatedBy) { string WHS_Owner_Label_List = string.Empty; string WHS_Owner_Label_List_Serialized = string.Empty; string WHS_Owner_Label_Items_Serialized = string.Empty; string message = string.Empty; List <WHS_Owner_Label> result = new List <WHS_Owner_Label>(); try { WMS.Models.DBContext model = new DBContext(); foreach (WHS_Owner_Label item in items) { WHS_Owner_Label dbItem = new WHS_Owner_Label(); item.CreatedBy = item.ModifiedBy = CreatedBy; item.CreatedDate = item.ModifiedDate = Common.getUTCDate(); dbItem.IsSelected = item.IsSelected; dbItem.TagStr = item.TagStr; dbItem.Case_Label_Type = item.Case_Label_Type; dbItem.CreatedBy = item.CreatedBy; dbItem.CreatedDate = item.CreatedDate; dbItem.ID = item.ID; dbItem.IsDeleted = item.IsDeleted; dbItem.LPN_Barcode_Format = item.LPN_Barcode_Format; dbItem.LPN_Length = item.LPN_Length; dbItem.LPN_Next_Number = item.LPN_Next_Number; dbItem.LPN_Start_Number = item.LPN_Start_Number; dbItem.ModifiedBy = item.ModifiedBy; dbItem.ModifiedDate = item.ModifiedDate; dbItem.Owner_ID = item.Owner_ID; dbItem.Roll_Back_Number = item.Roll_Back_Number; WHS_Owner_Label_Items_Serialized += Common.SerializeObject(item); model.DBSet_WHS_Owner_Label.Add(dbItem); Common.SaveChanges(model); item.ID = dbItem.ID; WHS_Owner_Label_List += "[" + item.ID + "] "; result.Add(item); WHS_Owner_Label_List_Serialized += Common.SerializeObject(item); } } catch (Exception ex) { message = ex.Message; Common.log.Error(WHS_Owner_Label_Items_Serialized, ex); } finally { if (!string.IsNullOrEmpty(message)) { Common.log.Warn(CreatedBy + " => " + WHS_Owner_Label_Items_Serialized, new Exception(message)); } Common.log.Info(string.Format("User: {0} - [end] - WHS_Owner_Label_Create: {1} - {2}", CreatedBy, WHS_Owner_Label_List, WHS_Owner_Label_List_Serialized)); } return(result.ToDataSourceResult(new DataSourceRequest())); }
public ActionResult Section_Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<Section> sections) { var results = new List<Section>(); if (sections != null && ModelState.IsValid) { foreach (var section in sections) { var addedSection = sectionDataHandler.AddSection(section); if (addedSection != null) { ViewBag.Message = "Record saved"; ViewBag.ErrorFound = false; section.SectionID = addedSection.SectionID; } else { ViewBag.Message = "Failed to save record"; ViewBag.ErrorFound = true; } results.Add(section); } } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult SalesOrderLines_Read([DataSourceRequest] DataSourceRequest request, Guid documentId) { var salesOrderLinesModel = new List <salesOrderLineModel>(); try { var iUri = new Uri(ODataWebService.BuildODataUrl()); var iWebService = new NAV(iUri) { Credentials = ODataWebService.CreateCredentials(iUri.ToString()) }; var salesOrderLines = (from lsalesOrderLine in iWebService.salesOrderLines where lsalesOrderLine.documentId == documentId orderby lsalesOrderLine.sequence select lsalesOrderLine); foreach (salesOrderLine lsalesOrderLine in salesOrderLines) { salesOrderLinesModel.Add(new salesOrderLineModel(lsalesOrderLine)); } } catch (DataServiceRequestException ex) { ModelState.AddModelError("", ex.Message); } return(Json(salesOrderLinesModel.ToDataSourceResult(request, ModelState))); }
public async Task <ActionResult> StateRead([DataSourceRequest] DataSourceRequest request, string str) { try { var stateId = 0; if (str == null) { str = ""; } var StateIdParam = new SqlParameter { ParameterName = "StateId", DbType = DbType.Int32, Value = stateId }; var StringParam = new SqlParameter { ParameterName = "String", DbType = DbType.String, Value = str }; List <StateMasterModel.State> model = new List <StateMasterModel.State>(); model = context.Database.SqlQuery <StateMasterModel.State>("Sp_StateMaster_GetAllState @StateId,@String", StateIdParam, StringParam).ToList(); return(Json(model.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { Message = CommonHelper.GetErrorMessage(ex), IsError = Convert.ToString((int)Enums.NotifyType.Error) }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Pie_Read([DataSourceRequest] DataSourceRequest request) { var Dessert = db.Dessert.Where(x => x.DessertKind == "Pie" && x.IsOnSale); List<AddDessertViewModel> PieDessert = new List<AddDessertViewModel>(); foreach (var item in Dessert) { PieDessert.Add(AddModel(item)); } return Json(PieDessert.ToDataSourceResult(request)); }
public JsonResult GetCompanySites(DataSourceRequest request, Guid id) { var items = _companyBusinessLogic.GetAllEntities().Where(x => x.Id == id).SelectMany(x => x.Sites).ToList(); var models = new List<SiteModel>(); foreach (var site in items) { models.Add(site.ConvertToSiteModel()); } var result = models.ToDataSourceResult(request); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult GetCompanies(DataSourceRequest request) { var items = _companyBusinessLogic.GetAllEntities().ToList(); var models = new List<CompanyModel>(); foreach (var company in items) { models.Add(company.ConvertToCompanyModel()); } var result = models.ToDataSourceResult(request); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult List_Read(DataSourceRequest request) { var items = _leadTypeBusinessLogic.GetAllEntities();//.Select(x => ConvertToSiteModel(x)); var models = new List<LeadTypeModel>(); foreach (var clientSite in items) { //models.Add(ConvertToLeadModel(clientSite)); } DataSourceResult result = models.ToDataSourceResult(request); return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult List_Read(DataSourceRequest request, Guid id) { var items = _siteBusinessLogic.GetAllEntities().Where(x => x.Owner.Id == id);//.Select(x => ConvertToSiteModel(x)); var models = new List<SiteModel>(); foreach (var clientSite in items) { models.Add(clientSite.ConvertToSiteModel()); } DataSourceResult result = models.ToDataSourceResult(request); return Json(result, JsonRequestBehavior.AllowGet); }
public async Task<JsonResult> Log_Read([DataSourceRequest]DataSourceRequest request, string userID = "") { List<SlotTransactionModel> allSlotTransaction = new List<SlotTransactionModel>(); if (string.IsNullOrWhiteSpace(userID)) { using (var client = new HttpClient()) { string url = System.Configuration.ConfigurationManager.AppSettings["SmartParkingAPI"]; client.BaseAddress = new Uri(url); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response = await client.GetAsync("api/SlotTransaction/GetSlotTransaction"); if (response.IsSuccessStatusCode) { allSlotTransaction = await response.Content.ReadAsAsync<List<SlotTransactionModel>>(); } } DataSourceResult result = allSlotTransaction.ToDataSourceResult(request); return Json(result); } else { int UserID = int.Parse(userID); using (var client = new HttpClient()) { string url = System.Configuration.ConfigurationManager.AppSettings["SmartParkingAPI"]; client.BaseAddress = new Uri(url); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response = await client.GetAsync("api/SlotTransaction/GetSlotTransactionAsUser?userId=" + UserID); if (response.IsSuccessStatusCode) { allSlotTransaction = await response.Content.ReadAsAsync<List<SlotTransactionModel>>(); } } DataSourceResult result = allSlotTransaction.ToDataSourceResult(request); return Json(result); } }
public ActionResult CreateRate([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<ProviderRate> products) { var results = new List<ProviderRate>(); if (products != null && ModelState.IsValid) { results.AddRange(products); } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult Editing_Create([DataSourceRequest] DataSourceRequest request, ProductViewModel product) { var results = new List<ProductViewModel>(); if (product != null && ModelState.IsValid) { SessionProductRepository.Insert(product); results.Add(product); } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult Editing_Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<Member_CreditIndex_Type> Member_CreditIndex_Types) { var results = new List<Member_CreditIndex_Type>(); if (Member_CreditIndex_Types != null && ModelState.IsValid) { foreach (var Member_CreditIndex_Type in Member_CreditIndex_Types) { Member_CreditIndex_TypeService.Create(Member_CreditIndex_Type); } } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult Editing_Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<CompanyBussiness> CompanyBussinesss) { var results = new List<CompanyBussiness>(); if (CompanyBussinesss != null && ModelState.IsValid) { foreach (var CompanyBussiness in CompanyBussinesss) { CompanyBussinessService.Create(CompanyBussiness); } } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult Editing_Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<Area> areas) { var results = new List<Area>(); if (areas != null && ModelState.IsValid) { foreach (var area in areas) { areaService.Create(area); } } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult Create([DataSourceRequest] DataSourceRequest request, Tweet tweet) { var results = new List<Tweet>(); if (ModelState.IsValid) { this.Data.Tweets.Add(tweet); this.Data.SaveChanges(); results.Add(tweet); } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult Editing_Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<ArticleCate> ArticleCates) { var results = new List<ArticleCate>(); if (ArticleCates != null && ModelState.IsValid) { foreach (var ArticleCate in ArticleCates) { ArticleCateService.Create(ArticleCate); } } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable<LessonTypeGrid> lessons) { var results = new List<LessonTypeGrid>(); if (lessons != null) { foreach (var lesson in lessons) { store.Create(lesson); results.Add(lesson); } } return Json(results.ToDataSourceResult(request)); }
public JsonResult List_Read(DataSourceRequest request) { var items = _contactBusinessLogic.GetAllEntities().ToList();//.Select(x => x.ConvertToContactModel()); var models = new List<ContactModel>(); foreach (var contact in items) { models.Add(contact.ConvertToContactModel()); } DataSourceResult result = models.ToDataSourceResult(request); return Json(result); }
protected ActionResult BaseCreate([DataSourceRequest]DataSourceRequest request, object model) { var list = new List<object>(); if (model != null && ModelState.IsValid) { var itemForAdding = this.Data.Context.Entry(model); itemForAdding.State = EntityState.Added; this.Data.SaveChanges(); list.Add(model); } return this.Json(list.ToDataSourceResult(request)); }
public ActionResult Editing_Create([DataSourceRequest] DataSourceRequest request, CategoryViewModel cat) { var results = new List<CategoryViewModel>(); if (cat != null && ModelState.IsValid) { _repository.Create(cat); cat.ID = _repository.Categories.First().ID; results.Add(cat); } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult Update([DataSourceRequest]DataSourceRequest request, ModelType model) { var list = new List<ModelType>(); if (model != null && ModelState.IsValid) { var itemForUpdating = this.Data.Context.Entry(model.ToEntity); itemForUpdating.State = EntityState.Modified; this.Data.SaveChanges(); list.Add(model); } return this.Json(list.ToDataSourceResult(request)); }
public JsonResult Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<License> licenses) { var results = new List<License>(); if (licenses != null && ModelState.IsValid) { foreach (var license in licenses) { LicenseRepository.Repository.Insert(license); results.Add(license); } } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult StockCreate([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<Stock> products) { var results = new List<Stock>(); if (products != null && ModelState.IsValid) { foreach (var product in products) { service.Create(product); results.Add(product); } } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult ForeignKeyColumn_Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<ProductViewModel> products) { var results = new List<ProductViewModel>(); if (products != null && ModelState.IsValid) { foreach (var product in products) { productService.Create(product); results.Add(product); } } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult Editing_Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<ProductViewModel> products) { var results = new List<ProductViewModel>(); if (products != null && ModelState.IsValid) { foreach (var product in products) { SessionProductRepository.Insert(product); results.Add(product); } } return Json(results.ToDataSourceResult(request, ModelState)); }
public ActionResult Update([DataSourceRequest]DataSourceRequest request, ViewModelType model) { var list = new List<ViewModelType>(); if (model != null && this.ModelState.IsValid) { var userProfile = this.Data.Users.All().FirstOrDefault(u => u.Id == model.Id); var itemForUpdating = this.Data.Context.Entry(model.GetEntityModel(userProfile)); itemForUpdating.State = EntityState.Modified; this.Data.SaveChanges(); list.Add(model); } return this.Json(list.ToDataSourceResult(request)); }
public ActionResult Editing_Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<Permissions> permissions) { var results = new List<Permissions>(); if (permissions != null && ModelState.IsValid) { foreach (var permission in permissions) { permissionService.Create(permission); results.Add(permission); } } return Json(results.ToDataSourceResult(request, ModelState)); }