public ActionResult IncluirSurdoMapaJson(string IdMapa, string SelectIdSurdo) { MapaSurdo ObjMS = new MapaSurdo(); ObjMS.idMapa = Convert.ToInt32(IdMapa); string[] Mapalinha = SelectIdSurdo.Split('|'); var nome = Mapalinha[0].ToString(); var bairro = Mapalinha[1].ToString(); ObjMS.idSurdo = dbMpContex.Surdo.Where(s => s.bairro.Trim().Contains(bairro.Trim()) && s.nome.Trim().Contains(nome.Trim())).Select(s => s.id).First(); dbMpContex.MapaSurdo.Add(ObjMS); dbMpContex.SaveChanges(); string listbairros = "'SÃO MATEUS','SANTA LUZIA','SANTA CLARA','S','RIACHO SUJO','MONTE','PALESTINA','ITAPIPOCA','PENTECOSTE','ALTO GUARAMIRANGA','BOA VISTA','CAMPINAS','CAN','CANIDEZINHO','IMACULADA CONC.','JOAO PAULO II'"; ViewBag.SelectIdSurdo = from s in dbMpContex.Surdo where !dbMpContex.MapaSurdo.Any(ms => (ms.idSurdo == s.id)) && (!listbairros.Contains(s.bairro)) orderby s.nome select new { s.id, nome = s.nome + " | " + s.bairro }; var idMapaPar = Convert.ToInt32(IdMapa); ViewBag.IdMapa = Convert.ToInt32(IdMapa); return(Json("OK")); }
void CarregaMapaSurdoScript() { int counter = 0; string line; System.IO.StreamReader file = new System.IO.StreamReader(@"C:\Users\dp\Documents\Sistemas\LsMapasNet\LsMapasNet\arquivos\scriptMapaSurdo.txt"); //System.IO.StreamReader file = new System.IO.StreamReader(@"C:\Sistemas\LsMapasNet\LsMapasNet\arquivos\scriptMapaSurdo.txt"); while ((line = file.ReadLine()) != null) { MapaSurdo ObjMapaSurdo = new MapaSurdo(); string[] Mapalinha = line.Split('|'); //ObjMapaSurdo.id = Convert.ToInt32(Mapalinha[0]); ObjMapaSurdo.idMapa = Convert.ToInt32(Mapalinha[1]); ObjMapaSurdo.idSurdo = Convert.ToInt32(Mapalinha[2]); try { dbMpContex.MapaSurdo.Add(ObjMapaSurdo); dbMpContex.SaveChanges(); } catch (Exception ex) { counter++; } counter++; } }
public ActionResult Migracao(string ListaMapa, string ListaMapaMigracao) { try { if (!string.IsNullOrEmpty(ListaMapa) && !string.IsNullOrEmpty(ListaMapaMigracao)) { int idmaparet = Convert.ToInt32(ListaMapa); int idmapaMigracao = Convert.ToInt32(ListaMapaMigracao); var ListRetSurdo = dbMpContex.MapaSurdo.Where(ms => ms.idMapa == idmaparet).ToList(); foreach (var item in ListRetSurdo) { MapaSurdo ObjMapaSurdo = new MapaSurdo(); ObjMapaSurdo.idMapa = idmapaMigracao; ObjMapaSurdo.idSurdo = item.idSurdo; dbMpContex.MapaSurdo.Add(ObjMapaSurdo); dbMpContex.SaveChanges(); } dbMpContex.Database.ExecuteSqlCommand("DELETE FROM mapasurdo where idmapa = {0}", idmaparet); dbMpContex.SaveChanges(); dbMpContex.Database.ExecuteSqlCommand("Delete From mapas where id = {0}", idmaparet); dbMpContex.SaveChanges(); return(RedirectToAction("index")); } ViewBag.Erro = "Dados informados em branco"; return(View()); } catch (Exception ex) { ViewBag.Erro = ex.Message.ToString(); return(View()); } }