public void AddStage(projectxstage stage)
{
System.Diagnostics.Debug.WriteLine("print1");
System.Diagnostics.Debug.WriteLine(stage.s_name);
NpgsqlConnection myConnection = new NpgsqlConnection();
System.Diagnostics.Debug.WriteLine("print2");
myConnection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
System.Diagnostics.Debug.WriteLine("print3");
System.Diagnostics.Debug.WriteLine("cargo base");
string test = "INSERT INTO projectxstage(p_id,s_name, pxs_datestart, pxs_dateend,pxs_status) Values(:p_id,:s_name,:pxs_datestart,:pxs_dateend,:pxs_status)";
var command = new NpgsqlCommand(test, myConnection);
command.CommandType = CommandType.Text;
System.Diagnostics.Debug.WriteLine("print5");
System.Diagnostics.Debug.WriteLine("generando comando");
command.Parameters.AddWithValue(":p_id", stage.p_id);
command.Parameters.AddWithValue(":s_name", stage.s_name);
command.Parameters.AddWithValue(":pxs_status", stage.pxs_status);
command.Parameters.AddWithValue(":pxs_datestart", stage.pxs_datestart);
command.Parameters.AddWithValue(":pxs_dateend", stage.pxs_dateend);
myConnection.Open();
command.ExecuteNonQuery();
System.Diagnostics.Debug.WriteLine("print6");
myConnection.Close();
}
public JsonResult <List <projectxstage> > Get(string attribute, string id)
{
projectxstage stage = null;
List <projectxstage> values = new List <projectxstage>();
string[] attr = attribute.Split(',');
string[] ids = id.Split(',');
System.Diagnostics.Debug.WriteLine("print1");
NpgsqlConnection myConnection = new NpgsqlConnection();
System.Diagnostics.Debug.WriteLine("print2");
myConnection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
System.Diagnostics.Debug.WriteLine("print3");
System.Diagnostics.Debug.WriteLine("cargo base");
myConnection.Open();
string action = "";
if (id != "undefined")
{
var need = new ProjectController();
action = need.FormConnectionString("projectxstage", attr, ids);
}
else
{
action = "SELECT * FROM projectxstage;";
}
System.Diagnostics.Debug.WriteLine("print4");
System.Diagnostics.Debug.WriteLine(action);
var command = new NpgsqlCommand(action, myConnection);
System.Diagnostics.Debug.WriteLine("print5");
var coso = command.ExecuteReader();
System.Diagnostics.Debug.WriteLine("print6");
while (coso.Read())
{
stage = new projectxstage();
stage.pxs_id = (int)coso["pxs_id"];
stage.pxs_status = (string)coso["pxs_status"];
stage.p_id = (int)coso["p_id"];
stage.s_name = (string)coso["s_name"];
stage.pxs_datestart = (DateTime)coso["pxs_datestart"];
stage.pxs_dateend = (DateTime)coso["pxs_dateend"];
stage.pxs_budget = (int)coso["pxs_budget"];
values.Add(stage);
}
myConnection.Close();
return(Json(values));
}
