/// <summary>
/// counter soft
/// </summary>
/// <param name="userId"></param>
/// <param name="equipCode"></param>
/// <param name="date"></param>
public void Logout(int userId, int equipCode, DateTime date)
{
using (db = new QMSSystemEntities())
{
var objs = db.Q_Login.Where(x => x.UserId == userId && x.EquipCode == equipCode && x.StatusId == (int)eStatus.LOGIN).ToList();
if (objs.Count > 0)
{
foreach (var item in objs)
{
item.LogoutTime = date;
item.StatusId = (int)eStatus.LOGOUT;
db.Entry <Q_Login>(item).State = System.Data.Entity.EntityState.Modified;
}
}
db.SaveChanges();
}
}
public bool Delete(string connectString, int Id)
{
using (var db = new QMSSystemEntities(connectString))
{
try
{
var file = db.Q_Video.Where(x => !x.IsDeleted).FirstOrDefault(x => x.Id == Id);
file.IsDeleted = true;
db.Entry <Q_Video>(file).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
catch (System.Exception e)
{
}
return(false);
}
}
/// <summary>
/// Đánh giá chất lượng phục vụ bằng counter
/// </summary>
/// <param name="equipCode">ma thiet bi</param>
/// <param name="value">value đánh giá</param>
/// <param name="system">hệ thống 1=> xe máy , 0 => khác </param>
/// <returns></returns>
public ResponseBaseModel DanhGia_BP(int equipCode, string value, int system)
{
var rs = new ResponseBaseModel();
try
{
using (var db = new QMSSystemEntities())
{
var login = db.Q_Login.FirstOrDefault(x => x.EquipCode == equipCode && x.StatusId == (int)eStatus.LOGIN);
if (login != null)
{
int tieuchi = 0;
int.TryParse(value.Substring((value.IndexOf('_') + 1)), out tieuchi);
bool sendSMS = db.Q_EvaluateDetail.FirstOrDefault(x => x.Id == tieuchi).IsSendSMS;
var now = DateTime.Now;
#region
var ticketInfos = db.Q_DailyRequire_Detail.Where(x => x.UserId == login.UserId && (x.StatusId == (int)eStatus.DANHGIA || x.StatusId == (int)eStatus.DAGXL)).ToList();
if (ticketInfos.Count > 0)
{
var firstObj = ticketInfos.FirstOrDefault();
IQueryable <Q_DailyRequire_Detail> details;
details = (from x in db.Q_DailyRequire_Detail
where x.DailyRequireId == firstObj.DailyRequireId &&
(x.StatusId == (int)eStatus.DANHGIA || x.StatusId == (int)eStatus.DAGXL) &&
(system == 1 ? true : x.UserId == login.UserId)
select x);
foreach (var item in details)
{
var obj = (from
ue in db.Q_UserEvaluate
where
item.UserId == ue.UserId &&
item.DailyRequireId == ue.Q_DailyRequire_Detail.DailyRequireId
select ue).FirstOrDefault();
if (obj == null)
{
db.Q_UserEvaluate.Add(new Q_UserEvaluate()
{
UserId = item.UserId ?? 0,
DailyRequireDeId = item.Id,
Score = value,
SendSMS = sendSMS,
CreatedDate = now
});
}
var config = db.Q_Config.FirstOrDefault(x => x.Code == eConfigCode.DoneTicketAfterEvaluate);
string doneTicketAfterEvaluate = "0";
if (config != null)
{
doneTicketAfterEvaluate = config.Value;
}
if (item.StatusId != (int)eStatus.HOTAT && doneTicketAfterEvaluate == "1")
{
item.StatusId = (int)eStatus.HOTAT;
item.EndProcessTime = now;
db.Entry <Q_DailyRequire_Detail>(item).State = System.Data.Entity.EntityState.Modified;
}
}
db.SaveChanges();
rs.IsSuccess = true;
}
#endregion
}
}
}
catch { }
return(rs);
}
public ResponseBaseModel Evaluate(string username, string value, int num, string isUseQMS)
{
var rs = new ResponseBaseModel();
using (var db = new QMSSystemEntities())
{
var user = db.Q_User.FirstOrDefault(x => x.UserName.Trim().ToUpper().Equals(username.Trim().ToUpper()));
if (user != null)
{
int tieuchi = 0;
int.TryParse(value.Substring((value.IndexOf('_') + 1)), out tieuchi);
var detail = db.Q_EvaluateDetail.FirstOrDefault(x => x.Id == tieuchi);
bool sendSMS = detail.IsSendSMS;
var now = DateTime.Now;
var system = db.Q_Config.FirstOrDefault(x => x.IsActived && x.Code == eConfigCode.System).Value;
if (isUseQMS == "1")
{
#region
var ticketInfos = db.Q_DailyRequire_Detail.Where(x => x.Q_DailyRequire.TicketNumber == num && x.Q_User.UserName.Trim().ToUpper().Equals(username.Trim().ToUpper()) && (x.StatusId == (int)eStatus.DANHGIA || x.StatusId == (int)eStatus.DAGXL)).ToList();
if (ticketInfos.Count > 0)
{
var firstObj = ticketInfos.FirstOrDefault();
IQueryable <Q_DailyRequire_Detail> details;
details = (from x in db.Q_DailyRequire_Detail
where x.DailyRequireId == firstObj.DailyRequireId &&
(x.StatusId == (int)eStatus.DANHGIA || x.StatusId == (int)eStatus.DAGXL) &&
(system == "1" ? true : x.UserId == user.Id)
select x);
var config = db.Q_Config.FirstOrDefault(x => x.Code == eConfigCode.DoneTicketAfterEvaluate);
string doneTicketAfterEvaluate = "0";
if (config != null)
{
doneTicketAfterEvaluate = config.Value;
}
foreach (var item in details)
{
var obj = (from
ue in db.Q_UserEvaluate
where
item.UserId == ue.UserId &&
item.DailyRequireId == ue.Q_DailyRequire_Detail.DailyRequireId
select ue).FirstOrDefault();
if (obj == null)
{
db.Q_UserEvaluate.Add(new Q_UserEvaluate()
{
UserId = item.UserId ?? 0,
DailyRequireDeId = item.Id,
Score = value,
SendSMS = sendSMS,
CreatedDate = now
});
}
if (item.StatusId != (int)eStatus.HOTAT && doneTicketAfterEvaluate == "1")
{
item.StatusId = (int)eStatus.HOTAT;
item.EndProcessTime = now;
db.Entry <Q_DailyRequire_Detail>(item).State = System.Data.Entity.EntityState.Modified;
}
}
db.SaveChanges();
rs.IsSuccess = true;
}
#endregion
}
else
{
db.Q_UserEvaluate.Add(new Q_UserEvaluate()
{
UserId = user.Id,
DailyRequireDeId = null,
Score = value,
SendSMS = sendSMS,
CreatedDate = DateTime.Now
});
db.SaveChanges();
rs.IsSuccess = true;
}
if (sendSMS)
{
Q_CounterSoftRequire require;
string maNV = user.Id.ToString();
var phones = db.Q_RecieverSMS.Where(x => x.IsActive && x.UserIds.Contains(maNV)).ToList();
if (phones.Count > 0)
{
foreach (var item in phones)
{
if (item.UserIds.Split(',').ToArray().Contains(maNV) && item.PhoneNumber.Length > 0)
{
require = new Q_CounterSoftRequire();
require.Content = item.PhoneNumber + ":" + user.Name + "(" + user.UserName + ")" + " " + detail.SmsContent;
require.TypeOfRequire = (int)eCounterSoftRequireType.SendSMS;
db.Q_CounterSoftRequire.Add(require);
}
db.SaveChanges();
}
}
}
}
}
return(rs);
}
