public async Task <IActionResult> Edit(Guid id, [Bind("Comment,CampaignId,AppUserId,CreatedBy,CreatedAt,EditedBy,EditedAt,Id")] UserCampaign userCampaign) { if (id != userCampaign.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(userCampaign); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserCampaignExists(userCampaign.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["AppUserId"] = new SelectList(_context.Users, "Id", "FirstName", userCampaign.AppUserId); ViewData["CampaignId"] = new SelectList(_context.Campaigns, "Id", "Name", userCampaign.CampaignId); return(View(userCampaign)); }
public List <UserCampaign> GetUserCampaign() { SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); List <UserCampaign> list = new List <UserCampaign>(); using (sqlconn) { using (SqlCommand cmd = new SqlCommand("getUserCampaign", sqlconn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; sqlconn.Open(); using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { UserCampaign userCampaign = new UserCampaign { UserId = rdr["UserId"].ToString(), CampaignID = rdr["CampaignID"].ToString() }; list.Add(userCampaign); } } } } return(list); }
public async Task <IActionResult> Create([Bind("Comment,CampaignId,AppUserId,CreatedBy,CreatedAt,EditedBy,EditedAt,Id")] UserCampaign userCampaign) { if (ModelState.IsValid) { userCampaign.Id = Guid.NewGuid(); _context.Add(userCampaign); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["AppUserId"] = new SelectList(_context.Users, "Id", "FirstName", userCampaign.AppUserId); ViewData["CampaignId"] = new SelectList(_context.Campaigns, "Id", "Name", userCampaign.CampaignId); return(View(userCampaign)); }
public async Task <JsonResult> Create(UserCampaignModel model) { try { if (ModelState.IsValid) { var overWrite = db.UserCampaigns.Where(x => x.UserId == model.UserId && x.CampaignId == model.CampaignId).ToList(); if (overWrite.Count > 0 && model.confirmOverwite != 1) { Response.StatusCode = 400; return(Json("Error")); } var userCampaign = db.UserCampaigns.Where(x => x.CampaignId == model.CampaignId && x.UserId == model.UserId).FirstOrDefault(); if (userCampaign != null) { db.UserProjects.RemoveRange(db.UserProjects.Where(y => y.UserCampaignId == userCampaign.Id && y.UserId == model.UserId)); db.UserCampaigns.RemoveRange(db.UserCampaigns.Where(x => x.UserId == model.UserId && x.CampaignId == model.CampaignId)); } var entity = new UserCampaign { User = model.User, UserId = model.UserId, Campaign = model.Campaign, CampaignId = model.CampaignId, BudgetedHours = model.BudgetedHours, PayRateDialingHours = model.PayRateDialingHours, PayRateTrainingHours = model.PayRateTrainingHours, PayRateSuccess = model.PayRateSuccess, LastUpdate = DateTime.Now, CreationDate = DateTime.Now, IsDeleted = false, }; db.UserCampaigns.Add(entity); var userProjects = new List <UserProject>(); foreach (var item in model.ProjectIds) { userProjects.Add(new UserProject { UserCampaignId = entity.Id, UserId = model.UserId, ProjectId = item, CreationDate = DateTime.Now, LastUpdate = DateTime.Now, IsDeleted = false }); } db.UserProjects.AddRange(userProjects); await db.SaveChangesAsync(); return(Json("Ok")); } } catch (Exception e) { AddAlert($"Oops! something went wrong. Error code: {e.HResult}", "Create(model)", this.GetType().ToString(), AlertType.error, e); } var Users = db.Users.Where(x => !x.IsDeleted); ViewBag.UserId = new SelectList(Users.Where(x => x.Roles.Any(y => y.RoleId == "2" || y.RoleId == "3")), "Id", "DisplayName"); ViewBag.CampaignId = new SelectList(db.Campaigns.Where(x => !x.IsDeleted), "Id", "Identifier"); return(Json("Error")); }
public void CreateDomainLevel2() { try { var ctx = ApplicationDbContext.Create(); //already OK if (ctx.Forms.Any()) { return; } var reader = new ReadOnlyContext(); var db = MemoryDB.LoadDomainLevel2(reader); var container = new MemoryDB(); foreach (var item in db.Forms) { var form = new Form { Id = item.Id, //Campaign = campaign, //CampaignId = campaign.Id, CampaignId = item.CampaignId, CreationDate = item.CreationDate, Description = item.Description, IsDeleted = item.IsDeleted, LastUpdate = item.LastUpdate, Name = item.Name, }; container.Forms.Add(form); } foreach (var item in db.AgentLogs) { var agentLog = new AgentLog { Id = item.Id, //Agent = agent, //AgentId = agent.Id, AgentId = item.AgentId, //Campaign = campaign, //CampaignId = campaign.Id, CampaignId = item.CampaignId, //TimeZone = timeZone, //TimeZoneId = timeZone.Id, TimeZoneId = item.TimeZoneId, CreationDate = item.CreationDate, DialingHours = item.DialingHours, IsDeleted = item.IsDeleted, LastUpdate = item.LastUpdate, Project = item.Project, ProjectId = item.ProjectId, Successes = item.Successes, TrainingHours = item.TrainingHours, }; container.AgentLogs.Add(agentLog); } //foreach (var item in db.CampaignCallCodes) //{ // var campaignCallCodes = new CampaignCallCode // { // Id = item.Id, // //CallCode = callCode, // //CallCodeId = callCode.Id, // CallCodeId = item.CallCodeId, // //Campaign = campaign, // //CampaignId = campaign.Id, // CampaignId = item.CampaignId, // CreationDate = item.CreationDate, // IsDeleted = item.IsDeleted, // LastUpdate = item.LastUpdate, // }; // container.CampaignCallCodes.Add(campaignCallCodes); //} foreach (var item in db.ExtraFields) { var extraField = new ExtraField { Id = item.Id, //Campaign = campaign, //CampaignId = campaign.Id, CampaignId = item.CampaignId, CreationDate = item.CreationDate, // ExtraFieldOptions = item.ExtraFieldOptions, FieldName = item.FieldName, IsDeleted = item.IsDeleted, TypeId = item.TypeId, LastUpdate = item.LastUpdate, }; container.ExtraFields.Add(extraField); } foreach (var item in db.UserCampaigns) { var userCampaign = new UserCampaign { Id = item.Id, //Campaign = campaign, //CampaignId = campaign.Id, CampaignId = item.CampaignId, //User = user, //UserId = user.Id, UserId = item.UserId, BudgetedHours = item.BudgetedHours, CreationDate = item.CreationDate, IsDeleted = item.IsDeleted, LastUpdate = item.LastUpdate, PayRateDialingHours = item.PayRateDialingHours, PayRateSuccess = item.PayRateSuccess, PayRateTrainingHours = item.PayRateTrainingHours, }; container.UserCampaigns.Add(userCampaign); } foreach (var item in db.UserProjects) { var userProject = new UserProject { Id = item.Id, //UserCampaign = userCampaign, //UserCampaignId = userCampaign.Id, UserCampaignId = item.UserCampaignId, //Project = project, //ProjectId = project.Id, ProjectId = item.ProjectId, //User = user, //UserId = user.Id, UserId = item.UserId, CreationDate = item.CreationDate, IsDeleted = item.IsDeleted, LastUpdate = item.LastUpdate, }; container.UserProjects.Add(userProject); } foreach (var item in db.UsersHistory) { var userHistory = new UserHistory { Id = item.Id, //User = user, //UserId = user.Id, UserId = item.UserId, //Campaign = campaign, //CampaignId = campaign?.Id, CampaignId = item.CampaignId, ConnectionId = item.ConnectionId, CreationDate = item.CreationDate, Duration = item.Duration, IsDeleted = item.IsDeleted, LastUpdate = item.LastUpdate, LoggedIn = item.LoggedIn, LoggedOff = item.LoggedOff, }; container.UsersHistory.Add(userHistory); } ctx.Forms.AddRange(container.Forms); ctx.AgentLogs.AddRange(container.AgentLogs); //ctx.CampaignCallCodes.AddRange(container.CampaignCallCodes); ctx.ExtraFields.AddRange(container.ExtraFields); ctx.UserCampaigns.AddRange(container.UserCampaigns); ctx.UserProjects.AddRange(container.UserProjects); ctx.UsersHistory.AddRange(container.UsersHistory); ctx.SaveChanges(); } catch (Exception ex) { var str = ex.ToString(); System.Diagnostics.Debug.WriteLine(str); } }