public int DeleteData(FAMA.AP.Model.Maquina objMaquina) { SqlConnection oCon = null; int result = -1; try { using (oCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConn"].ToString())) { SqlCommand cmd = new SqlCommand("PR_AP_Del_ProcessType", oCon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@IdProcessType", objMaquina.idMachineType); oCon.Open(); result = int.Parse(cmd.ExecuteScalar().ToString()); return(result); } } catch (Exception ex) { return(result); } finally { oCon.Close(); oCon.Dispose(); } }
public int InsertData(FAMA.AP.Model.Maquina objMaquina) { SqlConnection oCon = null; int result = -1; try { using (oCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConn"].ToString())) { SqlCommand cmd = new SqlCommand("PR_AP_INS_PROCESS_TYPE", oCon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@vcName", objMaquina.vcName); cmd.Parameters.AddWithValue("@vcDescription", objMaquina.vcDescription); cmd.Parameters.AddWithValue("@vcDescription", objMaquina.bActivo); oCon.Open(); result = int.Parse(cmd.ExecuteNonQuery().ToString()); return(result); } } catch (Exception ex) { return(result); } finally { oCon.Close(); oCon.Dispose(); } }
public string UpdateData(FAMA.AP.Model.Maquina objMaquina) { SqlConnection oCon = null; string result = ""; try { using (oCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConn"].ToString())) { SqlCommand cmd = new SqlCommand("PR_AP_UPD_PROCESS_TYPE", oCon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@idProcessType", objMaquina.idMachineType); cmd.Parameters.AddWithValue("@vcName", objMaquina.vcName); cmd.Parameters.AddWithValue("@vcDescription", objMaquina.vcDescription); cmd.Parameters.AddWithValue("@vcDescription", objMaquina.bActivo); oCon.Open(); result = cmd.ExecuteNonQuery().ToString(); return(result); } } catch (Exception ex) { return(result = ex.ToString()); } finally { oCon.Close(); } }
public List <FAMA.AP.Model.Maquina> Selectalldata() { SqlConnection oCon = null; DataSet ds = null; List <FAMA.AP.Model.Maquina> MaquinasList = null; try { oCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConn"].ToString()); SqlCommand cmd = new SqlCommand("PR_AP_SEL_MACHINE_TYPE", oCon); cmd.CommandType = CommandType.StoredProcedure; oCon.Open(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; ds = new DataSet(); da.Fill(ds); MaquinasList = new List <FAMA.AP.Model.Maquina>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { FAMA.AP.Model.Maquina uobj = new FAMA.AP.Model.Maquina(); uobj.idMachineType = int.Parse(ds.Tables[0].Rows[i]["idMachineType"].ToString()); uobj.vcName = ds.Tables[0].Rows[i]["vcName"].ToString(); uobj.vcDescription = ds.Tables[0].Rows[i]["vcDescription"].ToString(); uobj.bActivo = Convert.ToBoolean(ds.Tables[0].Rows[i]["bActivo"].ToString()); MaquinasList.Add(uobj); } return(MaquinasList); } catch { return(MaquinasList); } finally { oCon.Close(); } }