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();
}
