/// <summary> /// Initializes a new instance of the <see cref="CallCenter"/> class. /// </summary> public CallCenter() { for (int i = 0; i < 10; i++) { Respondents.Add(new Respondent()); } for (int i = 0; i < 3; i++) { Managers.Add(new Manager()); } DirectorCenter = new Director(); }
public async Task <Guid> AddAsync() { Respondents respondent = new Respondents() { DateCreated = System.DateTime.Now }; using (var uow = UowProvider.CreateUnitOfWork()) { var repositoryRspondent = uow.GetRepository <Respondents, Guid>(); await repositoryRspondent.AddAsync(respondent); await uow.SaveChangesAsync(); return(respondent.Id); } }
public ActionResult Edit([Bind("Id", "Name", "Surname", "Patro", "BirthDate")] Respondents respondents) { if (ModelState.IsValid) { var resParam = new OracleParameter("result", OracleDbType.Decimal, System.Data.ParameterDirection.Output); SqlUtility.ExecuteStoredProcedure(db, "UPDATE_RESPONDENTS(:id, :name, :surname, :patro, :birthdate, :result)", new OracleParameter("id", respondents.Id), new OracleParameter("name", respondents.Name), new OracleParameter("surname", respondents.Surname), new OracleParameter("patro", respondents.Patro), new OracleParameter("birthdate", OracleDbType.Date, respondents.BirthDate, System.Data.ParameterDirection.Input), resParam); var result = ((Oracle.ManagedDataAccess.Types.OracleDecimal)resParam.Value).Value; if (result < 0) { return(BadRequest()); } return(RedirectToAction("Index")); } return(View(respondents)); }
public async Task <ActionResult> AddReply([FromBody] JObject replys) { var getQuestions = await _dbContext.Questions.Where(x => x.UserId == (int)replys["userId"] && !x.Deleted).ToListAsync(); Respondents respon = new Respondents(); respon.RespondentName = (string)replys["replyName"]; respon.ReplyDate = Convert.ToString(DateTime.Now); respon.UserId = (int)replys["userId"]; _dbContext.Respondents.Add(respon); await _dbContext.SaveChangesAsync(); foreach (var reply in replys) { foreach (var question in getQuestions) { if (question.Question == reply.Key) { Replys userReply = new Replys(); userReply.RespondentName = (string)replys["replyName"]; userReply.RespondentId = respon.Id; userReply.QuestionId = (int)question.Id; userReply.Question = question.Question; userReply.Subject = question.Subject; userReply.Reply = reply.Value.ToString(); _dbContext.Replys.Add(userReply); await _dbContext.SaveChangesAsync(); } } } return(Ok()); }