public async Task <IActionResult> Edit(int id, [Bind("Id,ActivityId,RatingDate,RatingTypeId,Score")] ClientRating clientRating)
{
if (id != clientRating.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(clientRating);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ClientRatingExists(clientRating.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(clientRating));
}
public IList <ClientRating> Get()
{
try
{
Logger.LogInfo("Get: ClientRating process start");
IList <ClientRating> lstClientRating = new List <ClientRating>();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL));
foreach (DataRow dr in dtAppConfig.Rows)
{
ClientRating ClientRating = convertToClientRatingObject(dr);
lstClientRating.Add(ClientRating);
}
Logger.LogInfo("Get: ClientRating process completed.");
return(lstClientRating);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
private ClientRating convertToClientRatingObject(DataRow dr)
{
ClientRating ClientRating = new ClientRating();
ClientRating.Rating = dr.Field <string>("Rating");
return(ClientRating);
}
public async Task <IActionResult> Create([Bind("Id,ActivityId,RatingDate,RatingTypeId,Score")] ClientRating clientRating)
{
if (ModelState.IsValid)
{
_context.Add(clientRating);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(clientRating));
}
public Result Delete(ClientRating ClientRating)
{
var result = new Result();
try
{
ClientRatingService ClientRatingService = new ClientRatingService();
ClientRatingService.Delete(ClientRating);
result.IsSuccess = true;
}
catch (Exception exception)
{
result.IsSuccess = false;
result.ExceptionInfo = exception;
}
return(result);
}
public void Delete(ClientRating ClientRating)
{
try
{
DataBase.DBService.ExecuteCommand(string.Format(DELETE_BY_ID, ClientRating.Rating));
Activity.ActivitiesService.Add(ActivityType.DeleteClientRating, EntryStatus.Success,
Source.Server, ClientRating.UpdatedByUserName, ClientRating.Rating, ClientRating.MachineName);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
public static ClientRating UpdateRating(ClientRating clientRating)
{
try
{
var endPointString = endPointQLBH + "api/ratings";
var ratingUpdate = Task.Run(() => PutAsync <ClientRating>(endPointString, clientRating)).Result;
return(ratingUpdate);
}
catch (BusinessLayerException)
{
throw new BusinessLayerException(500, "#1001002 Không cập nhật được dữ liệu đánh giá.");
}
catch (Exception)
{
throw new BusinessLayerException(500, "#1001003 Không cập nhật được dữ liệu đánh giá.");
}
}
public void Add(ClientRating ClientRating)
{
try
{
string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_CLIENT_NAME_QUERY, 0));
DataBase.DBService.ExecuteCommand(string.Format(INSERT_QUERY,
ClientRating.Rating,
ClientRating.CreatedOn.ToString("yyyy-MM-dd hh:mm:ss"), ClientRating.CreatedBy,
ClientRating.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"), ClientRating.UpdatedBy));
Activity.ActivitiesService.Add(ActivityType.CreateClientRating, EntryStatus.Success,
Source.Server, ClientRating.UpdatedByUserName, ClientRating.Rating, ClientRating.MachineName);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
public ActionResult RateProductIndex(int?proId, int?rateId, int?rate)
{
var p = CSDLQLBH.GetRatingsByProduct(proId).FirstOrDefault();
if (p != null)
{
switch (rateId)
{
case 1:
if (rate == 1)
{
p.One += 1;
}
else
{
p.One -= 1;
}
break;
case 2:
if (rate == 1)
{
p.Two += 1;
}
else
{
p.Two -= 1;
}
break;
case 3:
if (rate == 1)
{
p.Three += 1;
}
else
{
p.Three -= 1;
}
break;
case 4:
if (rate == 1)
{
p.Four += 1;
}
else
{
p.Four -= 1;
}
break;
case 5:
if (rate == 1)
{
p.Five += 1;
}
else
{
p.Five -= 1;
}
break;
}
p.Rate = ((p.One * 1) + (p.Two * 2) + (p.Three * 3) + (p.Four * 4) + (p.Five * 5)) / (p.One + p.Two + p.Three + p.Four + p.Five);
CSDLQLBH.UpdateRating(p);
}
else
{
ClientRating ra = new ClientRating
{
ProID = proId,
One = 0,
Two = 0,
Three = 0,
Four = 0,
Five = 0
};
switch (rateId)
{
case 1:
ra.One = rate;
break;
case 2:
ra.Two = rate;
break;
case 3:
ra.Three = rate;
break;
case 4:
ra.Four = rate;
break;
case 5:
ra.Five = rate;
break;
}
ra.Rate = ((ra.One * 1) + (ra.Two * 2) + (ra.Three * 3) + (ra.Four * 4) + (ra.Five * 5)) / (ra.One + ra.Two + ra.Three + ra.Four + ra.Five);
CSDLQLBH.InsertRating(ra);
}
return(RedirectToAction("Index", "Home"));
}
