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