// GET: subJobTypes public ActionResult Index() { List <tbl_subJobTypes> subJobTypes = new List <tbl_subJobTypes>(); string mainconn = ConfigurationManager.ConnectionStrings["allpaxServiceRecordEntities"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); sqlconn.Open(); string sqlquery1 = "SELECT tbl_subJobTypes.subJobID, tbl_subJobTypes.description " + "FROM tbl_subJobTypes"; SqlCommand sqlcomm1 = new SqlCommand(sqlquery1, sqlconn); SqlDataAdapter sda1 = new SqlDataAdapter(sqlcomm1); DataTable dt1 = new DataTable(); sda1.Fill(dt1); foreach (DataRow dr1 in dt1.Rows) { tbl_subJobTypes subJobType = new tbl_subJobTypes(); subJobType.subJobID = (byte)dr1[0]; subJobType.description = dr1[1].ToString(); subJobTypes.Add(subJobType); } sqlconn.Close(); return(View(subJobTypes)); //return View(db.tbl_subJobTypes.ToList()); }
//GET SUB JOB TYPES public List <tbl_subJobTypes> subJobTypesByJobID(string jobID) { List <tbl_subJobTypes> subJobTypes = new List <tbl_subJobTypes>(); string mainconn = ConfigurationManager.ConnectionStrings["allpaxServiceRecordEntities"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); string sqlquery1 = "SELECT tbl_subJobTypes.subJobID, tbl_subJobTypes.description " + "FROM tbl_subJobTypes "; SqlCommand sqlcomm1 = new SqlCommand(sqlquery1, sqlconn); sqlcomm1.Parameters.Add(new SqlParameter("jobID", jobID)); SqlDataAdapter sda3 = new SqlDataAdapter(sqlcomm1); DataTable dt1 = new DataTable(); sda3.Fill(dt1); foreach (DataRow dr1 in dt1.Rows) { tbl_subJobTypes subJobType = new tbl_subJobTypes(); subJobType.subJobID = (byte)dr1[0]; subJobType.description = dr1[1].ToString(); subJobTypes.Add(subJobType); } return(subJobTypes); }
public ActionResult DeleteSubJobType(tbl_subJobTypes subJobTypeDelete) { try { db.Database.ExecuteSqlCommand("DELETE FROM tbl_subJobTypes WHERE subJobID=({0})", subJobTypeDelete.subJobID); return(Json(Url.Action("Index", "SubJobTypes"))); } catch (Exception e) { return(Content(e.Message)); } }
public ActionResult AddSubJobType(tbl_subJobTypes subJobTypeAdd) { try { db.Database.ExecuteSqlCommand("Insert into tbl_subJobTypes Values({0})", subJobTypeAdd.description); return(Json(Url.Action("Index", "SubJobTypes"))); } catch (Exception e) { return(Content(e.Message)); } }
public ActionResult UpdateSubJobType(tbl_subJobTypes subJobTypeUpdate) { try { db.Database.ExecuteSqlCommand( "UPDATE tbl_subJobTypes " + "SET " + "description = {0} " + "WHERE subJobID = {1}", subJobTypeUpdate.description, subJobTypeUpdate.subJobID); return(Json(Url.Action("Index", "SubJobTypes"))); } catch (Exception e) { return(Content(e.Message)); } }