public async Task <ActionResult> Save(string listaIds, string user) { string[] arregloIds = listaIds.Split(new char[] { ',' }); InspectionDaily inspectionDaily = null; int id = 0; foreach (var item in arregloIds) { id = int.Parse(item); inspectionDaily = await db.InspectionDaily.FindAsync(id); try { inspectionDaily.IDUser = int.Parse(user); inspectionDaily.DateInspection = DateTime.Now.ToString("MM/dd/yyyy HH:mm"); inspectionDaily.IdStatus = 4; db.Entry(inspectionDaily).State = EntityState.Modified; await db.SaveChangesAsync(); } catch (Exception ex) { TempData["msg"] = "<script>swal('Error', '" + ex.Message + "', 'error');</script>"; return(RedirectToAction("Index")); } } TempData["msg"] = "<script>alert('Change succesfully');</script>"; ViewBag.Userdb = new SelectList(CombosHelper.GetUsersDB(), "IDUser", "FirstName"); ViewBag.IdInspectionStates = new SelectList(db.InspectionStates, "IdStatus", "Description", inspectionDaily.IdStatus); return(RedirectToAction("Index")); }
public async Task <ActionResult> Create(InspectionDaily inspectionDaily) { if (ModelState.IsValid) { var aux = String.Format("0{0}", inspectionDaily.Company); inspectionDaily.Company = aux; inspectionDaily.IdClient = 1; inspectionDaily.IdProject = 1; inspectionDaily.TypeInspection = 1; inspectionDaily.Date = DateTime.Now; inspectionDaily.IdValueCheckList = 70; if (inspectionDaily.IdStatus != 5) { inspectionDaily.IdStatus = 4; } else { inspectionDaily.IdStatus = 5; } inspectionDaily.CommentGeneral = "0"; inspectionDaily.IdAttach = 4; db.InspectionDaily.Add(inspectionDaily); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.DO = new SelectList(Helpers.CombosHelper.GetDistricts(), "NAME", "ABBR"); ViewBag.Company = new SelectList(Helpers.CombosHelper.GetCounties(), "IdCountries", "Description"); ViewBag.IdStatus = new SelectList(db.InspectionStates, "IdStatus", "Description", inspectionDaily.IdStatus); ViewBag.IDUser = new SelectList(db.UserDB, "IDUser", "UserName", inspectionDaily.IDUser); return(View(inspectionDaily)); }
public async Task <ActionResult> DeleteConfirmed(string listaIds) { string[] arregloIds = listaIds.Split(new char[] { ',' }); InspectionDaily inspectionDaily = null; int id = 0; foreach (var item in arregloIds) { id = int.Parse(item); inspectionDaily = await db.InspectionDaily.FindAsync(id); try { db.InspectionDaily.Remove(inspectionDaily); await db.SaveChangesAsync(); } catch (Exception ex) { TempData["msg"] = "<script>swal('Error', '" + ex.Message + "', 'error');</script>"; return(RedirectToAction("Index")); } } TempData["msg"] = "<script>alert('Delete succesfully');</script>"; ViewBag.Userdb = new SelectList(CombosHelper.GetUsersDB(), "IDUser", "FirstName"); ViewBag.IdInspectionStates = new SelectList(db.InspectionStates, "IdStatus", "Description", inspectionDaily.IdStatus); return(RedirectToAction("Index")); }
// GET: InspectionDailies/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } InspectionDaily inspectionDaily = await db.InspectionDaily.FindAsync(id); if (inspectionDaily == null) { return(HttpNotFound()); } return(View(inspectionDaily)); }
public async Task <ActionResult> Edit([Bind(Include = "IdInspection,IDUser,IdClient,IdProject,NumInspection,DO,Company,Control,Section,Address,City,TypeInspection,Scope,Date,Hour,IdValueCheckList,IdStatus,Longitude,Latitude,LongitudeIni,LatitudeIni,DateInspection,CommentGeneral,IdAttach,Sync,LongitudeEnd,LatitudeEnd,DateInspectionEnd,Flag,Structure,MaintanSection,Milepnt")] InspectionDaily inspectionDaily) { if (ModelState.IsValid) { db.Entry(inspectionDaily).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.DO = new SelectList(Helpers.CombosHelper.GetDistricts(), "NAME", "ABBR"); ViewBag.Company = new SelectList(Helpers.CombosHelper.GetCounties(), "IdCountries", "Description"); ViewBag.IdStatus = new SelectList(db.InspectionStates, "IdStatus", "Description", inspectionDaily.IdStatus); ViewBag.IDUser = new SelectList(db.UserDB, "IDUser", "UserName", inspectionDaily.IDUser); return(View(inspectionDaily)); }
// GET: InspectionDailies/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } InspectionDaily inspectionDaily = await db.InspectionDaily.FindAsync(id); if (inspectionDaily == null) { return(HttpNotFound()); } ViewBag.DO = new SelectList(Helpers.CombosHelper.GetDistricts(), "NAME", "ABBR"); ViewBag.Company = new SelectList(Helpers.CombosHelper.GetCounties(), "IdCountries", "Description"); ViewBag.IdStatus = new SelectList(db.InspectionStates, "IdStatus", "Description", inspectionDaily.IdStatus); ViewBag.IDUser = new SelectList(db.UserDB, "IDUser", "UserName", inspectionDaily.IDUser); return(View(inspectionDaily)); }
public ActionResult RowData(HttpPostedFileBase uploadfile) { if (ModelState.IsValid) { if (uploadfile != null && uploadfile.ContentLength > 0) { var dbContextTransaction = db.Database.BeginTransaction(); List <Message> messages = new List <Message>(); //ExcelDataReader works on binary excel file Stream stream = uploadfile.InputStream; //We need to written the Interface. IExcelDataReader reader = null; if (uploadfile.FileName.EndsWith(".xls")) { //reads the excel file with .xls extension reader = ExcelReaderFactory.CreateBinaryReader(stream); } else if (uploadfile.FileName.EndsWith(".xlsx")) { //reads excel file with .xlsx extension reader = ExcelReaderFactory.CreateOpenXmlReader(stream); } else { //Shows error if uploaded file is not Excel file ModelState.AddModelError("File", "This file format is not supported"); return(View()); } var name = uploadfile.FileName.Split('.'); var tmp = name[0]; if (tmp == "Raw Data from District") { //treats the first row of excel file as Coluymn Names //reader.IsFirstRowAsColumnNames = true; //Adding reader data to DataSet() DataSet result = reader.AsDataSet(); //result.Tables[0].Rows[0]. DataContext contex = new DataContext(); //contex.Database.ExecuteSqlCommand("TRUNCATE TABLE RawDatas"); List <RawData> lstrdm = new List <RawData>(); List <InspectionDaily> linspdaily = new List <InspectionDaily>(); IList <RawData> ilstrdm = new List <RawData>(); IList <InspectionDaily> iinspdaily = new List <InspectionDaily>(); int loop = 0; RawData rdt = new RawData(); InspectionDaily inspectiondaily = new InspectionDaily(); try { foreach (DataRow data in result.Tables[0].Rows) { if (loop == 0) { loop++; continue; } rdt.StructureNumber = data[1].ToString(); rdt.District = data[3].ToString(); rdt.County = data[4].ToString(); rdt.Control = data[5].ToString(); bool isLetter = !String.IsNullOrEmpty(rdt.Control) && Char.IsLetter(rdt.Control[0]); rdt.Section = data[6].ToString(); rdt.Milepnt = data[7].ToString(); rdt.StrNo = data[8].ToString(); //rdt.DupRtOver = data[7].ToString(); //rdt.RtStrFunc = data[10].ToString(); //rdt.Blanks1 = data[9].ToString(); // rdt.RtDesign = data[12].ToString(); // rdt.RtBusSfx = data[11].ToString(); // rdt.RtSystem = data[12].ToString(); // rdt.RtNo = data[13].ToString(); // rdt.RtDir = data[14].ToString(); //rdt.BRefMrk = data[15].ToString(); //if (string.IsNullOrEmpty(data[16].ToString())) { rdt.BRefMkSfx = 0; } else { rdt.BRefMkSfx = data[16].ToString()); }; //rdt.BRefMkSfx = data[16].ToString(); // rdt.CIRRfMkSign = data[17].ToString(); // rdt.BRfMkDispl = data[18].ToString(); //rdt.PlaceCode = data[19].ToString(); if (string.IsNullOrEmpty(data[22].ToString())) { rdt.FeatXed = ""; } else { rdt.FeatXed = data[22].ToString(); }; //rdt.CritBdg = data[21].ToString(); // rdt.MiPtDatePr = data[22].ToString(); //rdt.AMiPtDateInt = data[23].ToString(); //rdt.Blanks2 = data[24].ToString(); rdt.FacCarried = data[27].ToString(); rdt.Location = data[28].ToString(); //rdt.RtMinVrtClear = data[27].ToString(); //if (string.IsNullOrEmpty(data[28].ToString())) { rdt.OLD16Latitude = 0; } else { rdt.OLD16Latitude = float.Parse(data[28].ToString()); }; //if (string.IsNullOrEmpty(data[29].ToString())) { rdt.OLD17Longitude = 0; } else { rdt.OLD17Longitude = float.Parse(data[29].ToString()); }; // rdt.DetourLgth = data[30].ToString(); // rdt.Toll = data[31].ToString(); // rdt.Custodian = data[32].ToString(); // rdt.Owner = data[33].ToString(); rdt.MaintSect = data[36].ToString(); //rdt.ProjType = data[35].ToString(); // if (string.IsNullOrEmpty(data[36].ToString())) { rdt.CSJWhnBlt = 0; } else { rdt.CSJWhnBlt = double.Parse(data[36].ToString()); }; //rdt.FuncClass = data[37].ToString(); rdt.YrBuilt = data[40].ToString(); //rdt.LanesOn = data[39].ToString(); //rdt.LanesUnder = data[40].ToString(); //if (string.IsNullOrEmpty(data[41].ToString())) { rdt.AADT = 0; } else { rdt.AADT = double.Parse(data[41].ToString()); }; //rdt.AADTYear = data[42].ToString(); //rdt.DesignLoad = data[43].ToString(); //rdt.ApprWidth = data[44].ToString(); //rdt.Median = data[45].ToString(); //rdt.Skew = data[46].ToString(); //rdt.StrFlared = data[47].ToString(); //rdt.TrfSafeFeat = data[48].ToString(); //rdt.HistSignif = data[49].ToString(); //rdt.NavControls = data[50].ToString(); //rdt.MnNavVrtClear = data[51].ToString(); //rdt.NavHrzClear = data[52].ToString(); //rdt.OperStatus = data[53].ToString(); //rdt.LoadType = data[54].ToString(); //rdt.Load1000lb = data[55].ToString(); //rdt.ServOnUnder = data[56].ToString(); //rdt.MnSpanTy = data[57].ToString(); //rdt.MjAprSpTy = data[58].ToString(); //rdt.MnAprSpTy = data[59].ToString(); //rdt.Culvert = data[60].ToString(); //rdt.TunnelTy = data[61].ToString(); //rdt.SubstrMSpan = data[62].ToString(); //rdt.SubMjAprSp = data[63].ToString(); //rdt.SubMnAprSp = data[64].ToString(); //rdt.NoMSpan = data[65].ToString(); //rdt.NoMjAprSp = data[66].ToString(); //rdt.NoMnAprSp = data[67].ToString(); //rdt.TotalNoSpans = data[68].ToString(); //rdt.TotHrzClear = data[69].ToString(); // rdt.MaxSpLgth = data[70].ToString(); // rdt.StrLgth = data[71].ToString(); //rdt.LtSdwalk = data[72].ToString(); //rdt.RtSdwalk = data[73].ToString(); // rdt.RdwyWidth = data[74].ToString(); // rdt.DeckWidth = data[75].ToString(); //rdt.VrtClrOver = data[76].ToString(); //rdt.VrtClrRefFeat = data[77].ToString(); //rdt.VrtClrUnder = data[78].ToString(); //rdt.LatClrRefFeat = data[79].ToString(); //rdt.RtLatClear = data[80].ToString(); //rdt.LtLatClear = data[81].ToString(); //rdt.Blanks3 = data[82].ToString(); //rdt.DeckCond = data[83].ToString(); //rdt.SuperCond = data[84].ToString(); //rdt.SubstrCond = data[85].ToString(); //rdt.ChanProt = data[86].ToString(); //rdt.Culvert = data[87].ToString(); //rdt.OperRate = data[88].ToString(); //rdt.RdApprCond = data[89].ToString(); //rdt.InvRate = data[90].ToString(); //rdt.StrEval = data[91].ToString(); //rdt.DeckGeom = data[92].ToString(); //rdt.UClrVrtHrz = data[93].ToString(); //rdt.SafeLoadCap = data[94].ToString(); //rdt.WaterwayAdeq = data[95].ToString(); //rdt.ApprRdAlign = data[96].ToString(); //rdt.TyWrkRepl = data[97].ToString(); //if (string.IsNullOrEmpty(data[98].ToString())) { rdt.LgthImprov = 0; } else { rdt.LgthImprov = double.Parse(data[98].ToString()); }; //rdt.SpecFlags = data[99].ToString(); //rdt.FHWAResvd = data[100].ToString(); //rdt.CostImprov1 = data[101].ToString(); if (string.IsNullOrEmpty(data[104].ToString())) { rdt.LastInspec = 0; } else { rdt.LastInspec = double.Parse(data[104].ToString()); }; //rdt.DesInspFreq = data[103].ToString(); //rdt.FracCritDet = data[104].ToString(); //rdt.UndwtrInspec = data[105].ToString(); //rdt.SpecialInspec = data[106].ToString(); //rdt.FracCritDate = data[107].ToString(); //rdt.UwtrInsDate = data[108].ToString(); //rdt.SpecInspDate = data[109].ToString(); //if (string.IsNullOrEmpty(data[110].ToString())) { rdt.BdgImprCost = 0; } else { rdt.BdgImprCost = double.Parse(data[110].ToString()); }; //if (string.IsNullOrEmpty(data[111].ToString())) { rdt.RdImprCost = 0; } else { rdt.RdImprCost = double.Parse(data[111].ToString()); }; //if (string.IsNullOrEmpty(data[112].ToString())) { rdt.TotProjCost = 0; } else { rdt.TotProjCost = double.Parse(data[112].ToString()); }; //rdt.YrImprCostEst = data[113].ToString(); //if (string.IsNullOrEmpty(data[114].ToString())) { rdt.BorderBdg = 0; } else { rdt.BorderBdg = double.Parse(data[114].ToString()); }; //rdt.BorderBdgNo = data[115].ToString(); //rdt.DefHwyDesn = data[116].ToString(); //rdt.ParlStrDesn = data[117].ToString(); //rdt.DirofTraffic = data[118].ToString(); //rdt.TempStrDesn = data[119].ToString(); //rdt.NHS = data[120].ToString(); //rdt.OldFAU = data[121].ToString(); //rdt.FHWAResvd_105 = data[121].ToString(); //rdt.YrReconstr = data[122].ToString(); //rdt.WidenCode = data[124].ToString(); //rdt.DeckTyMSp = data[125].ToString(); //rdt.MSpWrSurf = data[126].ToString(); //rdt.DeckMjAprSp = data[127].ToString(); //rdt.MjAprSpWrSrf = data[128].ToString(); //rdt.DkMnAprSp = data[129].ToString(); //rdt.MnAprSpWrSrf = data[130].ToString(); //rdt.AADTTruckPct = data[131].ToString(); //rdt.DesNatlNtwk = data[132].ToString(); //rdt.PierProtect = data[133].ToString(); //rdt.NBIBdgLgth = data[134].ToString(); //rdt.ScourCrit = data[135].ToString(); //if (string.IsNullOrEmpty(data[136].ToString())) { rdt.FutureAADT = 0; } else { rdt.FutureAADT = double.Parse(data[136].ToString()); }; //rdt.FutAADTYear = data[137].ToString(); //rdt.MnNavVrtClear = data[138].ToString(); //rdt.OrigCost = data[139].ToString(); //rdt.DefObs = data[140].ToString(); //if (string.IsNullOrEmpty(data[141].ToString())) { rdt.SuffRate = 0; } else { rdt.SuffRate = double.Parse(data[141].ToString()); }; //rdt.XrefPrinRtID = data[142].ToString(); //rdt.XrfStrFncPRt = data[143].ToString(); //rdt.SuffRatFlag = data[144].ToString(); //rdt.ScourVuln = data[145].ToString(); //rdt.OvHtLoadDmg = data[146].ToString(); //rdt.Blanks4 = data[147].ToString(); //rdt.XRfIRID = data[148].ToString(); //rdt.XRfIRStrFunc = data[149].ToString(); //rdt.Blanks5 = double.Parse(data[150].ToString()); //rdt.DistUse = data[151].ToString(); //rdt.AIRControl = data[152].ToString(); //rdt.AIRSection = data[153].ToString(); //rdt.AIRMilept = data[154].ToString(); //rdt.AIRStrNo = data[155].ToString(); //rdt.AIRDuplOver = data[156].ToString(); //rdt.AIRStrFunct = data[157].ToString(); //rdt.AIRDesignation = data[158].ToString(); //rdt.AIRBusSfx = data[159].ToString(); //rdt.AIRHwySys = data[160].ToString(); //rdt.AIRHwyNo = data[161].ToString(); //rdt.AIRDir = data[162].ToString(); //rdt.CIRRefMrk = data[163].ToString(); //rdt.CIRRefMkSfx = data[164].ToString(); //rdt.CIRRfMkSign = data[165].ToString(); //rdt.CIRRfMkDispl = data[166].ToString(); //rdt.AIRHrzClear = data[167].ToString(); //rdt.AIRMnVrtClear = data[168].ToString(); //rdt.AIRBypsLgth = data[169].ToString(); //rdt.AIRToll = data[170].ToString(); //rdt.AIRFuncClass = data[171].ToString(); //rdt.AIRAADT = data[172].ToString(); //rdt.AIRAADTYr = data[173].ToString(); //rdt.AIRDefHwyDes = data[174].ToString(); //rdt.AIRParlStr = data[175].ToString(); //rdt.AIRTrafDir = data[176].ToString(); //rdt.AIRTempStr = data[177].ToString(); //rdt.AIRNHS = data[178].ToString(); //rdt.OldFAU = data[179].ToString(); //rdt.AIRAADTTrkPct = data[180].ToString(); //rdt.AIRNatlNtwk = data[181].ToString(); //rdt.AIRFutAADT = data[182].ToString(); //rdt.AIRFAADTYr = data[183].ToString(); //rdt.Blanks6 = data[184].ToString(); //rdt.FHWAStrEval = data[185].ToString(); //rdt.FHWADkGeom = data[186].ToString(); //rdt.FHWAUClrVrtHrz = data[187].ToString(); //rdt.BaseHwyNet = data[188].ToString(); //rdt.LRSInvRte = data[189].ToString(); //rdt.LRSSubRte = data[190].ToString(); //rdt.Blanks7 = data[191].ToString(); if (string.IsNullOrEmpty(data[194].ToString())) { rdt.GPSLatitude = 0; } else { rdt.GPSLatitude = double.Parse(data[194].ToString()); }; //rdt.Blanks8 = data[193].ToString(); if (string.IsNullOrEmpty(data[196].ToString())) { rdt.GPSLongitude = 0; } else { rdt.GPSLongitude = double.Parse(data[196].ToString()); }; //rdt.GPSColMeth = data[195].ToString(); //rdt.MethOperRate = data[196].ToString(); //rdt.MethInvRate = data[197].ToString(); //rdt.FedLand = data[198].ToString(); if (string.IsNullOrEmpty(data[201].ToString())) { rdt.Latitude = 0; } else { rdt.Latitude = double.Parse(data[201].ToString()); }; if (string.IsNullOrEmpty(data[202].ToString())) { rdt.Longitude = 0; } else { rdt.Longitude = double.Parse(data[202].ToString()); }; //rdt.AIRBaseHwyNet = data[201].ToString(); //rdt.AIRLRSInvRte = data[202].ToString(); //rdt.AIRLRSSubRte = data[203].ToString(); //rdt.Blanks9 = data[204].ToString(); //inspectiondaily.IdClient = 1; //inspectiondaily.IDUser = 1; //if (isLetter) //{ // inspectiondaily.IdProject = 2; //} //else //{ // inspectiondaily.IdProject = 1; //} //// var idproject = validarcontrol(rdt.Control); ////inspectiondaily.IdProject = idproject; ////var numinsp = String.Format("{0}-{1}-{2}-{3}-{4}", rdt.District, rdt.County, rdt.Control, rdt.Section, rdt.StrNo); //string numinspaux = data[1].ToString(); //var numinsp = String.Format("{0}-{1}-{2}-{3}-{4}", numinspaux.Substring(0,2), numinspaux.Substring(2, 3), numinspaux.Substring(6, 4), numinspaux.Substring(10, 2), numinspaux.Substring(12)); //var exist = db.InspectionDaily.Where(i => i.NumInspection == numinsp).FirstOrDefault(); ////if (exist != null) ////{ message.mensaje = "La inpeccion ya se encuentra registrada "; message.fila = loop; break; } //inspectiondaily.NumInspection = numinsp; //inspectiondaily.DO = rdt.District; //inspectiondaily.Company = rdt.County; //inspectiondaily.Control = rdt.Control; //inspectiondaily.Section = rdt.Section; //inspectiondaily.Scope = rdt.FeatXed; //inspectiondaily.IdValueCheckList = 70; //inspectiondaily.IdAttach = 4; //inspectiondaily.Hour = rdt.YrBuilt; //inspectiondaily.IdStatus = 5; //inspectiondaily.City = rdt.FacCarried; //inspectiondaily.TypeInspection = 1; //inspectiondaily.Address = rdt.Location; //inspectiondaily.LatitudeIni = rdt.GPSLatitude; //inspectiondaily.LongitudeIni = rdt.GPSLongitude; //inspectiondaily.Structure = rdt.StrNo; //inspectiondaily.MaintanSection = rdt.MaintSect; //inspectiondaily.Milepnt = rdt.Milepnt; //inspectiondaily.Owner = rdt.Owner; /// //contex = contex.BulkInsert(inspectiondaily, loop, 100); db.RawData.Add(rdt); //db.InspectionDaily.Add(inspectiondaily); db.SaveChanges(); //db2.SaveChanges(); loop++; } //contex.SaveChanges(); } catch (Exception ex) { dbContextTransaction.Rollback(); reader.Close(); Message message1 = new Message(); message1.mensaje = ex.InnerException.InnerException.ToString(); if (message1.mensaje.Contains("duplicate key")) { ViewBag.Script = "<script type='text/javascript'>swal('¡Alert!', 'inspection duplicate in row " + loop + "', 'error');</script>"; } ViewBag.Files = new SelectList(CombosHelper.GetFiles(), "Value", "Text"); return(View("LoadData")); } dbContextTransaction.Commit(); reader.Close(); //Sending result data to View return(RedirectToAction("Index", "InspectionDailies")); } else if (tmp == "Configuration Checklist") { DataSet result = reader.AsDataSet(); DataContext contex = new DataContext(); //contex.Database.ExecuteSqlCommand("TRUNCATE TABLE RawDatas"); DataTable dt = result.Tables[0]; var idProject = dt.Rows[0][1]; } else if (tmp == "Detailed Work Schedule") { var contar = 0; var raw = db.RawData; if (raw.ToList().Count() == 0) { ViewBag.Script = "<script type='text/javascript'>swal('¡Alert!', 'First you need load Row Data','error');</script>"; ViewBag.Files = new SelectList(CombosHelper.GetFiles(), "Value", "Text"); return(View("LoadData")); } List <Message> messages1 = new List <Message>(); RawData rowdt = null; DataSet result = reader.AsDataSet(); //result.Tables[0].Rows[0]. DataContext contex = new DataContext(); //contex.Database.ExecuteSqlCommand("TRUNCATE TABLE RawDatas"); List <InspectionDaily> linspdaily = new List <InspectionDaily>(); IList <InspectionDaily> iinspdaily = new List <InspectionDaily>(); InspectionDaily inspectiondaily = new InspectionDaily(); int loop = 0; var bandera = true; var coun = db.RawData; if (coun != null) { try { foreach (DataRow data in result.Tables[0].Rows) { if (loop == 0) { loop++; continue; } var StructureNumber = data[0].ToString(); rowdt = db.RawData.Where(r => r.StructureNumber == StructureNumber) .FirstOrDefault(); if (rowdt == null) { Message message = new Message(); message.fila = loop; message.mensaje = "The inspection " + StructureNumber + " is new"; loop++; messages1.Add(message); bandera = true; continue; } else { inspectiondaily.IdClient = 1; inspectiondaily.IDUser = 1; inspectiondaily.IdProject = 1; //if (isLetter) //{ // inspectiondaily.IdProject = 2; //} //else //{ // inspectiondaily.IdProject = 1; //} var idproject = validarcontrol(rowdt.Control); inspectiondaily.IdProject = idproject; var numinsp = String.Format("{0}-{1}-{2}-{3}-{4}", rowdt.StructureNumber.Substring(0, 2), rowdt.StructureNumber.Substring(2, 3), rowdt.StructureNumber.Substring(6, 4), rowdt.StructureNumber.Substring(10, 2), rowdt.StructureNumber.Substring(12)); var exist = db.InspectionDaily.Where(i => i.NumInspection == numinsp).FirstOrDefault(); Message message = new Message(); if (exist != null) { message.fila = loop; message.mensaje = "The inspection " + StructureNumber + " was load before "; loop++; messages1.Add(message); continue; } inspectiondaily.NumInspection = numinsp; inspectiondaily.DO = rowdt.District; inspectiondaily.Company = rowdt.County; inspectiondaily.Control = rowdt.Control; inspectiondaily.Section = rowdt.Section; inspectiondaily.Scope = rowdt.FeatXed; inspectiondaily.IdValueCheckList = 70; inspectiondaily.IdAttach = 4; inspectiondaily.Hour = rowdt.YrBuilt; inspectiondaily.IdStatus = 5; inspectiondaily.City = rowdt.FacCarried; inspectiondaily.TypeInspection = 1; inspectiondaily.Address = rowdt.Location; inspectiondaily.LatitudeIni = rowdt.GPSLatitude; inspectiondaily.LongitudeIni = rowdt.GPSLongitude; inspectiondaily.Structure = rowdt.StrNo; inspectiondaily.MaintanSection = rowdt.MaintSect; inspectiondaily.Milepnt = rowdt.Milepnt; inspectiondaily.Owner = rowdt.Owner; db.InspectionDaily.Add(inspectiondaily); db.SaveChanges(); contar++; loop++; } } Message message2 = new Message(); message2.mensaje = "Loaded " + contar + " inspections"; messages1.Add(message2); if (bandera) { dbContextTransaction.Commit(); reader.Close(); ViewBag.ok = JsonConvert.SerializeObject(messages1); //ViewBag.Script = "<script type='text/javascript'>swal('¡info!', '" + messages.ToList() + "','error');</script>"; ViewBag.Files = new SelectList(CombosHelper.GetFiles(), "Value", "Text"); return(View("LoadData")); } else { ViewBag.Script = "<script type='text/javascript'>swal('¡Alert!', 'No data found','error');</script>"; ViewBag.Files = new SelectList(CombosHelper.GetFiles(), "Value", "Text"); return(View("LoadData")); } } catch (Exception ex) { dbContextTransaction.Rollback(); reader.Close(); var mensaje = ex.InnerException.InnerException.ToString(); if (mensaje.Contains("duplicate key")) { } else { ViewBag.Script = "<script type='text/javascript'>swal('¡Alert!', 'Error " + ex.Message + "', 'error');</script>"; } ViewBag.Files = new SelectList(CombosHelper.GetFiles(), "Value", "Text"); return(View("LoadData")); } } else { ViewBag.Script = "<script type='text/javascript'>swal('¡Alert!', 'First you need load Row Data', 'error');</script>"; ViewBag.Files = new SelectList(CombosHelper.GetFiles(), "Value", "Text"); return(View("LoadData")); } return(RedirectToAction("Index", "InspectionDailies")); } } } else { ModelState.AddModelError("File", "Please upload your file"); } ViewBag.Files = new SelectList(CombosHelper.GetFiles(), "Value", "Text"); return(RedirectToAction("LoadData", "RawDatas")); //return View(); }