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