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