public List <Entities.Estado> ListarEstados(InglesIndividual.Entities.JQXGridSettings settings, int claPais, string nomEstado)
{
List <Entities.Estado> list = new List <Entities.Estado>();
DataEntities.SpEstadosGrd sp = new DataEntities.SpEstadosGrd();
sp.ClaPais = claPais;
sp.NomEstado = nomEstado;
this.ConfigurePagedStoredProcedure(sp, settings);
DataTable dt = sp.GetDataTable(this.ConnectionString);
foreach (DataRow dr in dt.Rows)
{
Entities.Estado item = new Entities.Estado(true);
item.ID = Utils.GetDataRowValue(dr, "ClaEstado", 0);
item.Nombre = Utils.GetDataRowValue(dr, "NomEstado", "");
item.Pais = new Entities.Pais();
item.Pais.ID = Utils.GetDataRowValue(dr, "ClaPais", 0);
this.SetWebEntityGridValues(item, dr);
list.Add(item);
}
return(list);
}
public static string GetEntityForEdition(string id)
{
System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
Business.Estados bo = new Business.Estados();
Entities.Estado entity = new Entities.Estado();
entity.ID = Utils.IsNull(id, 0);
entity.SetFromDataSource(true);
bo.PrepareEntityForEdition(entity);
return(js.Serialize(entity));
}
public static void Delete(Entities.Estado Estado)
{
if (Estado != null)
{
SyntexLocal.Delete <Entities.Estado>(Estado.ID.ToString());
}
else
{
SyntexLocal.Delete <Entities.Estado>(string.Empty);
}
}
public override int Delete(Entity entity, DataTransaction tran)
{
Entities.Estado item = entity as Entities.Estado;
DataEntities.SpEstadosDel
sp = new DataEntities.SpEstadosDel();
sp.ClaEstado = item.ID;
if (tran != null)
{
return(sp.ExecuteNonQuery(tran));
}
else
{
return(sp.ExecuteNonQuery(this.ConnectionString));
}
}
public override int Insert(Entity entity, DataTransaction tran)
{
Entities.Estado item = entity as Entities.Estado;
DataEntities.SpEstadosIns
sp = new DataEntities.SpEstadosIns();
//Aqui batallé D:
sp.ClaEstado = item.ID;
sp.ClaPais = item.Pais.ID;
if (tran != null)
{
return(sp.ExecuteNonQuery(tran));
}
else
{
return(sp.ExecuteNonQuery(this.ConnectionString));
}
}
public List <Entities.Estado> Combo(int claPais)
{
List <Entities.Estado> list = new List <Entities.Estado>();
DataEntities.SpEstadosSel sp = new DataEntities.SpEstadosSel();
sp.ClaPais = claPais;
sp.ClaEstado = -1;
DataTable dt = sp.GetDataTable(this.ConnectionString);
foreach (DataRow dr in dt.Rows)
{
Entities.Estado item = new Entities.Estado(true);
item.ID = Utils.GetDataRowValue(dr, "ClaEstado", 0);
item.Nombre = Utils.GetDataRowValue(dr, "NomEstado", "");
this.SetWebEntityGridValues(item, dr);
list.Add(item);
}
return(list);
}
public static List <Entities.Estado> SelectAllEstado()
{
var conn = GetConnection();
try
{
var estados = new List <Entities.Estado>();
SqlCommand command = new SqlCommand("SELECT ID,NOMBRE,FECHA_ALTA FROM ESTADO", conn);
command.CommandType = CommandType.Text;
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var estado = new Entities.Estado();
estado.ID = Convert.ToInt32(reader["ID"].ToString());
estado.Nombre = reader["NOMBRE"].ToString();
estado.FechaAlta = Convert.ToDateTime(reader["FECHA_ALTA"].ToString());
estados.Add(estado);
}
}
return(estados);
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
public List <Exception> Eliminar(string[] ids)
{
List <Exception> list = new List <Exception>();
if (ids != null && ids.Length > 0)
{
foreach (string id in ids)
{
Entities.Estado item = new Entities.Estado(true);
item.ID = Utils.IsNull(id, 0);
try
{
this.Data.Delete(item);
}
catch (Exception ex)
{
list.Add(ex);
}
}
}
return(list);
}
public static void Update(Entities.Estado Estado)
{
SyntexLocal.Update(Estado);
}
public static List <Entities.Estado> Select(Entities.Estado Estado)
{
return(SyntexLocal.Select <Entities.Estado>());
}
public static void Insert(Entities.Estado Estado)
{
SyntexLocal.Insert(Estado);
}
