public ProductsModel GetAll() { var productsList = new List <tblProduct>(); ProductsModel model = new ProductsModel(); using (var db = new chemicalsEntities()) { var products = db.tblProducts; model.productsList = products; } return(model); }
public ActionResult Index(int startIndex, int pageSize) { try { using (var db = new chemicalsEntities()) { var products = db.tblProducts.OrderBy(p => p.Id).Skip(startIndex).Take(pageSize).ToList(); return(View(products)); } } catch (Exception ex) { ViewBag.FileStatus = "Exception happened server could not be contacted !! Very Sorry"; return(View()); } }
public ActionResult Open(int Id) { try { using (var db = new chemicalsEntities()) { tblProduct record = db.tblProducts.ToList().FirstOrDefault(p => p.Id == Id); if (record.FileContent != null) { return(File(record.FileContent, "application/pdf", record.FilePath)); } else { ViewBag.FileStatus = "File Not Found"; return(View()); } } } catch (Exception ex) { ViewBag.FileStatus = "Exception happened server could not be contacted !! Very Sorry"; return(View()); } }
public async Task <ActionResult> Browse(int Id, string productName, string productUrl) { try { ViewBag.Message = productName; ViewBag.Message2 = productUrl; var fileName = productName; //var path = String.Format(@"{0}DataSheets\", AppDomain.CurrentDomain.BaseDirectory); var path = @"~\DataSheets\"; ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12; HttpClient client = new HttpClient(); Uri _uri = new Uri(productUrl); client.BaseAddress = _uri; await client.GetAsync(_uri.LocalPath); client.DefaultRequestHeaders.Clear(); var responce = client.GetAsync(_uri.LocalPath); responce.Wait(); byte[] result = await responce.Result.Content.ReadAsByteArrayAsync(); string totPath = fileName; if (!string.IsNullOrEmpty(path)) { string Folder = Server.MapPath(path); totPath = Path.Combine(Folder, fileName); } bool isPdfFile = false; if (responce.Result.StatusCode == HttpStatusCode.OK) { string contentType = ""; if (responce.Result.Content.Headers.ContentType.MediaType.ToString() == "application/pdf") { contentType = "application/pdf"; fileName = fileName + ".pdf"; isPdfFile = true; } else if (responce.Result.Content.Headers.ContentType.MediaType.ToString() == "text/html") { contentType = "text/html"; fileName = fileName + ".text"; isPdfFile = false; } using (var db = new chemicalsEntities()) { tblProduct record = db.tblProducts.ToList().FirstOrDefault(p => p.Id == Id); record.FilePath = fileName; record.IsAvailable = isPdfFile; record.FileContent = result; db.Entry(record).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } FileContentResult fileContentResult = File(result, contentType, fileName); ViewBag.FileStatus = "File Saved Success :)"; //return View(); return(fileContentResult); } else { using (var db = new chemicalsEntities()) { tblProduct record = db.tblProducts.ToList().FirstOrDefault(p => p.Id == Id); record.FilePath = fileName; record.IsAvailable = false; db.Entry(record).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } ViewBag.FileStatus = "File Not Found !! Very Sorry"; return(View()); } } catch (Exception ex) { ViewBag.FileStatus = "Exception happened server could not be contacted !! Very Sorry"; return(View()); } }