public ActionResult EditMoreDetail(AllDataDTO obj, IList <IFormFile> files, int id) { if (ModelState.IsValid) { //var filepath = Path.GetTempFileName(); //foreach (IFormFile item in files) //{ // string filename = ContentDispositionHeaderValue.Parse(item.ContentDisposition).FileName.Trim('"'); // filename = this.EnsureFilename(filename); // using (FileStream filestream = System.IO.File.Create(this.Getpath(filename, id))) // { // obj.ImageUrl = filename; // } //} try { _shopData.EditedDetail(obj); return(RedirectToAction("Index", "Shop", new { id = id })); } catch (Exception ex) { throw ex; } } return(View()); }
private void LoadStakeholders(IList <MatchPreviewAthleteDTO> athleteDtos, IntiDataContext db) { var userFavorites = from utf in db.Ext_UserFavoriteTeam where utf.UserGUID == SessionProps.UserGuid select utf; //for each of these players, get a reference to the teams that has selected them var teams = new Dictionary <Guid, MatchPreviewTeamDTO>(10); foreach (var athlete in athleteDtos) { var teamVersions = (from ta in db.Inti_TeamAthlete join u in userFavorites on ta.Inti_TeamVersion.Inti_Team equals u.Inti_Team into oj from utf in oj.DefaultIfEmpty() where (ta.Inti_TeamVersion.Inti_Team.IsPaid ?? false) && (ta.Inti_TeamVersion.Inti_Team.IsActive ?? false) && ta.Inti_TeamVersion.ValidFrom <= DateTime.Today && (ta.Inti_TeamVersion.ValidTo ?? DateTime.Today) >= DateTime.Today && ta.AthleteGUID == athlete.AthleteClubGuid select new MatchPreviewTeamDTO() { TeamGuid = ta.Inti_TeamVersion.TeamGUID, TeamName = ta.Inti_TeamVersion.Inti_Team.Name, Manager = String.Format("{0} {1}", ta.Inti_TeamVersion.Inti_Team.Sys_User.FirstName, ta.Inti_TeamVersion.Inti_Team.Sys_User.LastName).Trim(), CustomClass = (SessionProps.UserGuid == utf.UserGUID) ? "active" : "list-group-item-info" }).ToList(); foreach (var matchPreviewTeamDTO in teamVersions.Where(matchPreviewTeamDTO => !teams.ContainsKey(matchPreviewTeamDTO.TeamGuid))) { teams.Add(matchPreviewTeamDTO.TeamGuid, matchPreviewTeamDTO); } foreach (var matchPreviewTeamDTO in teamVersions) { teams[matchPreviewTeamDTO.TeamGuid].Athletes.Add(new AthleteSubDTO() { AthleteClubGuid = athlete.AthleteClubGuid, Name = athlete.Name }); } } var allData = new AllDataDTO(); allData.Athletes = athleteDtos.ToArray(); allData.Teams = teams.Values.OrderByDescending(t => t.Athletes.Count).ToArray(); //set PreviewData to the Json object for jsRender to work with PreviewData = JsonConvert.SerializeObject(allData); }
public AllDataDTO ShowAllDetail(int id) { SignUp SData = _db.SignUps.Where(x => x.SignUpId == id).FirstOrDefault(); MoreDetail Mdata = _db.MoreDetails.Where(x => x.SignUpId == id).FirstOrDefault(); AllDataDTO AllData = new AllDataDTO(); AllData.FullName = SData.FullName; AllData.Address = SData.Address; AllData.Email = SData.Email; AllData.PhoneNumber = SData.PhoneNumber; AllData.LoginType = SData.LoginType; AllData.AdditionAddress = Mdata.AdditionAddress; AllData.AdditionPhoneNumber = Mdata.AdditionPhoneNumber; AllData.Location = Mdata.Location; AllData.ImageUrl = Mdata.ImageUrl; AllData.MoreDetailId = Mdata.MoreDetailId; AllData.SignUpId = Mdata.SignUpId; return(AllData); }
public void EditedDetail(AllDataDTO obj) //how to save data into 2 table from one view { SignUp SData = _db.SignUps.Where(x => x.SignUpId == obj.SignUpId).FirstOrDefault(); MoreDetail Mdata = _db.MoreDetails.Where(x => x.SignUpId == obj.SignUpId).FirstOrDefault(); SData.FullName = obj.FullName; SData.Address = obj.Address; SData.Email = obj.Email; SData.PhoneNumber = obj.PhoneNumber; SData.LoginType = obj.LoginType; Mdata.AdditionAddress = obj.AdditionAddress; Mdata.AdditionPhoneNumber = obj.AdditionPhoneNumber; Mdata.Location = obj.Location; Mdata.ImageUrl = obj.ImageUrl; _db.SignUps.Update(SData); _db.MoreDetails.Update(Mdata); //.State = Microsoft.EntityFrameworkCore.EntityState.Modified; _db.SaveChanges(); }
private void LoadStakeholders(IList<MatchPreviewAthleteDTO> athleteDtos, IntiDataContext db) { var userFavorites = from utf in db.Ext_UserFavoriteTeam where utf.UserGUID == SessionProps.UserGuid select utf; //for each of these players, get a reference to the teams that has selected them var teams = new Dictionary<Guid, MatchPreviewTeamDTO>(10); foreach (var athlete in athleteDtos) { var teamVersions = (from ta in db.Inti_TeamAthlete join u in userFavorites on ta.Inti_TeamVersion.Inti_Team equals u.Inti_Team into oj from utf in oj.DefaultIfEmpty() where (ta.Inti_TeamVersion.Inti_Team.IsPaid ?? false) && (ta.Inti_TeamVersion.Inti_Team.IsActive ?? false) && ta.Inti_TeamVersion.ValidFrom <= DateTime.Today && (ta.Inti_TeamVersion.ValidTo ?? DateTime.Today) >= DateTime.Today && ta.AthleteGUID == athlete.AthleteClubGuid select new MatchPreviewTeamDTO() { TeamGuid = ta.Inti_TeamVersion.TeamGUID, TeamName = ta.Inti_TeamVersion.Inti_Team.Name, Manager = String.Format("{0} {1}", ta.Inti_TeamVersion.Inti_Team.Sys_User.FirstName, ta.Inti_TeamVersion.Inti_Team.Sys_User.LastName).Trim(), CustomClass = (SessionProps.UserGuid == utf.UserGUID) ? "active" : "list-group-item-info" }).ToList(); foreach (var matchPreviewTeamDTO in teamVersions.Where(matchPreviewTeamDTO => !teams.ContainsKey(matchPreviewTeamDTO.TeamGuid))) { teams.Add(matchPreviewTeamDTO.TeamGuid, matchPreviewTeamDTO); } foreach (var matchPreviewTeamDTO in teamVersions) { teams[matchPreviewTeamDTO.TeamGuid].Athletes.Add(new AthleteSubDTO() { AthleteClubGuid = athlete.AthleteClubGuid, Name = athlete.Name }); } } var allData = new AllDataDTO(); allData.Athletes = athleteDtos.ToArray(); allData.Teams = teams.Values.OrderByDescending(t => t.Athletes.Count).ToArray(); //set PreviewData to the Json object for jsRender to work with PreviewData = JsonConvert.SerializeObject(allData); }