/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public f_ferias getObjectf_ferias(System.String myID)
{
f_ferias myf_ferias = new f_ferias();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT gid,id,comuna,nombre,desde,hasta,dia_1,dia_2,the_geom FROM f_ferias WHERE (the_geom='" + myID + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myf_ferias.gid = Convert.ToInt32(myReader[0]);
myf_ferias.id = Convert.ToInt32(myReader[1]);
myf_ferias.comuna = myReader[2].ToString();
myf_ferias.nombre = myReader[3].ToString();
myf_ferias.desde = myReader[4].ToString();
myf_ferias.hasta = myReader[5].ToString();
myf_ferias.dia_1 = myReader[6].ToString();
myf_ferias.dia_2 = myReader[7].ToString();
myf_ferias.the_geom = myReader[8].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(myf_ferias);
}
/// <summary>
/// modify a record
/// </summary>
public void Update(f_ferias myf_ferias)
{
CnxBase myBase = new CnxBase();
string reqSQL = "UPDATE f_ferias SET gid=" + myf_ferias.gid + ",id=" + myf_ferias.id + ",comuna='" + myf_ferias.comuna + "',nombre='" + myf_ferias.nombre + "',desde='" + myf_ferias.desde + "',hasta='" + myf_ferias.hasta + "',dia_1='" + myf_ferias.dia_1 + "',dia_2='" + myf_ferias.dia_2 + "',the_geom='" + myf_ferias.the_geom + "' WHERE (the_geom=" + myf_ferias.the_geom + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
}
/// <summary>
/// add a record
/// </summary>
/// <param name="myID"></param>
public void Insert(f_ferias myf_ferias)
{
CnxBase myBase = new CnxBase();
string reqSQL = "INSERT INTO f_ferias (gid,id,comuna,nombre,desde,hasta,dia_1,dia_2,the_geom) VALUES (" + myf_ferias.gid + "," + myf_ferias.id + ",'" + myf_ferias.comuna + "','" + myf_ferias.nombre + "','" + myf_ferias.desde + "','" + myf_ferias.hasta + "','" + myf_ferias.dia_1 + "','" + myf_ferias.dia_2 + "','" + myf_ferias.the_geom + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
}