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