Beispiel #1
0
        public ActionResult Upload(HttpPostedFileBase upload)
        {
            if (ModelState.IsValid)
            {
                if (upload != null && upload.ContentLength > 0)
                {
                    if (upload.FileName.EndsWith(".csv"))
                    {
                        Stream    stream   = upload.InputStream;
                        DataTable csvTable = new DataTable();
                        using (CsvReader csvReader =
                                   new CsvReader(new StreamReader(stream), true))
                        {
                            csvTable.Load(csvReader);
                        }

                        foreach (DataRow row in csvTable.Rows)
                        {
                            foreach (DataColumn col in csvTable.Columns)
                            {
                                int i = 0;

                                string colData          = row[i].ToString();
                                string colDataFormatted = colData.Replace("\"", "");

                                var stringArray = colDataFormatted.Split(',');

                                InfectedData data = new InfectedData()
                                {
                                    Idade           = int.Parse(stringArray[0]),
                                    Sexo            = stringArray[1],
                                    TpPaciente      = stringArray[2],
                                    Bairro          = stringArray[3],
                                    DataInclusao    = getDatetimeFromString(stringArray[4]),
                                    DataNotificacao = getDatetimeFromString(stringArray[5]),
                                    DataRecuperacao = getDatetimeFromString(stringArray[6]),
                                    DataObito       = getDatetimeFromString(stringArray[7]),
                                };

                                db.InfectedDatas.Add(data);
                                i++;
                            }
                        }

                        db.SaveChangesAsync();
                        return(View(csvTable));
                    }
                    else
                    {
                        ModelState.AddModelError("Arquivo", "Formato do arquivo não é suportado");
                        return(View());
                    }
                }
                else
                {
                    ModelState.AddModelError("Arquivo", "Faça o Upload do arquivo");
                }
            }
            return(View());
        }
        public ActionResult DeleteConfirmed(int id)
        {
            InfectedData infectedData = db.InfectedDatas.Find(id);

            db.InfectedDatas.Remove(infectedData);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "ID,Idade,Sexo,TpPaciente,Bairro,DataInclusao,DataNotificacao,DataRecuperacao,DataObito")] InfectedData infectedData)
 {
     if (ModelState.IsValid)
     {
         db.Entry(infectedData).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(infectedData));
 }
        public ActionResult Create([Bind(Include = "ID,Idade,Sexo,TpPaciente,Bairro,DataInclusao,DataNotificacao,DataRecuperacao,DataObito")] InfectedData infectedData)
        {
            if (ModelState.IsValid)
            {
                db.InfectedDatas.Add(infectedData);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(infectedData));
        }
        // GET: InfectedDatas/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            InfectedData infectedData = db.InfectedDatas.Find(id);

            if (infectedData == null)
            {
                return(HttpNotFound());
            }
            return(View(infectedData));
        }