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