public string SaveCompany(CompanyModels companyModel)
        {
            CompanyDTO company = new CompanyDTO();
            MessageDTO message = new MessageDTO();

            company.CompanyId        = Convert.ToInt32(companyModel.Id);
            company.CompanyName      = companyModel.CompanyDescription;
            company.CompanyShortName = companyModel.CompanyShortName;
            company.CompanyStatus    = companyModel.CompanyStatus;
            company.User             = new UserDTO {
                UserId = Convert.ToInt32(companyModel.UserId)
            };

            if (String.Compare(companyModel.Operation, "add", StringComparison.Ordinal) == 0)
            {
                message = business.SaveCompany(company, "I");
            }
            else if (String.Compare(companyModel.Operation, "edit", StringComparison.Ordinal) == 0)
            {
                message = business.SaveCompany(company, "U");
            }

            JavaScriptSerializer oSerializer = new JavaScriptSerializer();
            string sJSON = oSerializer.Serialize(message);

            return(sJSON);
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public virtual List <CompanyModels> ReadCompanies(string query)
        {
            List <CompanyModels> companyList = new List <CompanyModels>();
            IDataReader          iDataReader = null;

            try
            {
                using (iDataReader = ExecuteDataReader(query, null))
                {
                    if (iDataReader != null)
                    {
                        while (iDataReader.Read())
                        {
                            CompanyModels roleModel = new CompanyModels
                            {
                                CompanyId   = Convert.ToInt32(iDataReader["company_id"]),
                                CompanyName = Convert.ToString(iDataReader["company_name"])
                            };
                            companyList.Add(roleModel);
                        }
                    }
                }
                return(companyList);
            }
            catch (Exception companyException)
            {
                LambdaLogger.Log(companyException.ToString());
                return(null);
            }
        }
Beispiel #3
0
        public ActionResult Edit(CompanyModels model)
        {
            try
            {
                if (string.IsNullOrEmpty(model.Name))
                {
                    ModelState.AddModelError("Name", CurrentUser.GetLanguageTextFromKey("Name is required"));
                }

                if (!ModelState.IsValid)
                {
                    Response.StatusCode = (int)HttpStatusCode.BadRequest;
                    return(PartialView("_Edit", model));
                }
                //====================
                string msg    = "";
                var    result = EditCompanyFatory.Company.UpdateCompany(model, ref msg, CurrentUser.ListOrganizationId);
                if (result)
                {
                    return(RedirectToAction("Index", "SStoreInformation"));
                }
                else
                {
                    ModelState.AddModelError("Name", msg);
                    Response.StatusCode = (int)HttpStatusCode.BadRequest;
                    return(PartialView("_Edit", model));
                }
            }
            catch (Exception ex)
            {
                NSLog.Logger.Info("Edit Company", ex);
                return(new HttpStatusCodeResult(400, ex.Message));
            }
        }
        public IHttpActionResult GetAlarmMessageByFactoryId(int factoryId, [FromUri] int top = 10, [FromUri] int hours = 168, [FromUri] string order = "desc")
        {
            try
            {
                FactoryModels        factoryModel = new FactoryModels();
                int                  companyId    = factoryModel.getFactoryById(factoryId).CompanyId;
                CompanyModels        companyModel = new CompanyModels();
                CompanyModels.Detail company      = companyModel.getCompanyById(companyId);
                DocumentDBHelper     docDBHelpler = new DocumentDBHelper(companyId, company.DocDBConnectionString);
                return(Ok(docDBHelpler.GetAlarmMessageByFactoryId(factoryId, top, hours, order)));
            }
            catch (Exception ex)
            {
                StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
                string        logAPI     = "[Get] " + Request.RequestUri.ToString();
                Startup._sfAppLogger.Error(logAPI + logMessage);

                return(InternalServerError(ex));
            }
            //try
            //{
            //    FactoryModels factoryModel = new FactoryModels();
            //    int companyId = factoryModel.getFactoryById(factoryId).CompanyId;
            //    DocDB_AlarmMessageModels alarmMessageModel = new DocDB_AlarmMessageModels(companyId);
            //    return Ok(alarmMessageModel.GetByFactoryId(factoryId, top, hours, order));
            //}
            //catch (Exception ex)
            //{
            //    StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
            //    string logAPI = "[Get] " + Request.RequestUri.ToString();
            //    Startup._sfAppLogger.Error(logAPI + logMessage);

            //    return InternalServerError(ex);
            //}
        }
        public IHttpActionResult GetCompanyById()
        {
            int      companyId  = GetCompanyIdFromToken();
            RedisKey cacheKey   = "external_company_" + companyId;
            string   cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);

            if (cacheValue == null)
            {
                CompanyModels companyModel = new CompanyModels();
                try
                {
                    CompanyModels.Detail_readonly company = companyModel.getCompanyByIdReadonly(Convert.ToInt32(companyId.ToString()));
                    RedisCacheHelper.SetKeyValue(cacheKey, JsonConvert.SerializeObject(company));
                    return(Ok(company));
                }
                catch (Exception ex)
                {
                    StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
                    string        logAPI     = "[Get] " + Request.RequestUri.ToString();
                    Startup._sfAppLogger.Error(logAPI + logMessage);

                    return(InternalServerError());
                }
            }
            else
            {
                return(Ok(new JavaScriptSerializer().Deserialize <Object>(cacheValue)));
            }
        }
Beispiel #6
0
        public IHttpActionResult EditFormData(int id, [FromBody] CompanyModels.Update company)
        {
            JavaScriptSerializer js = new JavaScriptSerializer();
            string logForm          = "Form : " + js.Serialize(company);
            string logAPI           = "[Put] " + Request.RequestUri.ToString();

            if (!ModelState.IsValid || company == null)
            {
                Startup._sfAppLogger.Warn(logAPI + " || Input Parameter not expected || " + logForm);
                return(BadRequest("Invalid data"));
            }

            try
            {
                CompanyModels companyModel = new CompanyModels();
                companyModel.updateCompany(id, company);
                RedisCacheHelper.DeleteCompanyCache(id);
                return(Ok("Success"));
            }
            catch (Exception ex)
            {
                StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
                logMessage.AppendLine(logForm);
                Startup._sfAppLogger.Error(logAPI + logMessage);

                return(InternalServerError(ex));
            }
        }
Beispiel #7
0
        public string CompanyInformationDetailsInsertUpdateDelete(CompanyModels mode)
        {
            object[] objParam = { mode.UniqueID, mode.CompanyName, mode.GSTNumber, mode.CompanyAddress, mode.UploadFile, mode.StateName, mode.CityName, mode.PinCode, mode.ParentId, mode.ContactNo, mode.EmailID, mode.BankName, mode.AccountNumber, mode.IFSCCode, mode.IsActive, mode.CreatedBy };
            var      d        = SqlHelper.ExecuteScalar(db.GetConnection(), Procedures.CompanyInformationDetailsInsertUpdateDelete_USP, objParam);

            return(Convert.ToString(d));
        }
        public void Insert(CompanyModels kisi)
        {
            using (var uow = new UnitOfWork <EmployeeDbContext>())
            {
                uow.GetRepository <CompanyModels>().Add(kisi);
                uow.SaveChanges();
            }
            var factory = new ConnectionFactory()
            {
                HostName = "localhost",
                UserName = "******",
                Password = "******"
            };

            using (var connection = factory.CreateConnection())
                using (var channel = connection.CreateModel())
                {
                    channel.QueueDeclare(
                        queue: "EmailQuee",
                        durable: false,
                        exclusive: false,
                        autoDelete: false,
                        arguments: null
                        );
                    var message = JsonConvert.SerializeObject(kisi);
                    var body    = Encoding.UTF8.GetBytes(message);
                    channel.BasicPublish(
                        exchange: "",
                        routingKey: "EmailQuee",
                        basicProperties: null,
                        body: body
                        );
                }
        }
Beispiel #9
0
        public ActionResult Index()
        {
            var CompanyModels = new CompanyModels();

            CompanyModels.MainCompany       = new MainCompany();
            CompanyModels.SubsidiaryCompany = new SubsidiaryCompany();
            return(View(CompanyModels));
        }
        public ActionResult AddCompanyDetails(CompanyModels comp)
        {
            comp.IsActive  = true;
            comp.CreatedBy = SessionWrapper.User.UniqueID;
            comp.CreatedOn = DateTime.Now;
            var modelCreate = _allcomps.CompanyInformationDetailsInsertUpdateDelete(comp);

            return(Json(modelCreate, JsonRequestBehavior.AllowGet));
        }
Beispiel #11
0
 public IActionResult Update(CompanyModels kisi)
 {
     using (var uow = new UnitOfWork <EmployeeDbContext>())
     {
         uow.GetRepository <CompanyModels>().Update(kisi);
         uow.SaveChanges();
         TempData["BasariliMesaj"] = "Kişi bilgileri başarıyla güncellendi";
         return(RedirectToAction("Index"));
     }
 }
Beispiel #12
0
        public async Task <HttpResponseMessage> UploadLogoFile(int id)
        {
            // Check if the request contains multipart/form-data.
            if (!Request.Content.IsMimeMultipartContent())
            {
                return(Request.CreateResponse(HttpStatusCode.UnsupportedMediaType));
            }

            CompanyModels companyModel = new CompanyModels();
            FileUtility   fileHelper   = new FileUtility();
            string        root         = Path.GetTempPath();
            var           provider     = new MultipartFormDataStreamProvider(root);

            try
            {
                CompanyModels.Detail company = companyModel.getCompanyById(id);
            }
            catch
            {
                return(Request.CreateResponse(HttpStatusCode.NotFound));
            }

            try
            {
                // Read the form data.
                string fileAbsoluteUri = "";
                await Request.Content.ReadAsMultipartAsync(provider);

                //FileData
                foreach (MultipartFileData fileData in provider.FileData)
                {
                    string formColumnName   = fileData.Headers.ContentDisposition.Name;
                    string fileExtenionName = fileData.Headers.ContentDisposition.FileName.Split('.')[1];
                    if (fileHelper.CheckImageExtensionName(formColumnName, fileExtenionName))
                    {
                        string uploadFilePath = "company-" + id + "/" + id + "-default." + fileHelper.LowerAndFilterString(fileExtenionName);
                        fileAbsoluteUri = fileHelper.SaveFiletoStorage(fileData.LocalFileName, uploadFilePath, "images");
                    }
                }

                if (fileAbsoluteUri.Equals(""))
                {
                    return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "File is empty or wrong extension name"));
                }

                //Edit company logo path
                companyModel.updateCompanyLogoURL(id, fileAbsoluteUri);
                RedisCacheHelper.DeleteCompanyCache(id);
                return(Request.CreateResponse(HttpStatusCode.OK, new { imageURL = fileAbsoluteUri }));
            }
            catch (System.Exception e)
            {
                return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e));
            }
        }
        public ActionResult Uploads(string UniqueID = "0")
        {
            var comp = new CompanyModels();

            comp.UniqueID   = Convert.ToInt64(UniqueID);
            comp.UploadFile = Request.Files[0] == null ? new byte[0] : new byte[Request.Files[0].ContentLength];
            Request.Files[0].InputStream.Read(comp.UploadFile, 0, Request.Files[0].ContentLength);
            var modelCreate = _allcomps.CompanyInformationDetailsInsertUpdateDelete(comp);

            return(Json(modelCreate, JsonRequestBehavior.AllowGet));
        }
Beispiel #14
0
        public bool EmployeeAddCompany(InteEmployeeModels model, ref string msg)
        {
            try
            {
                CompanyModels        obj;
                List <CompanyModels> ListComp = new List <CompanyModels>();
                if (model.LstCompany != null && model.LstCompany.Count > 0)
                {
                    foreach (var item in model.LstCompany)
                    {
                        obj    = new CompanyModels();
                        obj.ID = item.Value;
                        ListComp.Add(obj);
                    }
                }
                EmployeeAddCompanyRequest paraBody = new EmployeeAddCompanyRequest();
                paraBody.AppKey        = Commons.AppKey;
                paraBody.AppSecret     = Commons.AppSecret;
                paraBody.CreatedUser   = Commons.CreateUser;
                paraBody.RegisterToken = new RegisterTokenModels();

                paraBody.EmployeeID  = model.ID;
                paraBody.ListCompany = ListComp;

                //====================
                var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.EmployeeAddCompany, null, paraBody);
                if (result != null)
                {
                    if (result.Success)
                    {
                        return(true);
                    }
                    else
                    {
                        msg = result.Message;
                        _logger.Error(result.Message);
                        return(false);
                    }
                }
                else
                {
                    //msg = result.ToString();
                    _logger.Error(result);
                    return(false);
                }
            }
            catch (Exception e)
            {
                _logger.Error("Employee Add Company: " + e);
                //msg = e.ToString();
                return(false);
            }
        }
Beispiel #15
0
 public CompanyModels GetDetail(string id)
 {
     try
     {
         CompanyModels model = EditCompanyFatory.Company.GetDetailCompany(id, CurrentUser.ListOrganizationId)[0];
         return(model);
     }
     catch (Exception ex)
     {
         NSLog.Logger.Info("Get Detail Company", ex);
         return(null);
     }
 }
        // GET: Company/Edit/5
        public async Task <ActionResult> Edit(int id)
        {
            CompanyModels model = new CompanyModels();

            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri("http://localhost:53659/");
                client.DefaultRequestHeaders.Accept.Clear();
                client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
                var json = await client.GetStringAsync($"api/Company/{id}");

                //convierto los valores de un json en un modelo
                model = JsonConvert.DeserializeObject <CompanyModels>(json);
            }
            return(View(model));
        }
Beispiel #17
0
 public IHttpActionResult Delete(int id)
 {
     try
     {
         CompanyModels companyModel = new CompanyModels();
         companyModel.deleteCompany(id);
         RedisCacheHelper.DeleteCompanyCache(id);
         return(Ok("Success"));
     }
     catch (Exception ex)
     {
         string        logAPI     = "[Delete] " + Request.RequestUri.ToString();
         StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
         Startup._sfAppLogger.Error(logAPI + logMessage);
         return(InternalServerError());
     }
 }
Beispiel #18
0
 public bool UpdateCompany(CompanyModels model, ref string msg, List <string> ListOrganizationId = null)
 {
     try
     {
         CreateOrUpdateCompanyRequest paraBody = new CreateOrUpdateCompanyRequest();
         paraBody.AppKey         = Commons.AppKey;
         paraBody.AppSecret      = Commons.AppSecret;
         paraBody.RegisterToken  = new RegisterTokenModels();
         paraBody.CreatedUser    = Commons.CreateUser;
         paraBody.ModifiedUser   = Commons.CreateUser;
         paraBody.LastModified   = DateTime.Now;
         paraBody.CreatedDate    = DateTime.Now;
         paraBody.ID             = model.ID;
         paraBody.OrganizationID = ListOrganizationId.FirstOrDefault();
         paraBody.CompanyName    = model.Name;
         paraBody.Address        = model.Address;
         paraBody.Zipcode        = model.Zipcode;
         NSLog.Logger.Info("UpdateCompany request", paraBody);
         //====================
         var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.UpdateCompany, null, paraBody);
         NSLog.Logger.Info("UpdateCompany response", result);
         if (result != null)
         {
             if (result.Success)
             {
                 return(true);
             }
             else
             {
                 msg = result.Message;
                 NSLog.Logger.Info("UpdateCompany error", msg);
                 return(false);
             }
         }
         else
         {
             NSLog.Logger.Info("UpdateCompany error", result);
             return(false);
         }
     }
     catch (Exception e)
     {
         NSLog.Logger.Info("UpdateCompany error", e);
         return(false);
     }
 }
Beispiel #19
0
 public IActionResult Insert(CompanyModels kisi)
 {
     using (var uow = new UnitOfWork <EmployeeDbContext>())
     {
         try
         {
             uow.GetRepository <CompanyModels>().Add(kisi);
             uow.SaveChanges();
             TempData["BasariliMesaj"] = "Ekleme İşlemi Başarıyla Gerçekleşti";
         }
         catch (Exception)
         {
             TempData["HataliMesaj"] = "Hata  oluştu yeniden dene";
         }
         return(RedirectToAction("Index"));
     }
 }
Beispiel #20
0
        public IHttpActionResult GetMessageByCompanyId(int id, [FromUri] int top = 10, [FromUri] int hours = 168, [FromUri] string order = "desc")
        {
            try
            {
                CompanyModels        companyModel = new CompanyModels();
                CompanyModels.Detail company      = companyModel.getCompanyById(id);
                DocumentDBHelper     docDBHelpler = new DocumentDBHelper(id, company.DocDBConnectionString);
                return(Ok(docDBHelpler.GetMessageByCompanyId(id, top, hours, order)));
            }
            catch (Exception ex)
            {
                StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
                string        logAPI     = "[Get] " + Request.RequestUri.ToString();
                Startup._sfAppLogger.Error(logAPI + logMessage);

                return(InternalServerError(ex));
            }
        }
        public ActionResult LoadPartialCompanyDetailsView(long UniqueID, string CompanyName, string GSTNumber, string CompanyAddress, string StateName, string CityName, string PinCode, string BankName, string AccountNumber, string IFSCCode, string ContactNo, string EmailID)
        {
            var model = new CompanyModels();

            model.UniqueID       = UniqueID;
            model.CompanyName    = CompanyName;
            model.GSTNumber      = GSTNumber;
            model.CompanyAddress = CompanyAddress;
            model.StateName      = StateName;
            model.CityName       = CityName;
            model.PinCode        = PinCode;
            model.BankName       = BankName;
            model.AccountNumber  = AccountNumber;
            model.IFSCCode       = IFSCCode;
            model.ContactNo      = ContactNo;
            model.EmailID        = EmailID;
            return(View("~/Views/Company/PartialViews/_loadEditCompanyDetailView.cshtml", model));
        }
Beispiel #22
0
        // GET: Company
        public ActionResult Index()
        {
            IEnumerable <company> listCompany = service.GetMany();

            List <CompanyModels> listCompanyModels = new List <CompanyModels>();


            foreach (company c in listCompany)
            {
                CompanyModels cm = new CompanyModels();
                cm.Id      = c.Id;
                cm.Name    = c.Name;
                cm.Website = c.Website;
                cm.Country = c.Country;
                listCompanyModels.Add(cm);
            }

            return(View(listCompanyModels));
        }
Beispiel #23
0
        /// <summary>
        ///
        /// </summary>
        /// <returns></returns>
        public List <CompanyModels> CreateCompanyList()
        {
            List <CompanyModels> companyList   = new List <CompanyModels>();
            CompanyModels        companyModels = new CompanyModels
            {
                CompanyId   = 1,
                CompanyName = "ITS"
            };

            companyList.Add(companyModels);
            CompanyModels companyModel = new CompanyModels
            {
                CompanyId   = 2,
                CompanyName = "OQ"
            };

            companyList.Add(companyModel);
            return(companyList);
        }
Beispiel #24
0
        /// <summary>
        /// Retrieves a list of companies
        /// </summary>
        /// <param name="email"></param>
        /// <param name="rooturl"></param>
        /// <param name="encodedId"></param>
        /// <returns></returns>
        public async Task <CompanyModels> GetAllCompanies(string email, string rooturl, string encodedId)
        {
            if (string.IsNullOrEmpty(email) || string.IsNullOrEmpty(rooturl) || string.IsNullOrEmpty(encodedId))
            {
                return(null);
            }

            string        queryname  = WebTasksTypeConstants.GetAllCompanies;
            string        queryterms = WebApiServices.GetEmailJsonQuerySearchTerms(email);
            string        url        = $"{rooturl}api/webtasks?queryname={queryname}&queryterms={queryterms}";
            CompanyModels result     = null;

            LoggingService service   = new LoggingService();
            var            stopwatch = new Stopwatch();

            try
            {
                var response = await new WebApiServices().GetData(url, encodedId);
                if (!string.IsNullOrEmpty(response))
                {
                    result = new SerializerServices()
                             .DeserializeObject <CompanyModels>(response.NormalizeJsonString());
                }
            }
            catch (Exception ex)
            {
                service.TrackException(ex);
                throw;
            }
            finally
            {
                stopwatch.Stop();
                var properties = new Dictionary <string, string>
                {
                    { "UserEmail", email },
                    { "WebServicesEndpoint", rooturl },
                    { "EncodedId", encodedId }
                };
                service.TrackEvent(LoggingServiceConstants.GetAllCompanies, stopwatch.Elapsed, properties);
            }
            return(result);
        }
        public async Task <ActionResult> Delete(int id, CompanyModels Objeto)
        {
            try
            {
                using (var client = new HttpClient())
                {
                    client.BaseAddress = new Uri("http://localhost:53659/");
                    client.DefaultRequestHeaders.Accept.Clear();
                    client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
                    HttpResponseMessage response = await client.DeleteAsync($"api/Company/{id}");

                    response.EnsureSuccessStatusCode();
                }
                return(RedirectToAction("Index"));
            }
            catch
            {
                return(View());
            }
        }
        public async Task <ActionResult> Edit(int id, CompanyModels Objeto)
        {
            try
            {
                using (var client = new HttpClient())
                {
                    client.BaseAddress = new Uri("http://localhost:53659/");
                    client.DefaultRequestHeaders.Accept.Clear();
                    client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
                    HttpResponseMessage response = await client.PutAsJsonAsync($"api/Company/{id}", Objeto);

                    response.EnsureSuccessStatusCode();
                    // Deserialize the updated product from the response body.
                    //model = await response.Content.ReadAsAsync<AnimalModels>();
                }
                return(RedirectToAction("Index"));
            }
            catch
            {
                return(View());
            }
        }
        public IHttpActionResult GetAlarmMessageByEquipmentId(string equipmentId, [FromUri] int top = 10, [FromUri] int hours = 168, [FromUri] string order = "desc")
        {
            try
            {
                EquipmentModels      equipmentModel = new EquipmentModels();
                int                  companyId      = equipmentModel.getCompanyId(equipmentId);
                CompanyModels        companyModel   = new CompanyModels();
                CompanyModels.Detail company        = companyModel.getCompanyById(companyId);
                DocumentDBHelper     docDBHelpler   = new DocumentDBHelper(companyId, company.DocDBConnectionString);
                return(Ok(docDBHelpler.GetAlarmMessageByEquipmentId(equipmentId, top, hours, order)));
            }
            catch (Exception ex)
            {
                StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
                string        logAPI     = "[Get] " + Request.RequestUri.ToString();
                Startup._sfAppLogger.Error(logAPI + logMessage);

                return(InternalServerError(ex));
            }

            /*
             * try
             * {
             *  EquipmentModels equipmentModel = new EquipmentModels();
             *  int companyId = equipmentModel.getCompanyId(equipmentId);
             *  DocDB_AlarmMessageModels alarmMessageModel = new DocDB_AlarmMessageModels(companyId);
             *  return Ok(alarmMessageModel.GetByEquipmentId(equipmentId, top, hours, order));
             * }
             * catch (Exception ex)
             * {
             *  StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
             *  string logAPI = "[Get] " + Request.RequestUri.ToString();
             *  Startup._sfAppLogger.Error(logAPI + logMessage);
             *
             *  return InternalServerError(ex);
             * }*/
        }
Beispiel #28
0
        public IHttpActionResult GetCompanyById(int id)
        {
            RedisKey cacheKey   = "company_" + id;
            string   cacheValue = RedisCacheHelper.GetValueByKey(cacheKey);

            if (cacheValue == null)
            {
                CompanyModels companyModel = new CompanyModels();
                try
                {
                    CompanyModels.Detail company = companyModel.getCompanyById(id);
                    RedisCacheHelper.SetKeyValue(cacheKey, new JavaScriptSerializer().Serialize(company));
                    return(Ok(company));
                }
                catch
                {
                    return(NotFound());
                }
            }
            else
            {
                return(Ok(new JavaScriptSerializer().Deserialize <Object>(cacheValue)));
            }
        }
        public IHttpActionResult GetMessageByEquipmentId(string equipmentId, [FromUri] int top = 10, [FromUri] int hours = 168, [FromUri] string order = "desc")
        {
            try
            {
                int companyId = GetCompanyIdFromToken();
                if (!General.IsEquipmentUnderCompany(equipmentId, companyId))
                {
                    return(Unauthorized());
                }

                CompanyModels        companyModel = new CompanyModels();
                CompanyModels.Detail company      = companyModel.getCompanyById(companyId);
                DocumentDBHelper     docDBHelpler = new DocumentDBHelper(companyId, company.DocDBConnectionString);
                return(Ok(docDBHelpler.GetMessageByEquipmentId(equipmentId, top, hours, order, companyId)));
            }
            catch (Exception ex)
            {
                StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
                string        logAPI     = "[Get] " + Request.RequestUri.ToString();
                Startup._sfAppLogger.Error(logAPI + logMessage);

                return(InternalServerError(ex));
            }
        }
Beispiel #30
0
        public IHttpActionResult AddFormData([FromBody] CompanyModels.Add company)
        {
            string logForm = "Form : " + Startup._jsSerializer.Serialize(company);
            string logAPI  = "[Post] " + Request.RequestUri.ToString();

            if (!ModelState.IsValid || company == null)
            {
                Startup._sfAppLogger.Warn(logAPI + " || Input Parameter not expected || " + logForm);
                return(BadRequest("Invalid data"));
            }

            try
            {
                CompanyModels companyModel = new CompanyModels();
                int           id           = companyModel.addCompany(company);
                return(Json(new { id = id }));
            }
            catch (Exception ex)
            {
                StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
                logMessage.AppendLine(logForm);
                Startup._sfAppLogger.Error(logAPI + logMessage);

                return(InternalServerError(ex));
            }

            /*
             * var newCompany = new Company()
             * {
             *  Name = company.Name,
             *  ShortName = company.ShortName,
             *  Address = company.Address,
             *  CompanyWebSite = company.CompanyWebSite,
             *  ContactName = company.ContactName,
             *  ContactPhone = company.ContactPhone,
             *  ContactEmail = company.ContactEmail,
             *  Latitude = (float)company.Latitude,
             *  Longitude = (float)company.Longitude,
             *  CultureInfo = company.CultureInfoId,
             *  CreatedAt = DateTime.Parse(DateTime.Now.ToString()),
             *  DeletedFlag = false
             * };
             *
             *
             *
             * using (var ctx = new SFDatabaseEntities())
             * {
             *  ctx.Company.Add(newCompany);
             *  try
             *  {
             *      ctx.SaveChanges();
             *  }
             *  catch (Exception ex)
             *  {
             *      StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
             *      logMessage.AppendLine(logForm);
             *      Startup._sfAppLogger.Error(logAPI + logMessage);
             *
             *      return InternalServerError(ex);
             *  }
             * }
             * return Json(new { id = newCompany.Id });
             */
        }