public ResponseBase findLogin(string connectString, string maphongkham)
{
var rs = new ResponseBase();
rs.IsSuccess = false;
try
{
using (db = new QMSSystemEntities(connectString))
{
var tb = db.Q_Equipment.FirstOrDefault(x => !x.IsDeleted && !x.Q_Counter.IsDeleted && x.Q_Counter.ShortName.Trim().ToUpper().Equals(maphongkham.Trim().ToUpper()));
if (tb != null)
{
var login = db.Q_Login.OrderByDescending(x => x.Date).FirstOrDefault(x => !x.Q_User.IsDeleted && x.StatusId == (int)eStatus.LOGIN && x.EquipCode == tb.Code);
if (login != null)
{
rs.IsSuccess = true;
rs.Records = login.EquipCode;
rs.Data = login.UserId;
rs.Data_1 = tb.CounterId;
}
}
}
}
catch (Exception)
{
}
return(rs);
}
public PagedList <UserMajorModel> GetList(string connectString, int userId, int startIndexRecord, int pageSize, string sorting)
{
using (db = new QMSSystemEntities(connectString))
{
try
{
if (string.IsNullOrEmpty(sorting))
{
sorting = "Index ASC";
}
IQueryable <Q_UserMajor> objs = null;
var pageNumber = (startIndexRecord / pageSize) + 1;
objs = db.Q_UserMajor.Where(x => !x.IsDeleted && !x.Q_User.IsDeleted && !x.Q_Major.IsDeleted && x.UserId == userId);
return(new PagedList <UserMajorModel>(objs
.OrderBy(sorting)
.Select(x => new UserMajorModel()
{
Id = x.Id,
Index = x.Index,
MajorId = x.MajorId,
UserId = x.UserId,
UserName = x.Q_User.UserName,
MajorName = x.Q_Major.Name
}).ToList(), pageNumber, pageSize));
}
catch (Exception ex)
{
throw ex;
}
}
}
private Q_DailyRequire LayGioPhucVuDuKien(QMSSystemEntities db, string maCongViec, string maLoaiCongViec, Q_DailyRequire model)
{
DateTime processTime = new DateTime(2020, 1, 1, 00, 00, 00);
string[] codes = maCongViec.Split(',').Select(x => x.Trim().ToUpper()).ToArray();
if (codes != null && codes.Length > 0)
{
var a = (from x in db.Q_WorkDetail
where !x.IsDeleted
select new ModelSelectItem()
{
Code = x.Q_Works.Code, Name = x.Q_WorkType.Code
}).ToList();
var congviecs = (from x in db.Q_WorkDetail
where !x.IsDeleted &&
codes.Contains(x.Q_Works.Code.Trim().ToUpper()) &&
maLoaiCongViec.Trim().ToUpper().Equals(x.Q_WorkType.Code.Trim().ToUpper())
select new { TimeProcess = x.TimeProcess, Id = x.Id }).ToArray();
model.Q_DailyRequire_WorkDetail = new List <Q_DailyRequire_WorkDetail>();
for (int i = 0; i < congviecs.Count(); i++)
{
processTime = processTime.AddSeconds(congviecs[i].TimeProcess.TimeOfDay.TotalSeconds);
model.Q_DailyRequire_WorkDetail.Add(new Q_DailyRequire_WorkDetail()
{
Q_DailyRequire = model,
WorkDetailId = congviecs[i].Id
});
}
}
model.ServeTimeAllow = processTime.TimeOfDay;
return(model);
}
public AndroidModel GetInfoForAndroid(string userName, int getSTT, int getSMS, int getUserInfo)
{
using (var db = new QMSSystemEntities())
{
AndroidModel androidModel = new AndroidModel();
if (getSTT == 1)
{
var obj = db.Q_DailyRequire_Detail.Where(x => (x.StatusId == (int)eStatus.DAGXL || x.StatusId == (int)eStatus.DANHGIA) && x.ProcessTime.Value.Day == DateTime.Now.Day && x.ProcessTime.Value.Month == DateTime.Now.Month && x.ProcessTime.Value.Year == DateTime.Now.Year && x.Q_User.UserName.Trim().ToUpper().Equals(userName)).FirstOrDefault();
if (obj != null)
{
var userEval = db.Q_UserEvaluate.FirstOrDefault(x => x.DailyRequireDeId == obj.Id);
androidModel.HasEvaluate = (userEval != null ? true : false);
androidModel.TicketNumber = obj.Q_DailyRequire.TicketNumber;
androidModel.Status = (obj.StatusId == (int)eStatus.DANHGIA ? 1 : 0);
}
else
{
androidModel.TicketNumber = 0;
}
}
if (getUserInfo == 1)
{
androidModel.UserInfo = BLLUser.Instance.GetByUserName(userName);
}
if (getSMS == 1)
{
androidModel.SMS = db.Q_CounterSoftRequire.Where(x => x.TypeOfRequire == (int)eCounterSoftRequireType.SendSMS).Select(x => x.Content).ToList();
db.Database.ExecuteSqlCommand("delete Q_CounterSoftRequire where TypeOfRequire = 3");
db.SaveChanges();
}
return(androidModel);
}
}
public ResponseBase Delete(string connectString, int Id)
{
var rs = new ResponseBase();
using (db = new QMSSystemEntities(connectString))
{
var obj = db.Q_RecieverSMS.FirstOrDefault(x => !x.IsActive && x.Id == Id);
if (obj != null)
{
db.Q_RecieverSMS.Remove(obj);
db.SaveChanges();
rs.IsSuccess = true;
rs.Errors.Add(new Error()
{
MemberName = "Thông báo", Message = "Xóa thành công."
});
}
else
{
rs.IsSuccess = false;
rs.Errors.Add(new Error()
{
MemberName = "Thông báo", Message = "Số điện thoại này đang được sử dụng hoặc không còn tồn tại trong hệ thống. Vui lòng kiểm tra lại!."
});
}
}
return(rs);
}
public bool Copy(List <int> Ids, int userId)
{
try
{
using (db = new QMSSystemEntities())
{
var src = db.Q_UserCmdRegister.Where(x => !x.IsDeleted && Ids.Contains(x.Id)).ToList();
if (src.Count > 0)
{
Q_UserCmdRegister obj;
for (int i = 0; i < src.Count; i++)
{
obj = new Q_UserCmdRegister();
obj.UserId = userId;
obj.CmdParamId = src[i].CmdParamId;
obj.ActionParamId = src[i].ActionParamId;
obj.Param = src[i].Param;
obj.Index = src[i].Index;
obj.Note = src[i].Note;
db.Q_UserCmdRegister.Add(obj);
}
db.SaveChanges();
return(true);
}
}
}
catch (Exception)
{ }
return(false);
}
public List <ReportEvaluateModel> GetDailyReport_NotUseQMS()
{
using (var db = new QMSSystemEntities())
{
var now = DateTime.Now;
var report = new List <ReportEvaluateModel>();
report.AddRange(db.Q_User.Select(x => new ReportEvaluateModel()
{
ServiceId = x.Id, ServiceName = x.Name
}).ToList());
var ycDanhGia = db.Q_EvaluateDetail.
Where(x => !x.IsDeleted && !x.Q_Evaluate.IsDeleted).
OrderBy(x => x.Index).
Select(x => new ModelSelectItem()
{
Code = (x.EvaluateId + "_" + x.Id), Name = x.Name, Id = 0, Data = 0
}).
ToList();
if (report.Count > 0)
{
var danhgia = db.Q_UserEvaluate.Where(x => x.CreatedDate.Day == now.Day && x.CreatedDate.Month == now.Month && x.CreatedDate.Year == now.Year).ToList();
foreach (var r in report)
{
foreach (var yc in ycDanhGia)
{
var a = new ModelSelectItem();
Parse.CopyObject(yc, ref a);
a.Id = danhgia.Where(x => x.Score == yc.Code && x.UserId == r.ServiceId).Count();
r.Details.Add(a);
}
}
}
return(report);
}
}
public List <R_ReportByBusinessModel> GetWaitingTransInternal() // Số khách hàng đang chờ nội bộ
{
using (db = new QMSSystemEntities())
{
List <R_ReportByBusinessModel> list = null;
var today = DateTime.Now.Date; // chi lay phan ngay thang nam ko lay gio phut giay
//var today = DateTime.Now.AddDays(-1).Date; // Lay ngay truoc do 1 ngay
try
{
list = db.Q_DailyRequire_Detail.Where(x => !x.Q_User.IsDeleted && !x.Q_Major.IsDeleted && !x.Q_DailyRequire.Q_Service.IsDeleted && x.StatusId != null && x.Q_DailyRequire.PrintTime != null && x.Q_Status.Id == (int)eStatus.CHOXL /*&& điều kiện truy vấn nội bộ là gì*/ && EntityFunctions.TruncateTime(x.Q_DailyRequire.PrintTime) == today).GroupBy(x => x.Q_DailyRequire.ServiceId).Select(t => new R_ReportByBusinessModel()
{
ServiceId = t.Key,
ServiceName = t.Select(x => x.Q_DailyRequire.Q_Service.Name).FirstOrDefault(),
TotalWaitingTransInternal = t.Count()
}).OrderBy(x => x.ServiceId).ToList();
if (list.Count > 0)
{
int i = 1;
foreach (var item in list)
{
item.Index = i++;
//item.TotalTransTime = (item.StartTransTime.HasValue && item.EndTransTime.HasValue) ? item.EndTransTime.Value.Subtract(item.StartTransTime.Value) : (TimeSpan?)null;
}
}
return(list);
}
catch (Exception ex)
{
throw ex;
}
}
}
public bool Insert(string connectString, string str, int requireType, int _counterId)
{
using (db = new QMSSystemEntities(connectString))
{
db.Q_CounterSoftRequire.Add(new Q_CounterSoftRequire()
{
Content = str,
TypeOfRequire = requireType,
CreatedDate = DateTime.Now
});
if (requireType == (int)eCounterSoftRequireType.TVReadSound)
{
var config = db.Q_Config.FirstOrDefault(x => x.Code == eConfigCode.TVReadSound);
if (config != null && config.Value == "1")
{
db.Q_TVReadSound.Add(new Q_TVReadSound()
{
CounterId = _counterId,
Sounds = str,
CreatedAt = DateTime.Now,
UsersReaded = "0,"
});
}
}
db.SaveChanges();
return(true);
}
return(false);
}
public ResponseBase InsertOrUpdate(string connectString, Q_Evaluate obj)
{
using (db = new QMSSystemEntities(connectString))
{
var rs = new ResponseBase();
try
{
if (obj.Id == 0)
{
db.Q_Evaluate.Add(obj);
rs.IsSuccess = false;
}
else
{
var oldObj = db.Q_Evaluate.FirstOrDefault(x => x.Id == 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 bool Update(Q_Equipment model)
{
using (db = new QMSSystemEntities())
{
var obj = db.Q_Equipment.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id);
if (obj != null)
{
if (!CheckExists(model))
{
obj.Code = model.Code;
obj.Name = model.Name;
obj.Position = model.Position;
obj.EquipTypeId = model.EquipTypeId;
obj.CounterId = model.CounterId;
obj.StatusId = model.StatusId;
obj.EndTime = model.EndTime;
obj.Note = model.Note;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
return(false);
}
}
public PagedList <EvaluateDetailModel> Gets(string connectString, int type, int startIndexRecord, int pageSize, string sorting)
{
try
{
using (db = new QMSSystemEntities(connectString))
{
var pageNumber = (startIndexRecord / pageSize) + 1;
if (string.IsNullOrEmpty(sorting))
{
sorting = "Index DESC";
}
var objs = db.Q_EvaluateDetail.Where(x => !x.IsDeleted && x.EvaluateId == type).OrderBy(x => x.Index).Select(x => new EvaluateDetailModel()
{
Id = x.Id,
EvaluateId = x.EvaluateId,
Index = x.Index,
Name = x.Name,
Note = x.Note,
IsDefault = x.IsDefault,
Icon = x.Icon,
IsSendSMS = x.IsSendSMS,
SmsContent = x.SmsContent
}).ToList();
return(new PagedList <EvaluateDetailModel>(objs, pageNumber, pageSize));
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <EvaluateModel> GetWithChild(string connectString)
{
using (db = new QMSSystemEntities(connectString))
{
var parents = db.Q_Evaluate.Where(x => !x.IsDeleted).OrderBy(x => x.Index).Select(x => new EvaluateModel()
{
Id = x.Id,
Name = x.Name,
Index = x.Index
}).ToList();
if (parents.Count > 0)
{
var childs = db.Q_EvaluateDetail.Where(x => !x.IsDeleted).Select(x => new EvaluateDetailModel()
{
Id = x.Id,
Name = x.Name,
Index = x.Index,
EvaluateId = x.EvaluateId,
IsDefault = x.IsDefault,
Icon = x.Icon
}).ToList();
if (childs.Count > 0)
{
foreach (var item in parents)
{
item.Childs.AddRange(childs.Where(x => x.EvaluateId == item.Id).OrderBy(x => x.Index).ToList());
}
return(parents);
}
}
return(null);
}
}
public List <ConfigModel> Gets(string connectString, bool getall)
{
try
{
using (db = new QMSSystemEntities(connectString))
{
if (getall)
{
return(db.Q_Config.Where(x => !x.IsDeleted).Select(x => new ConfigModel()
{
Id = x.Id, Code = x.Code, Value = x.Value, Note = x.Note, IsActived = x.IsActived
}).ToList());
}
else
{
return(db.Q_Config.Where(x => !x.IsDeleted &&
x.Code != eConfigCode.TicketTemplate &&
x.Code != eConfigCode.ComportName &&
x.Code != eConfigCode.ComName_Printer &&
x.Code != eConfigCode.COM_Print
)
.Select(x => new ConfigModel()
{
Id = x.Id, Code = x.Code, Value = x.Value, Note = x.Note, IsActived = x.IsActived
}).ToList());
}
}
}
catch (Exception ex)
{
// throw ex.InnerException;
}
return(new List <ConfigModel>());
}
public Q_ReadTemplate Get(string connectString, string name)
{
using (db = new QMSSystemEntities(connectString))
{
return(db.Q_ReadTemplate.FirstOrDefault(x => !x.IsDeleted && x.Name.Trim().ToUpper().Equals(name.Trim().ToUpper())));
}
}
/// <summary>
/// ktra co dang xu lý in phiếu hay goi next hay khong ?
/// </summary>
/// <returns></returns>
public Q_CounterSoftRequire HasProcessing(string connectString, int type)
{
using (db = new QMSSystemEntities(connectString))
{
return(db.Q_CounterSoftRequire.FirstOrDefault(x => x.TypeOfRequire == type));
}
}
public int Update(Q_Counter model)
{
using (db = new QMSSystemEntities())
{
var obj = db.Q_Counter.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id);
if (obj != null)
{
if (!CheckExists(model))
{
obj.ShortName = model.ShortName;
obj.Name = model.Name;
obj.Index = model.Index;
obj.Position = model.Position;
obj.Acreage = model.Acreage;
db.SaveChanges();
return(model.Id);
}
else
{
return(0);
}
}
return(0);
}
}
public List <CounterSoftRequireModel> Gets(string connectString, int type)
{
var list = new List <CounterSoftRequireModel>();
using (db = new QMSSystemEntities(connectString))
{
var objs = db.Q_CounterSoftRequire.Where(x => x.TypeOfRequire == type).ToList();
if (objs.Count > 0)
{
for (int i = 0; i < objs.Count; i++)
{
list.Add(new CounterSoftRequireModel()
{
Id = objs[i].Id,
Content = objs[i].Content,
Type = objs[i].TypeOfRequire,
CreatedDate = objs[i].CreatedDate
});
if (objs[i].TypeOfRequire == (int)eCounterSoftRequireType.ReadSound ||
objs[i].TypeOfRequire == (int)eCounterSoftRequireType.SendNextToMainDisplay ||
objs[i].TypeOfRequire == (int)eCounterSoftRequireType.SendRecallToMainDisplay ||
objs[i].TypeOfRequire == (int)eCounterSoftRequireType.CheckUserFree)
{
db.Q_CounterSoftRequire.Remove(objs[i]);
}
}
db.SaveChanges();
}
}
return(list);
}
public List <RegisterUserCmdModel> Gets(int userId, int cmdId, int cmdParamId)
{
using (db = new QMSSystemEntities())
{
var objs = db.Q_UserCmdRegister.Where(x => !x.IsDeleted && !x.Q_User.IsDeleted && !x.Q_CommandParameter.Q_Command.IsDeleted && !x.Q_CommandParameter.IsDeleted && !x.Q_ActionParameter.Q_Action.IsDeleted && !x.Q_ActionParameter.IsDeleted && x.UserId == userId);
if (objs != null)
{
if (cmdId > 0)
{
objs = objs.Where(x => x.Q_CommandParameter.CommandId == cmdId);
}
if (cmdParamId > 0)
{
objs = objs.Where(x => x.CmdParamId == cmdParamId);
}
return(objs.Select(x => new RegisterUserCmdModel()
{
Id = x.Id,
UserId = x.UserId,
Index = x.Index,
CMDName = x.Q_CommandParameter.Q_Command.CodeHEX,
CMDParamName = x.Q_CommandParameter.Parameter,
Note = x.Note,
ActionName = x.Q_ActionParameter.Q_Action.Code,
ActionParamName = x.Q_ActionParameter.ParameterCode,
Param = x.Param
}).OrderBy(x => x.CMDName).ThenBy(x => x.Index).ToList());
}
return(new List <RegisterUserCmdModel>());
}
}
public bool Update(string connectString, Q_Service model)
{
using (db = new QMSSystemEntities(connectString))
{
var obj = db.Q_Service.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id);
if (obj != null)
{
if (!CheckExists(model))
{
obj.Name = model.Name;
obj.StartNumber = model.StartNumber;
obj.Note = model.Note;
obj.EndNumber = model.EndNumber;
obj.TimeProcess = model.TimeProcess;
obj.IsActived = model.IsActived;
obj.Code = model.Code;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
return(false);
}
}
public SendSMSModel GetRequireSendSMS()
{
using (var db = new QMSSystemEntities())
{
var report = new SendSMSModel();
report.Phones.AddRange(db.Q_RecieverSMS.Where(x => x.IsActive).Select(x => x.PhoneNumber));
//report.AddRange(db.Q_UserEvaluate.Where(x => !x.IsDeleted && x.SendSMS && !x.Q_User.IsDeleted).Select(x => new SMSModel() { UserName = x.Q_User.Name, ServiceName = x.Q_DailyRequire_Detail.Q_DailyRequire.Q_Service.Name, MajorName = x.Q_DailyRequire_Detail.Q_Major.Name, sms = x.Score }));
report.SMS.AddRange(db.Q_UserEvaluate.Where(x => !x.IsDeleted && x.SendSMS && !x.Q_User.IsDeleted).Select(x => new SMSModel()
{
UserName = x.Q_User.Name, sms = x.Score, MajorName = x.Q_DailyRequire_Detail.Q_Major.Name
}));
if (report.SMS.Count > 0)
{
var ThangDGs = db.Q_EvaluateDetail.Where(x => !x.IsDeleted && !x.Q_Evaluate.IsDeleted).ToList();
Q_EvaluateDetail found;
int[] arr;
for (int i = 0; i < report.SMS.Count; i++)
{
arr = report.SMS[i].sms.Split('_').Select(x => Convert.ToInt32(x)).ToArray();
if (arr.Length > 1)
{
found = ThangDGs.FirstOrDefault(x => x.Id == arr[1]);
report.SMS[i].sms = (found != null ? found.SmsContent : "");
}
}
db.Database.ExecuteSqlCommand("update q_userevaluate set sendsms = 0");
db.SaveChanges();
}
return(report);
}
}
public List <int> GetReadTemplateIds(int userId, string cmdCodeHex)
{
using (db = new QMSSystemEntities())
{
return(db.Q_UserCommandReadSound.Where(x => !x.IsDeleted && !x.Q_User.IsDeleted && !x.Q_Command.IsDeleted && !x.Q_ReadTemplate.IsDeleted && x.UserId == userId && x.Q_Command.CodeHEX.Trim().ToUpper().Equals(cmdCodeHex.ToUpper())).Select(x => x.ReadTemplateId).ToList());
}
}
public List <string> GetPhones(string connectString)
{
using (db = new QMSSystemEntities(connectString))
{
return(db.Q_RecieverSMS.Where(x => x.IsActive).Select(x => x.PhoneNumber).ToList());
}
}
public int Update(Q_UserCommandReadSound model)
{
using (db = new QMSSystemEntities())
{
var obj = db.Q_UserCommandReadSound.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id);
if (obj != null)
{
if (!CheckExists(model))
{
obj.UserId = model.UserId;
obj.CommandId = model.CommandId;
obj.Index = model.Index;
obj.ReadTemplateId = model.ReadTemplateId;
obj.Note = model.Note;
db.SaveChanges();
return(obj.Id);
}
else
{
return(0);
}
}
return(0);
}
}
public ResponseBase InsertOrUpdate(string connectString, Q_RecieverSMS model)
{
using (db = new QMSSystemEntities(connectString))
{
try
{
var rs = new ResponseBase();
if (CheckExists(model.Id, model.PhoneNumber.Trim().ToUpper()))
{
rs.IsSuccess = false;
rs.Errors.Add(new Error()
{
MemberName = "Insert", Message = "Số điện thoại này đã được sử dụng. Vui lòng nhập Số điện thoại khác !."
});
}
else
{
Q_RecieverSMS obj;
if (model.Id == 0)
{
obj = new Q_RecieverSMS();
Parse.CopyObject(model, ref obj);
db.Q_RecieverSMS.Add(model);
rs.IsSuccess = true;
}
else
{
obj = db.Q_RecieverSMS.FirstOrDefault(m => m.Id == model.Id);
if (obj == null)
{
rs.IsSuccess = false;
rs.Errors.Add(new Error()
{
MemberName = "Update", Message = "Dữ liệu bạn đang thao tác đã bị xóa hoặc không tồn tại. Vui lòng kiểm tra lại !."
});
}
else
{
obj.UserIds = model.UserIds;
obj.PhoneNumber = model.PhoneNumber;
obj.Note = model.Note;
obj.IsActive = model.IsActive;
obj.UserIds = model.UserIds;
rs.IsSuccess = true;
}
}
if (rs.IsSuccess)
{
db.SaveChanges();
rs.IsSuccess = true;
}
}
return(rs);
}
catch (Exception ex)
{
throw ex;
}
}
}
public Q_Works Get(string connectString, int WorkId)
{
using (db = new QMSSystemEntities(connectString))
{
return(db.Q_Works.FirstOrDefault(x => !x.IsDeleted && x.Id == WorkId));
}
}
public Q_User Get(string connectString, string userName, string password)
{
using (db = new QMSSystemEntities(connectString))
{
return(db.Q_User.Where(x => !x.IsDeleted && x.UserName.Trim().ToUpper().Equals(userName) && x.Password.Trim().ToUpper().Equals(password)).FirstOrDefault());
}
}
public List <ReadTemplateModel> GetsForMain(string connectString)
{
using (db = new QMSSystemEntities(connectString))
{
var objs = db.Q_ReadTemplate.Where(x => !x.IsDeleted).Select(x => new ReadTemplateModel()
{
Id = x.Id, Name = x.Name, LanguageId = x.LanguageId
}).ToList();
if (objs.Count > 0)
{
int[] Ids = objs.Select(x => x.Id).ToArray();
var details = db.Q_ReadTemp_Detail.Where(x => !x.IsDeleted && !x.Q_ReadTemplate.IsDeleted && Ids.Contains(x.ReadTemplateId)).Select(x => new ReadTemplateDetailModel()
{
Id = x.Id, Index = x.Index, ReadTemplateId = x.ReadTemplateId, SoundId = x.SoundId
}).OrderBy(x => x.Index).ToList();
if (details.Count > 0)
{
for (int i = 0; i < objs.Count; i++)
{
objs[i].Details.AddRange(details.Where(x => x.ReadTemplateId == objs[i].Id).OrderBy(x => x.Index));
}
}
return(objs);
}
return(new List <ReadTemplateModel>());
}
}
public Q_PrintTicket Get(string connectString, int objId)
{
using (db = new QMSSystemEntities(connectString))
{
return(db.Q_PrintTicket.FirstOrDefault(x => x.Id == objId));
}
}
public void AutoLogin(string connectString, string listAuto)
{
using (var db = new QMSSystemEntities(connectString))
{
var listUser = listAuto.Split(',').ToArray();
if (listUser != null && listUser.Length > 0)
{
DateTime now = DateTime.Now;
var logins = (from x in db.Q_Login where x.StatusId == (int)eStatus.LOGIN select x).ToList();
for (int i = 0; i < listUser.Length; i++)
{
var info = listUser[i].Split('-').Select(x => Convert.ToInt32(x)).ToArray();
if (info.Length == 2)
{
var found = logins.FirstOrDefault(x => x.UserId == info[0]);
if (found == null)
{
db.Q_Login.Add(new Q_Login()
{
UserId = info[0],
EquipCode = info[1],
StatusId = (int)eStatus.LOGIN,
Date = now
});
}
}
}
db.SaveChanges();
}
}
}
