public int Insert(Q_UserEvaluate obj)
{
using (var db = new QMSSystemEntities())
{
db.Q_UserEvaluate.Add(obj);
db.SaveChanges();
return(obj.Id);
}
}
public bool CallNext(int num, Login login)
{
//db = new QMSEntities();
//// var xlyc = db.XULYYCs.Where(x => x.MAPHIEU.Value.ToString() == num.ToString() && x.MATB == login.iCounterId && x.MATB == login.iStaffId).FirstOrDefault();
//var xlyc = db.XULYYCs.Where(x => x.MAPHIEU.Value == num && x.MATB == login.iCounterId && x.MANV == login.iStaffId).FirstOrDefault();
//if (xlyc != null)
//{
// xlyc.GKETTHUC = DateTime.Now;
// xlyc.MATT = eStatus.Done;
// //var yc = db.YEUCAUs.FirstOrDefault(x => x.MAPHIEU == num);
// //yc.MATT = eStatus.Done;
// db.SaveChanges();
// return true;
//}
//return false;
try
{
db = new QMSEntities();
var xlycs = db.XULYYCs.Where(x => x.MATB == login.iCounterId && x.MANV == login.iStaffId && x.MAPHIEU == num).ToList();
if (xlycs != null)
{
bool done = false;
foreach (var item in xlycs)
{
item.GKETTHUC = DateTime.Now;
item.MATT = eStatus.Done;
if (!done)
{
var newObj = new Q_UserEvaluate();
newObj.UserId = item.MANV ?? 0;
newObj.TicketNumber = num;
newObj.Score = "0";
newObj.GLAYPHIEU = item.GLAYPHIEU;
newObj.GDENQUAY = item.GDENQUAY;
newObj.GGIAODICH = item.GGIAODICH;
newObj.GKETTHUC = item.GKETTHUC;
db.Q_UserEvaluate.Add(newObj);
done = true;
}
}
var yc = db.YEUCAUs.FirstOrDefault(x => x.MAPHIEU == num);
yc.MATT = eStatus.Done;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
}
return(false);
}
public ResponseBase Evaluate(string username, string value, int num)
{
var rs = new ResponseBase();
try
{
db = new QMSEntities();
var ticketinfo = db.XULYYCs.FirstOrDefault(x => x.MAPHIEU == num);
if (ticketinfo != null)
{
var user = db.NHANVIENs.FirstOrDefault(x => x.USERNAME.Trim().ToUpper().Equals(username.Trim().ToUpper()));
var obj = new Q_UserEvaluate();
obj.UserId = user.MANV;
obj.TicketNumber = num;
obj.GLAYPHIEU = ticketinfo.GLAYPHIEU;
obj.GDENQUAY = ticketinfo.GDENQUAY;
obj.GGIAODICH = ticketinfo.GGIAODICH;
obj.GKETTHUC = ticketinfo.GKETTHUC;
}
//if (obj.Id == 0)
//{
// db.Q_Evaluate.Add(obj);
// rs.IsSuccess = false;
//}
//else
//{
// var oldObj = Get(obj.Id);
// if (oldObj != null)
// {
// oldObj.Index = obj.Index;
// oldObj.Name = obj.Name;
// oldObj.Note = obj.Note;
// }
//}
db.SaveChanges();
rs.IsSuccess = true;
}
catch { }
return(rs);
}
public ResponseBase Evaluate(string username, string value, int num, string isUseQMS)
{
var rs = new ResponseBase();
try
{
db = new QMSEntities();
var user = db.NHANVIENs.FirstOrDefault(x => x.USERNAME.Trim().ToUpper().Equals(username.Trim().ToUpper()));
Q_UserEvaluate newObj;
var now = DateTime.Now;
if (isUseQMS == "1")
{
#region
var ticketInfos = db.XULYYCs.Where(x => x.MAPHIEU == num && x.NHANVIEN.USERNAME.Trim().ToUpper().Equals(username.Trim().ToUpper()) && (x.MATT == eStatusName.Rating || x.MATT == eStatusName.Processing)).ToList();
if (ticketInfos.Count > 0 && user != null)
{
var firstObj = ticketInfos.FirstOrDefault();
var obj = db.Q_UserEvaluate.FirstOrDefault(x => x.UserId == user.MANV && x.TicketNumber == num && x.GLAYPHIEU == firstObj.GLAYPHIEU);
if (obj == null)
{
newObj = new Q_UserEvaluate();
newObj.UserId = user.MANV;
newObj.TicketNumber = num;
newObj.Score = value;
newObj.GLAYPHIEU = firstObj.GLAYPHIEU;
newObj.GDENQUAY = firstObj.GDENQUAY;
newObj.GGIAODICH = firstObj.GGIAODICH;
newObj.GKETTHUC = firstObj.GKETTHUC;
db.Q_UserEvaluate.Add(newObj);
//var findButton = db.Q_CallButtonNext.FirstOrDefault(x => x.CounterId == ticketInfo.MATB.Value && x.UserId == ticketInfo.MANV);
//if (findButton != null)
// findButton.IsClick = true;
//else
//{
// findButton = new Q_CallButtonNext();
// findButton.UserId = ticketInfo.MANV.Value;
// findButton.CounterId = ticketInfo.MATB.Value;
// findButton.IsClick = true;
// db.Q_CallButtonNext.Add(findButton);
//}
}
foreach (var item in ticketInfos)
{
item.MATT = eStatusName.Done;
item.GKETTHUC = now;
}
if (ticketInfos.Count > 0)
{
var yc = db.YEUCAUs.FirstOrDefault(x => x.MAPHIEU == num);
if (yc != null)
{
yc.MATT = eStatusName.Done;
}
}
db.SaveChanges();
rs.IsSuccess = true;
}
#endregion
}
else
{
newObj = new Q_UserEvaluate();
newObj.GKETTHUC = now;
newObj.UserId = user.MANV;
newObj.TicketNumber = 0;
newObj.Score = value;
db.Q_UserEvaluate.Add(newObj);
db.SaveChanges();
rs.IsSuccess = true;
}
}
catch { }
return(rs);
}
