public APS.BusinessEntity.Models.Appointment.AppointmentModel GetAppointmentDetails(string UserName) { APSEntities dbContext = new APSEntities(); UserInfoModel userInfo = new UserInfoModel(); userInfo.UserName = UserName; using (AuthenticationRepository authRepo = new AuthenticationRepository()) { userInfo = authRepo.GetUserInfoDetails(userInfo); } var appointments = dbContext.V_APPOINTMENT_DETAILS.Where(i => i.APP_USERNAME == UserName).FirstOrDefault(); if (appointments != null) { var model = appointments.ToAppointmentModel(); model.UserInfoDetails = userInfo; return(model); } else { APS.BusinessEntity.Models.Appointment.AppointmentModel model = new APS.BusinessEntity.Models.Appointment.AppointmentModel(); model.IsAppointmentAvailable = false; model.UserInfoDetails = userInfo; return(model); } }
private static void DeleteJobsByAssetId() { Console.Write("Please enter the asset id: "); string s = Console.ReadLine(); int assetId; if (!Int32.TryParse(s, out assetId)) { Console.WriteLine("Invalid asset id"); return; } using (APSEntities db = new APSEntities(DBHelper.GetConnectionString())) { var jobs = (from job in db.APSQueuedJob where job.AssetId == assetId select job); Console.WriteLine(string.Format("Found {0} jobs", jobs.Count())); foreach (APSQueuedJob job in jobs) { db.DeleteObject(job); Console.WriteLine("Deleted job with id: " + job.QueuedJobId); } db.SaveChanges(); Console.Write("All done"); } }
private static void ListJobs() { using (APSEntities db = new APSEntities(DBHelper.GetConnectionString())) { var jobs = (from job in db.APSQueuedJob orderby job.DateAdded descending select job).Take(15); Console.Write("Job ID".PadRight(10)); Console.Write("Asset ID".PadRight(10)); Console.Write("Date Added".PadRight(25)); Console.Write("Status".PadRight(40)); Console.Write(Environment.NewLine); Console.WriteLine("-----------------------------------------------------------------"); Console.Write(Environment.NewLine); foreach (var job in jobs) { Console.Write(job.QueuedJobId.ToString().PadRight(10)); Console.Write(job.AssetId.ToString().PadRight(10)); Console.Write(job.DateAdded.ToString("dd MMM yy HH:mm").PadRight(25)); //Console.Write(job.Message.PadRight(40)); Console.Write(job.Status.ToString().PadRight(40)); Console.Write(Environment.NewLine); } } }
public bool AuthenticateUser(AuthenticationModel authModel) { bool isAuthenticate = false; APSEntities dbContext = new APSEntities(); var objUser = dbContext.APS_USERS.Where(i => i.USER_NAME == authModel.UserName && i.USER_PASSWORD == authModel.UserPassword).ToList(); if (objUser != null && objUser.Count() > 0) { isAuthenticate = true; } return(isAuthenticate); }
/// <summary> /// Check is user login to system for first time /// </summary> /// <param name="authModel"></param> /// <returns></returns> public bool IsFirstLogin(UserModel authModel) { bool isfirstLogin = false; APSEntities dbContext = new APSEntities(); var objUser = dbContext.APS_USERS.Where(i => i.USER_NAME == authModel.UserName).ToList(); if (objUser != null && objUser.Count() == 0) { isfirstLogin = true; } return(isfirstLogin); }
public UserModel UpdateLoginFailedCount(UserModel model) { APSEntities dbContext = new APSEntities(); var selectedEntity = dbContext.APS_USERS.FirstOrDefault(p => p.USER_NAME == model.UserName); selectedEntity.USER_NAME = model.UserName; selectedEntity.LOGIN_FAIL_ATTEMPT = model.LoginFailAttemptCount; selectedEntity.LAST_UPDATED_BY = model.LastUpdatedBy; selectedEntity.LAST_UPDATED_TIME = DateTime.Now; dbContext.Entry(selectedEntity).State = EntityState.Modified; dbContext.SaveChanges(); return(selectedEntity.ToUserModel()); }
public ForgetPasswordModel UpdateChangePasswordFailedCount(ForgetPasswordModel model) { APSEntities dbContext = new APSEntities(); var selectedEntity = dbContext.APS_USERS.FirstOrDefault(p => p.USER_NAME == model.UserName); selectedEntity.USER_NAME = model.UserName; selectedEntity.PWD_CHANGE_FAIL_ATTMPT = model.PasswordChangeFailAttempt; selectedEntity.LAST_UPDATED_BY = model.LastUpdatedBy; selectedEntity.LAST_UPDATED_TIME = DateTime.Now; dbContext.Entry(selectedEntity).State = EntityState.Modified; dbContext.SaveChanges(); return(model); }
public void ActivityLogInsert(UserActivityLogModel activityModel) { APSEntities dbContext = new APSEntities(); var objUserActivity = new APS_USER_ACT_LOG { USER_NAME = activityModel.User_Name, USER_ACT_LOG = activityModel.User_Act_Log, CREATED_BY = activityModel.CreatedBy, CREATED_TIME = activityModel.CreatedTime }; dbContext.APS_USER_ACT_LOG.Add(objUserActivity); dbContext.SaveChanges(); }
public TimeSlotModel GetTimeSlotDetails(int timeSlotID) { APSEntities dbContext = new APSEntities(); var tiemslots = dbContext.APS_TIMESLOT.Where(i => i.TIMESLOT_ID == timeSlotID).FirstOrDefault(); if (tiemslots != null) { return(tiemslots.ToTimeSlotModel()); } else { return(null); } }
public UserInfoModel GetUserInfoDetails(UserInfoModel model) { APSEntities dbContext = new APSEntities(); var objUser = dbContext.APS_USER_INFO.Where(i => i.USER_NAME == model.UserName).ToArray(); if (objUser != null && objUser.Count() > 0) { return(objUser.Select(u => u.ToUserInfoModel()).FirstOrDefault()); } else { throw new Exception(); } }
public IEnumerable <TimeSlotModel> GetAppointmentTimeSlots(string dayOfWeek) { dayOfWeek = DateTime.Now.DayOfWeek.ToString(); APSEntities dbContext = new APSEntities(); var objTimeSlots = dbContext.V_TIMESLOT_DETAILS.Where(i => i.TIMESLOT_WEEKDAY == dayOfWeek).ToArray(); if (objTimeSlots != null && objTimeSlots.Count() > 0) { return(objTimeSlots.Select(u => u.ToTimeSlotDetailsModel())); } else { return(null); } }
public UserModel CreateNewUser(UserModel model) { APSEntities dbContext = new APSEntities(); var objuser = new APS_USERS { USER_NAME = model.UserName, USER_PASSWORD = model.UserPassword, PWD_QUES_ID = model.SecretQuestionID, PWD_QUES_ANSWER = model.SecretQuestionAnswer, IS_DELETED = model.IsDeleted ? "0" : "1", LOGIN_FAIL_ATTEMPT = model.LoginFailAttemptCount, CREATED_BY = model.CreatedBy, CREATED_TIME = DateTime.Now, LAST_UPDATED_BY = model.LastUpdatedBy, LAST_UPDATED_TIME = DateTime.Now }; dbContext.APS_USERS.Add(objuser); dbContext.SaveChanges(); model.UserID = objuser.USER_ID; // create user dummy info var objUser_info = new APS_USER_INFO { USER_ID = model.UserID, USER_NAME = model.UserName, USER_FIRST_NAME = "DUMMY", USER_LAST_NAME = model.UserName, USER_MOBILE_NO = "86346745", USER_DATE_OF_BIRTH = DateTime.ParseExact("21-07-1980", "dd-mm-yyyy", CultureInfo.InvariantCulture), USER_EMAIL_ADDR = ConfigurationManager.AppSettings.Get("DummyEmailID").ToString(), CASE_OFFICER_NAME = "CO" + " " + model.UserName, CASE_OFFICER_EMAIL = ConfigurationManager.AppSettings.Get("DummyEmailID").ToString(), CASE_OFFICER_MOBILE_NO = "86346745", CREATED_BY = model.CreatedBy, CREATED_TIME = DateTime.Now, LAST_UPDATED_BY = model.LastUpdatedBy, LAST_UPDATED_TIME = DateTime.Now }; dbContext.APS_USER_INFO.Add(objUser_info); dbContext.SaveChanges(); return(model); }
public UserModel ChangeUserPassword(ChangePasswordModel model) { APSEntities dbContext = new APSEntities(); var selectedEntity = dbContext.APS_USERS.FirstOrDefault(p => p.USER_NAME == model.UserName); selectedEntity.USER_NAME = model.UserName; selectedEntity.USER_PASSWORD = model.UserPassword; selectedEntity.PWD_QUES_ID = model.PasswordQuestionID; selectedEntity.PWD_QUES_ANSWER = model.PasswordQuesAnswer; selectedEntity.LAST_UPDATED_BY = model.LastUpdatedBy; selectedEntity.LAST_UPDATED_TIME = DateTime.Now; dbContext.Entry(selectedEntity).State = EntityState.Modified; dbContext.SaveChanges(); UserModel userModel = ToUserModelFromChangePassword(model); return(userModel); }
/// <summary> /// 根据产品大类获取产品类别id /// </summary> /// <param name="str">大类id集</param> /// <returns></returns> public static List <int> GetProductTypeList(string str) { List <int> fidLs = new List <int>(); if (!string.IsNullOrEmpty(str)) { string[] fidsArry = str.Split(','); foreach (var item in fidsArry) { fidLs.Add(Convert.ToInt32(item)); } } List <int> ls = new List <int>(); if (fidLs.Count > 0) { ls = new APSEntities().PRODUCTTYPEs.Where(c => fidLs.Contains(c.PARENTID.Value)).Select(s => s.ID).Distinct().ToList(); fidLs.AddRange(ls); } return(fidLs); }
public List <IOSapi.ViewModels.CapacityChartRow> GetCapacity(DateTime starDate, int capIncOut, int loadingIncOut, int timeSpan, int timeType, int unitType, string fids = "") { List <IOSapi.ViewModels.CapacityChartRow> CapacityChartRowList = new List <IOSapi.ViewModels.CapacityChartRow>(); try { List <int> fidLs = new List <int>(); if (!string.IsNullOrEmpty(fids)) { string[] fidsArry = fids.Split(','); foreach (var item in fidsArry) { fidLs.Add(Convert.ToInt32(item)); } } else { int[] fidsArry = GetAllowedFactoryIDs(); foreach (var item in fidsArry) { fidLs.Add(item); } } APSEntities db = new APSEntities(); var query = db.FACTORies.OrderBy(c => c.ID).Where(c => (fids == "" ? true : fidLs.Contains(c.ID))).Select(c => new { ID = c.ID, Code = c.CODE, Name = c.NAME, Description = c.DESCRIPTION, IsOutside = c.ISOUTSIDE, Capacity = c.CAPACITY }).ToList(); if (query == null) { return(CapacityChartRowList); } List <Factory> LstFactory = new List <Factory>(); foreach (var item in query) { Factory Factory = new Factory(); Factory.ID = item.ID; Factory.Name = item.Name; Factory.Description = item.Description; Factory.IsOutside = item.IsOutside == 1; Factory.Code = item.Code; Factory.Capacity = item.Capacity == null ? 0 : item.Capacity.Value; LstFactory.Add(Factory); } DateTime endTime = GetDateEnd(starDate, timeSpan, timeType); AMOData.Settings.UserSetting.Load(0); //加载用户参数 AMOData.Settings.SysSetting.Load(); //加载系统参数 AMOData.Settings.ImpSetting.Load(); //实施参数 MacroDataCreator mdc = new MacroDataCreator(LstFactory, starDate, endTime); ChartParameter.LstLoadingToolTip = new List <string>() { "PoPlanLoading", "PoLoading", "VirPlanLoading", "VirPoLoading" }; ChartParameter.LstLoadingColor = new List <Color>() { AMOData.Settings.UserSetting.PlanLoadingColor, AMOData.Settings.UserSetting.PoLoadingColor, AMOData.Settings.UserSetting.VirPlanLoadingColor, AMOData.Settings.UserSetting.VirPoLoadingColor }; ChartParameter.OutCapTooltip = "OutCapacity"; ChartParameter.OtCapTooltip = "OtCapacity"; ChartParameter.TotalCapTooltip = "TotalCapacity"; ChartParameter.NormalCapTooltip = "NormalCapacity"; //for (int i = 0; i < 4; i++) //{ // ChartParameter.LstLoadingToolTip.Add((i + 1).ToString()); // ChartParameter.LstLoadingColor.Add(Color.Red); //} mdc.InitData(); List <string> chartHeader = new List <string>() { "工厂" }; //List<ProductType> pt = ProductType.GetList(null); IOS.DBUtility.Filter filter = new IOS.DBUtility.Filter(); List <ProductType> pt = ProductType.GetList(filter); List <WorkShop> ws = new List <WorkShop>(); ws.Add(new WorkShop() { ID = -1 }); // List <ChartDataRow> datas = mdc.GetUIData(LstFactory, ws, pt, "total", 0, 0, Convert.ToBoolean(capIncOut), Convert.ToBoolean(loadingIncOut), chartHeader, (EmDateCycleType)timeType, (MacroUnitTypes)unitType, 0); int rowIndex = 0; foreach (var row in datas) { rowIndex++; if (rowIndex < datas.Count) { IOSapi.ViewModels.CapacityChartRow charRow = new ViewModels.CapacityChartRow(); charRow.Name = ""; charRow.CapacityChartDataList = new List <ViewModels.CapacityChartData>(); foreach (var blok in row.LstDataBlock) { IOSapi.ViewModels.CapacityChartData capacityChartData = new ViewModels.CapacityChartData(); capacityChartData.dataTime = blok.OfColumn.ToString(); capacityChartData.capData = new List <ViewModels.ChartDataItem>(); capacityChartData.loadingData = new List <ViewModels.ChartDataItem>(); if (string.IsNullOrEmpty(charRow.Name)) { if (blok.CapacityData.Source != null && blok.CapacityData.Source.Count > 0) { charRow.Name = blok.CapacityData.Source[0].FactoryName; } } //产能数据 foreach (var item in blok.CapacityData.DataItem) { ViewModels.ChartDataItem chartDataItem = new ViewModels.ChartDataItem(); chartDataItem.name = Enum.GetName(typeof(ChartItemType), item.ItemType); chartDataItem.value = Math.Round(item.Value, 0); chartDataItem.color = string.Format("#{0:X2}{1:X2}{2:X2}", item.ItemColor.R, item.ItemColor.G, item.ItemColor.B); capacityChartData.capData.Add(chartDataItem); } //负载 foreach (var item in blok.LoadingData.DataItem) { ViewModels.ChartDataItem chartDataItem = new ViewModels.ChartDataItem(); chartDataItem.name = Enum.GetName(typeof(ChartItemType), item.ItemType); chartDataItem.value = Math.Round(item.Value, 0); chartDataItem.color = string.Format("#{0:X2}{1:X2}{2:X2}", item.ItemColor.R, item.ItemColor.G, item.ItemColor.B); capacityChartData.loadingData.Add(chartDataItem); } charRow.CapacityChartDataList.Add(capacityChartData); } CapacityChartRowList.Add(charRow); } else { IOSapi.ViewModels.CapacityChartRow charRow = new ViewModels.CapacityChartRow(); charRow.Name = "汇总"; charRow.CapacityChartDataList = new List <ViewModels.CapacityChartData>(); foreach (var blok in row.LstDataBlock) { IOSapi.ViewModels.CapacityChartData capacityChartData = new ViewModels.CapacityChartData(); capacityChartData.dataTime = blok.OfColumn.ToString(); capacityChartData.capData = new List <ViewModels.ChartDataItem>(); capacityChartData.loadingData = new List <ViewModels.ChartDataItem>(); //产能数据 foreach (var item in blok.CapacityData.DataItem) { ViewModels.ChartDataItem chartDataItem = new ViewModels.ChartDataItem(); chartDataItem.name = item.ItemText; chartDataItem.value = Math.Round(item.Value, 0); chartDataItem.color = string.Format("#{0:X2}{1:X2}{2:X2}", item.ItemColor.R, item.ItemColor.G, item.ItemColor.B); capacityChartData.capData.Add(chartDataItem); } //负载 foreach (var item in blok.LoadingData.DataItem) { ViewModels.ChartDataItem chartDataItem = new ViewModels.ChartDataItem(); chartDataItem.name = item.ItemText; chartDataItem.value = Math.Round(item.Value, 0); chartDataItem.color = string.Format("#{0:X2}{1:X2}{2:X2}", item.ItemColor.R, item.ItemColor.G, item.ItemColor.B); capacityChartData.loadingData.Add(chartDataItem); } charRow.CapacityChartDataList.Add(capacityChartData); } CapacityChartRowList.Add(charRow); } } } catch (Exception) { return(null); } return(CapacityChartRowList); }
public APS.BusinessEntity.Models.Appointment.AppointmentModel BookOrChangeAppointment(APS.BusinessEntity.Models.Appointment.AppointmentModel appModel) { try { UserInfoModel userInfo = new UserInfoModel(); userInfo.UserName = appModel.App_UserName; using (AuthenticationRepository authRepo = new AuthenticationRepository()) { userInfo = authRepo.GetUserInfoDetails(userInfo); } APS.BusinessEntity.Models.Appointment.AppointmentModel appointModel = new APS.BusinessEntity.Models.Appointment.AppointmentModel(); APSEntities dbContext = new APSEntities(); DateTime appDt; DateTime.TryParse(appModel.App_Date, out appDt); if (!appModel.IsAppointmentAvailable) { var objApp = new APS_APPOINTMENT { APP_DATE = appDt, APP_TIMESLOT_ID = appModel.App_TimeSlot_ID, APP_USERNAME = appModel.App_UserName, CREATED_BY = appModel.App_UserName, CREATED_ON = DateTime.Now, LAST_UPDATED_BY = appModel.App_UserName, LAST_UPDATED_ON = DateTime.Now, APP_STATUS = BusinessConstants.AppointmetStatus.Active, APP_CHANGE_CNT = 0 }; dbContext.APS_APPOINTMENT.Add(objApp); dbContext.SaveChanges(); appModel.App_ID = objApp.APP_ID; } else { var selectedEntity = dbContext.APS_APPOINTMENT.FirstOrDefault(p => p.APP_ID == appModel.App_ID); if (appModel.App_Change_Count <= 3) { selectedEntity.APP_CHANGE_CNT = appModel.App_Change_Count; selectedEntity.APP_TIMESLOT_ID = appModel.App_TimeSlot_ID; selectedEntity.LAST_UPDATED_BY = appModel.App_UserName; selectedEntity.LAST_UPDATED_ON = DateTime.Now; } else if (appModel.App_Change_Count > 3) { selectedEntity.APP_CHANGE_CNT = appModel.App_Change_Count; selectedEntity.LAST_UPDATED_BY = appModel.App_UserName; selectedEntity.LAST_UPDATED_ON = DateTime.Now; } dbContext.Entry(selectedEntity).State = EntityState.Modified; dbContext.SaveChanges(); } var appointments = dbContext.V_APPOINTMENT_DETAILS.Where(i => i.APP_USERNAME == appModel.App_UserName).FirstOrDefault(); if (appointments != null) { appointModel = appointments.ToAppointmentModel(); } appointModel.UserInfoDetails = userInfo; return(appointModel); } catch (Exception ex) { throw ex; } }
/// <summary> /// Get all password questions /// </summary> /// <returns></returns> public IEnumerable <PasswordQuestionsModel> GetPasswordQuestions() { APSEntities dbContext = new APSEntities(); return(dbContext.APS_PWD_QUESTIONS.ToArray().Select(p => p.ToPasswordQuestionsModel())); }