Example #1
0
        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));
        }
Example #4
0
        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(""));
            }
        }
Example #5
0
        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));
        }
Example #6
0
        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;
        }
Example #9
0
        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));
        }
Example #10
0
        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)));
        }
Example #11
0
        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)));
        }
Example #12
0
        public ActionResult Client_Read([DataSourceRequest] DataSourceRequest request)
        {
            List <Client>    Clients = clientFactory.GetClients();
            DataSourceResult result  = Clients.ToDataSourceResult(request);

            return(Json(result));
        }
Example #13
0
        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));
        }
Example #14
0
        public ActionResult TrackingRequestByCustomer([DataSourceRequest] DataSourceRequest request, string CustomerID)
        {
            var data = new List <DC_RequestCredit>();

            data = DC_RequestCredit.GetCustomerCreditRequestByCustomerID(CustomerID);
            return(Json(data.ToDataSourceResult(request)));
        }
Example #15
0
        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));
            }
        }
Example #17
0
        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);
        }
Example #18
0
        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
     }));
 }
Example #22
0
        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)));
        }
Example #23
0
        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));
        }
Example #25
0
        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);
        }
Example #26
0
        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));
        }
Example #27
0
        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)));
        }
Example #28
0
        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));
        }
Example #29
0
        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);
 }
Example #32
0
        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)));
        }
Example #33
0
        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));
        }
Example #35
0
        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));
        }
Example #38
0
 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);
 }
Example #39
0
 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);
 }
Example #40
0
 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);
 }
Example #41
0
 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));
        }
Example #47
0
        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));
        }
Example #49
0
        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));
 }
Example #51
0
        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));
        }
Example #53
0
        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));
        }
Example #56
0
        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));
        }
Example #59
0
        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));
        }
Example #60
0
        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));
        }