//GET RESOURCE TYPES public List <tbl_resourceTypes> resourceTypesByJobID(string jobID) { List <tbl_resourceTypes> resourceTypes = new List <tbl_resourceTypes>(); string mainconn = ConfigurationManager.ConnectionStrings["allpaxServiceRecordEntities"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); string sqlquery1 = "SELECT tbl_resourceTypes.resourceTypeID, tbl_resourceTypes.resourceType, tbl_resourceTypes.description, tbl_resourceTypes.rate " + "FROM tbl_resourceTypes "; 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_resourceTypes resourceType = new tbl_resourceTypes(); resourceType.resourceTypeID = (byte)dr1[0]; resourceType.resourceType = dr1[1].ToString(); resourceType.description = dr1[2].ToString(); resourceType.rate = (decimal)dr1[3]; resourceTypes.Add(resourceType); } return(resourceTypes); }
public ActionResult Index() { List <tbl_resourceTypes> resourceTypes = new List <tbl_resourceTypes>(); string mainconn = ConfigurationManager.ConnectionStrings["allpaxServiceRecordEntities"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); sqlconn.Open(); string sqlquery1 = "SELECT tbl_resourceTypes.resourceTypeID, tbl_resourceTypes.resourceType, tbl_resourceTypes.description, tbl_resourceTypes.rate " + "FROM tbl_resourceTypes"; 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_resourceTypes resourceType = new tbl_resourceTypes(); resourceType.resourceTypeID = (byte)dr1[0]; resourceType.resourceType = dr1[1].ToString(); resourceType.description = dr1[2].ToString(); resourceType.rate = (decimal)dr1[3]; resourceTypes.Add(resourceType); } sqlconn.Close(); return(View(resourceTypes)); }
public ActionResult DeleteResourceType(tbl_resourceTypes resourceTypeDelete) { try { db.Database.ExecuteSqlCommand("DELETE FROM tbl_resourceTypes WHERE resourceTypeID=({0})", resourceTypeDelete.resourceTypeID); return(Json(Url.Action("Index", "ResourceTypes"))); } catch (Exception e) { return(Content(e.Message)); } }
public ActionResult AddResourceType(tbl_resourceTypes resourceTypeAdd) { try { db.Database.ExecuteSqlCommand("Insert into tbl_resourceTypes Values({0},{1},{2})", resourceTypeAdd.resourceType, resourceTypeAdd.description, resourceTypeAdd.rate); return(Json(Url.Action("Index", "ResourceTypes"))); } catch (Exception e) { return(Content(e.Message)); } }
public ActionResult UpdateResourceType(tbl_resourceTypes resourceUpdate) { try { db.Database.ExecuteSqlCommand( "UPDATE tbl_resourceTypes " + "SET " + "resourceType = {0}, " + "description = {1}, " + "rate = {2} " + "WHERE resourceTypeID = {3}", resourceUpdate.resourceType, resourceUpdate.description, resourceUpdate.rate, resourceUpdate.resourceTypeID); return(Json(Url.Action("Index", "ResourceTypes"))); } catch (Exception e) { return(Content(e.Message)); } }