public TEAM GetTeam(int id) { using (MyKTAppDB db = new MyKTAppDB()) { return(db.TEAMs.FirstOrDefault(e => e.TEAM_ID == id)); } }
public IEnumerable <TEAM> GetTeams() { using (MyKTAppDB db = new MyKTAppDB()) { return(db.TEAMs.ToList()); } }
public HttpResponseMessage UpdateContent(int id) { using (MyKTAppDB db = new MyKTAppDB()) { var teamDetails = db.CONTENTs.FirstOrDefault(e => e.CONTENT_ID == id); } return(Request.CreateResponse(HttpStatusCode.Created)); }
public HttpResponseMessage AddTeam() { string teamLogo = null; var httpRequest = HttpContext.Current.Request; //Upload Team Logo var uploadedLogo = httpRequest.Files["TeamLogo"]; if (uploadedLogo != null) { //Create Custom FileName teamLogo = new string(Path.GetFileNameWithoutExtension(uploadedLogo.FileName).ToArray()).Replace(" ", "-"); teamLogo = teamLogo + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(uploadedLogo.FileName); var teamLogoPath = HttpContext.Current.Server.MapPath("~/Common/Images/TeamLogo/" + teamLogo); uploadedLogo.SaveAs(teamLogoPath); } //Upload KT Plan var uploadKTPlan = httpRequest.Files["KTPlan"]; string KTPlan = null; if (uploadKTPlan != null) { KTPlan = new string(Path.GetFileNameWithoutExtension(uploadKTPlan.FileName).ToArray()).Replace(" ", "-"); KTPlan = KTPlan + "-" + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(uploadKTPlan.FileName); var KTPlanPath = HttpContext.Current.Server.MapPath("~/Common/KTPlans/" + KTPlan); uploadKTPlan.SaveAs(KTPlanPath); } //Save to Database using (MyKTAppDB db = new MyKTAppDB()) { TEAM team = new TEAM() { TEAM_FULL_NAME = httpRequest["teamFullName"], TEAM_ABBREVIATED_NAME = httpRequest["teamAbbreviatedName"], TEAM_DESCRIPTION = httpRequest["teamDescription"], UPDATED_BY = httpRequest["userName"], }; if (uploadedLogo != null) { team.TEAM_LOGO_PATH = teamLogo; } if (uploadKTPlan != null) { team.TEAM_KT_PLAN_PATH = KTPlan; } db.Configuration.ValidateOnSaveEnabled = false; db.TEAMs.Add(team); db.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.Created)); }