public IHttpActionResult PuttClass(int id, tClass tClass) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tClass.fClassId) { return(BadRequest()); } db.Entry(tClass).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tClassExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public List <tClass> GetClassListForCID(int cType, int CID) { List <tClass> lp = new List <tClass>(); string sql = "select * from t_class where pid = " + CID + " and cType = " + cType + " and Enable = 0 order by id asc"; using (DataTable dt = helper.GetDataTable(sql)) { if (dt != null && dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { tClass b = new tClass { id = Convert.ToInt16(r["Id"]), pId = Convert.ToInt16(r["pId"]), cType = Convert.ToInt16(r["cType"]), name = r["Name"].ToString(), logoUrl = r["LogoUrl"].ToString(), isShow = Convert.ToInt16(r["isShow"]), sType = Convert.ToInt16(r["sType"]), defaultUrl = r["defaultUrl"].ToString(), addOn = Convert.ToDateTime(r["AddOn"]) }; lp.Add(b); } } } return(lp); }
public Dictionary <int, tClass> getClassDicFObj() { Dictionary <int, tClass> Dic = new Dictionary <int, tClass>(); string sql = "select * from t_class"; using (DataTable dt = helper.GetDataTable(sql)) { if (dt != null && dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { tClass t = new tClass { id = Convert.ToInt16(r["Id"]), pId = Convert.ToInt16(r["pId"]), cType = Convert.ToInt16(r["cType"]), name = r["Name"].ToString(), logoUrl = r["LogoUrl"].ToString(), isShow = Convert.ToInt16(r["isShow"]), sType = Convert.ToInt16(r["sType"]), defaultUrl = r["defaultUrl"].ToString(), addOn = Convert.ToDateTime(r["AddOn"]) }; Dic.Add(Convert.ToInt16(r["Id"]), t); } } } return(Dic); }
public tClass GetClassInfo(int id) { tClass t = null; string sql = "select * from t_class where id = " + id; using (DataTable dt = helper.GetDataTable(sql)) { if (dt != null && dt.Rows.Count > 0) { DataRow r = dt.Rows[0]; { t = new tClass { id = Convert.ToInt16(r["Id"]), pId = Convert.ToInt16(r["pId"]), cType = Convert.ToInt16(r["cType"]), name = r["Name"].ToString(), logoUrl = r["LogoUrl"].ToString(), isShow = Convert.ToInt16(r["isShow"]), sType = Convert.ToInt16(r["sType"]), defaultUrl = r["defaultUrl"].ToString(), addOn = Convert.ToDateTime(r["AddOn"]) }; } } } return(t); }
public IHttpActionResult GettClass(int id) { tClass tClass = db.tClasses.Find(id); if (tClass == null) { return(NotFound()); } return(Ok(tClass)); }
public IHttpActionResult PosttClass(tClass tClass) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tClasses.Add(tClass); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tClass.fClassId }, tClass)); }
public IHttpActionResult DeletetClass(int id) { tClass tClass = db.tClasses.Find(id); if (tClass == null) { return(NotFound()); } db.tClasses.Remove(tClass); db.SaveChanges(); return(Ok(tClass)); }
private void SetOnlyList() { m_OnlyList.Clear(); foreach (DataGridViewRow row in dgv_only.Rows) { tClass tc = new tClass(); tc.bCheck = Convert.ToBoolean(row.Cells["col_only_check"].Value); tc.nKey = GetKey(row.Cells["col_only_key"].Value.ToString()); tc.nSec = Convert.ToInt32(row.Cells["col_only_sec"].Value.ToString()); tc.nIng = tc.nSec; m_OnlyList.Add(tc); } }
public long SaveClass(tClass tClass) { mmEntities.tClasses.Add(tClass); mmEntities.SaveChanges(); return tClass.ClassId; }
public static void SaveClass(tClass tClass, tStaffClass tStaffClass) { tStaffClass.ClassId = Wrapper.SaveClass(tClass); Wrapper.SaveStaffClass(tStaffClass); }