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));
}
