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