public static RequestResult GetDetailViewModel(string solutionId, Account account)
{
RequestResult result = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var solution = context.Solutions.First(x => x.SolutionId == new Guid(solutionId));
result.ReturnData(new DetailViewModel()
{
SolutionId = solution.SolutionId.ToString(),
Permission = account.OrganizationPermission(solution.OrganizationId),
OrganizationId = solution.OrganizationId.ToString(),
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(solution.OrganizationId),
SolutionType = solution.Type,
SId = solution.SId,
Name = solution.Name
});
}
}
catch (Exception ex)
{
var err = new Error(MethodBase.GetCurrentMethod(), ex);
Logger.Log(err);
result.ReturnError(err);
}
return(result);
}
public static RequestResult GetDetailViewModel(string abnormalReasonId, Account account)
{
RequestResult result = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var abnormalReason = context.AbnormalReasons.Include("Solutions").First(x => x.AbnormalReasonId == new Guid(abnormalReasonId));
result.ReturnData(new DetailViewModel()
{
AbnormalReasonId = abnormalReason.AbnormalReasonId.ToString(),
Permission = account.OrganizationPermission(abnormalReason.OrganizationId),
OrganizationId = abnormalReason.OrganizationId.ToString(),
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(abnormalReason.OrganizationId),
Type = abnormalReason.Type,
ARId = abnormalReason.ARId,
Name = abnormalReason.Name,
SolutionNames = abnormalReason.Solutions.Select(x => x.Name).ToList()
});
}
}
catch (Exception ex)
{
var err = new Error(MethodBase.GetCurrentMethod(), ex);
Logger.Log(err);
result.ReturnError(err);
}
return(result);
}
public static RequestResult GetDetailViewModel(string equipmentSpecificationId, Account account)
{
RequestResult result = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var specification = context.ESpecifications.First(x => x.ESpecificationId == new Guid(equipmentSpecificationId));
result.ReturnData(new DetailViewModel()
{
EquipmentSpecificationId = specification.ESpecificationId.ToString(),
Permission = account.OrganizationPermission(specification.OrganizationId),
OrganizationId = specification.OrganizationId.ToString(),
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(specification.OrganizationId),
EquipmentType = specification.EquipmentType,
Name = specification.Name,
EquipmentSpecificationOptonNameList = context.ESOptions.Where(x => x.ESpecificationId == specification.ESpecificationId).OrderBy(x => x.Seq).Select(x => x.Name).ToList()
});
}
}
catch (Exception ex)
{
var err = new Error(MethodBase.GetCurrentMethod(), ex);
Logger.Log(err);
result.ReturnError(err);
}
return(result);
}
public static RequestResult GetCopyFormModel(string abnormalReasonId)
{
RequestResult result = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var abnormalReason = context.AbnormalReasons.Include("Solutions").First(x => x.AbnormalReasonId == new Guid(abnormalReasonId));
var model = new CreateFormModel()
{
OrganizationId = abnormalReason.OrganizationId.ToString(),
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(abnormalReason.OrganizationId),
Types = new List <SelectListItem>()
{
Define.DefaultSelectListItem(Resources.Resource.Select),
new SelectListItem()
{
Text = Resources.Resource.Create + "...",
Value = Define.New
}
},
SolutionModels = abnormalReason.Solutions.Select(x => new SolutionModel
{
SolutionId = x.SolutionId.ToString(),
Type = x.Type,
SId = x.SId,
Name = x.Name,
}).OrderBy(x => x.Type).ThenBy(x => x.SId).ToList(),
FormInput = new FormInput()
{
Type = abnormalReason.Type
}
};
var upStreamOrganizationIds = OrganizationDataAccessor.GetUpStreamOrganizationIds(abnormalReason.OrganizationId, true);
model.Types.AddRange(context.AbnormalReasons.Where(x => upStreamOrganizationIds.Contains(x.OrganizationId)).Select(x => x.Type).Distinct().OrderBy(x => x).Select(x => new SelectListItem
{
Value = x,
Text = x
}).ToList());
model.Types.First(x => x.Value == abnormalReason.Type).Selected = true;
result.ReturnData(model);
}
}
catch (Exception ex)
{
var err = new Error(MethodBase.GetCurrentMethod(), ex);
Logger.Log(err);
result.ReturnError(err);
}
return(result);
}
public static RequestResult GetEditFormModel(string solutionId)
{
RequestResult result = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var solution = context.Solutions.First(x => x.SolutionId == new Guid(solutionId));
var model = new EditFormModel()
{
SolutionId = solution.SolutionId.ToString(),
OrganizationId = solution.OrganizationId.ToString(),
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(solution.OrganizationId),
SolutionTypes = new List <SelectListItem>()
{
Define.DefaultSelectListItem(Resources.Resource.Select),
new SelectListItem()
{
Text = Resources.Resource.Create + "...",
Value = Define.New
}
},
FormInput = new FormInput()
{
Type = solution.Type,
SId = solution.SId,
Name = solution.Name
}
};
var upStreamOrganizationIds = OrganizationDataAccessor.GetUpStreamOrganizationIds(new Guid(model.OrganizationId), true);
model.SolutionTypes.AddRange(context.Solutions.Where(x => upStreamOrganizationIds.Contains(x.OrganizationId)).Select(x => x.Type).Distinct().OrderBy(x => x).Select(x => new SelectListItem
{
Value = x,
Text = x
}).ToList());
if (!string.IsNullOrEmpty(model.FormInput.Type) && model.SolutionTypes.Any(x => x.Value == model.FormInput.Type))
{
model.SolutionTypes.First(x => x.Value == model.FormInput.Type).Selected = true;
}
result.ReturnData(model);
}
}
catch (Exception ex)
{
var err = new Error(MethodBase.GetCurrentMethod(), ex);
Logger.Log(err);
result.ReturnError(err);
}
return(result);
}
public static RequestResult GetDetailViewModel(string checkpointId, Account account)
{
RequestResult result = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var checkpoint = context.Checkpoints.Include("CheckItems").First(x => x.CheckpointId == new Guid(checkpointId));
result.ReturnData(new DetailViewModel()
{
CheckpointId = checkpoint.CheckpointId.ToString(),
Permission = account.OrganizationPermission(checkpoint.OrganizationId),
OrganizationUniqueID = checkpoint.OrganizationId.ToString(),
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(checkpoint.OrganizationId),
CId = checkpoint.CId,
Name = checkpoint.Name,
IsFeelItemDefaultNormal = checkpoint.IsFeelItemDefaultNormal,
TagId = checkpoint.TagId,
Remark = checkpoint.Remark,
CheckItemModels = checkpoint.CheckItems.Select(x=>new CheckItemModel()
{
CheckItemId=x.CheckItemId.ToString(),
CIId=x.CIId,
Name=x.Name,
Type=x.Type,
IsFeelItem=x.IsFeelItem,
IsAccumulation=x.IsAccumulation,
IsInherit=x.IsInherit,
OriLowerLimit=x.LowerLimit,
OriLowerAlertLimit=x.LowerAlertLimit,
OriUpperAlertLimit=x.UpperAlertLimit,
OriUpperLimit=x.UpperLimit,
OriAccumulationBase=x.AccumulationBase,
OriUnit=x.Unit,
OriRemark=x.Remark,
LowerLimit=x.LowerLimit,
LowerAlertLimit=x.LowerAlertLimit,
UpperAlertLimit=x.UpperAlertLimit,
UpperLimit=x.UpperLimit,
AccumulationBase=x.AccumulationBase,
Unit=x.Unit,
Remark=x.Remark
}).OrderBy(x=>x.Type).ThenBy(x=>x.CIId).ToList()
});
}
}
catch (Exception ex)
{
var err = new Error(MethodBase.GetCurrentMethod(), ex);
Logger.Log(err);
result.ReturnError(err);
}
return result;
}
public static RequestResult GetCopyFormModel(string equipmentSpecificationId)
{
RequestResult result = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var spec = context.ESpecifications.First(x => x.ESpecificationId == new Guid(equipmentSpecificationId));
var model = new CreateFormModel()
{
OrganizationId = spec.OrganizationId.ToString(),
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(spec.OrganizationId),
EquipmentTypeSelectItems = new List <SelectListItem>()
{
Define.DefaultSelectListItem(Resources.Resource.Select),
new SelectListItem()
{
Text = string.Format("{0}...", Resources.Resource.Create),
Value = Define.New
}
},
FormInput = new FormInput()
{
EquipmentType = spec.EquipmentType
},
EquipmentSpecificationOptionModels = context.ESOptions.Where(x => x.ESpecificationId == spec.ESpecificationId).Select(x => new EquipmentSpecificationOptionModel
{
Name = x.Name,
Seq = x.Seq
}).OrderBy(x => x.Seq).ToList()
};
var upStreamOrganizationIds = OrganizationDataAccessor.GetUpStreamOrganizationIds(spec.OrganizationId, true);
model.EquipmentTypeSelectItems.AddRange(context.ESpecifications.Where(x => upStreamOrganizationIds.Contains(x.OrganizationId)).Select(x => x.EquipmentType).Distinct().OrderBy(x => x).Select(x => new SelectListItem
{
Value = x,
Text = x
}).ToList());
model.EquipmentTypeSelectItems.First(x => x.Value == spec.EquipmentType).Selected = true;
result.ReturnData(model);
}
}
catch (Exception ex)
{
var err = new Error(MethodBase.GetCurrentMethod(), ex);
Logger.Log(err);
result.ReturnError(err);
}
return(result);
}
public ActionResult Create(string orgnaizationId)
{
Session["ControlPointFormAction"] = Define.EnumFormAction.Create;
Session["ControlPointCreateFormModel"] = new CreateFormModel()
{
OrganizationId = orgnaizationId,
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(new Guid(orgnaizationId))
};
return(PartialView("_Create", Session["ControlPointCreateFormModel"]));
}
public static RequestResult GetCreateFormModel(string organizationId, string materialType)
{
RequestResult requestResult = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var createFormModel = new CreateFormModel()
{
OrganizationId = organizationId,
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(new Guid(organizationId)),
MaterialTypeSelectItems = new List <SelectListItem>()
{
Define.DefaultSelectListItem(Resources.Resource.Select),
new SelectListItem()
{
Text = string.Format("{0}...", Resources.Resource.Create),
Value = Define.New
}
},
FormInput = new FormInput()
{
MaterialType = materialType
}
};
var upStreamOrganizationIds = OrganizationDataAccessor.GetUpStreamOrganizationIds(new Guid(organizationId), true);
createFormModel.MaterialTypeSelectItems.AddRange(context.MSpecifications.Where(x => upStreamOrganizationIds.Contains(x.OrganizationId)).Select(x => x.MaterialType).Distinct().OrderBy(x => x).Select(x => new SelectListItem
{
Value = x,
Text = x
}).ToList());
if (!string.IsNullOrEmpty(materialType) && createFormModel.MaterialTypeSelectItems.Any(x => x.Value == materialType))
{
createFormModel.MaterialTypeSelectItems.First(x => x.Value == materialType).Selected = true;
}
requestResult.ReturnData(createFormModel);
}
}
catch (Exception ex)
{
var err = new Error(MethodBase.GetCurrentMethod(), ex);
Logger.Log(err);
requestResult.ReturnError(err);
}
return(requestResult);
}
public static RequestResult GetDetailViewModel(string materialId, Account account)
{
RequestResult requestResult = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var material = context.Materials.Include("MaterialSpecificationOptions").Where(m => m.MaterialId == new Guid(materialId)).FirstOrDefault();
var materialSpecificationIds = material.MaterialSpecificationOptions.Select(ms => ms.MSpecificationId);
var detailViewModel = new DetailViewModel()
{
Permission = account.OrganizationPermission(material.OrganizationId),
MaterialId = material.MaterialId.ToString(),
OrganizationId = material.OrganizationId.ToString(),
ParentOrganizationName = OrganizationDataAccessor.GetOrganizationFullName(material.OrganizationId),
MaterialType = material.MaterialType,
MId = material.MId,
MaterialName = material.Name,
Quantity = material.Quantity,
MaterialSpecificationModels = context.MSpecifications.Where(ms => materialSpecificationIds.Contains(ms.MSpecificationId)).Select(ms => new MaterialSpecificationModel
{
MaterialSpecificationId = ms.MSpecificationId.ToString(),
Name = ms.Name,
MaterialSpecificationOptionId = context.MaterialSpecificationOptions.Where(x => x.MSpecificationId == ms.MSpecificationId).Select(x => x.MSOptionId).FirstOrDefault().ToString(),
Value = context.MaterialSpecificationOptions.Where(x => x.MSpecificationId == ms.MSpecificationId).Select(x => x.Value).FirstOrDefault().ToString(),
Seq = context.MaterialSpecificationOptions.Where(x => x.MSpecificationId == ms.MSpecificationId).Select(x => x.Seq).FirstOrDefault(),
MaterialSpecificationOptionModels = context.MSOptions.Where(x => x.MSpecificationId == ms.MSpecificationId).Select(mso => new MaterialSpecificationOptionModel
{
MaterialSpecificationOptionId = mso.MSOptionId.ToString(),
MaterialSpecificationId = mso.MSpecificationId.ToString(),
Name = mso.Name,
Seq = mso.Seq
}).OrderBy(mso => mso.Seq).ToList()
}).OrderBy(ms => ms.Seq).ToList()
};
//
requestResult.ReturnData(detailViewModel);
}
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
//throw;
}
return(requestResult);
}
public static RequestResult Query(QueryParameters queryParameters, Account account)
{
RequestResult result = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var downStreamOrganizationIds = OrganizationDataAccessor.GetDownStreamOrganizationIds(new Guid(queryParameters.OrganizationId), true);
var query = context.ESpecifications.Where(x => downStreamOrganizationIds.Contains(x.OrganizationId) && account.QueryableOrganizationIds.Contains(x.OrganizationId)).AsQueryable();
if (!string.IsNullOrEmpty(queryParameters.EquipmentType))
{
query = query.Where(x => x.OrganizationId == new Guid(queryParameters.OrganizationId) && x.EquipmentType == queryParameters.EquipmentType);
}
if (!string.IsNullOrEmpty(queryParameters.Keyword))
{
query = query.Where(x => x.Name.Contains(queryParameters.Keyword));
}
result.ReturnData(new GridViewModel()
{
OrganizationId = queryParameters.OrganizationId,
Permission = account.OrganizationPermission(new Guid(queryParameters.OrganizationId)),
EquipmentType = queryParameters.EquipmentType,
FullOrganizationName = OrganizationDataAccessor.GetOrganizationFullName(new Guid(queryParameters.OrganizationId)),
OrganizationName = OrganizationDataAccessor.GetOrganizationName(new Guid(queryParameters.OrganizationId)),
Items = query.ToList().Select(x => new GridItem()
{
EquipmentSpecificationId = x.ESpecificationId.ToString(),
Permission = account.OrganizationPermission(x.OrganizationId),
OrganizationName = OrganizationDataAccessor.GetOrganizationName(x.OrganizationId),
EquipmentType = x.EquipmentType,
Name = x.Name
}).OrderBy(x => x.OrganizationName).ThenBy(x => x.EquipmentType).ThenBy(x => x.Name).ToList()
});
}
}
catch (Exception ex)
{
var err = new Error(MethodBase.GetCurrentMethod(), ex);
Logger.Log(err);
result.ReturnError(err);
}
return(result);
}
public static RequestResult GetCopyFormModel(Guid materialId)
{
RequestResult requestResult = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var material = context.Materials.First(x => x.MaterialId == materialId);
var createFormModel = new CreateFormModel()
{
OrganizationId = material.OrganizationId.ToString(),
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(material.OrganizationId),
MaterialTypeSelectItems = new List <SelectListItem>()
{
Define.DefaultSelectListItem(Resources.Resource.Select),
new SelectListItem()
{
Text = Resources.Resource.Create + "...",
Value = Define.New
}
},
FormInput = new FormInput()
{
MaterialType = material.MaterialType
},
MaterialSpecificationModels = (from x in context.MaterialSpecificationOptions
join s in context.MSpecifications
on x.MSpecificationId equals s.MSpecificationId
where x.MaterialId == material.MaterialId
select new MaterialSpecificationModel
{
MaterialSpecificationId = s.MSpecificationId.ToString(),
Name = s.Name,
MaterialSpecificationOptionId = x.MSOptionId.ToString(),
Value = x.Value,
Seq = x.Seq,
MaterialSpecificationOptionModels = context.MSOptions.Where(o => o.MSpecificationId == s.MSpecificationId).Select(o => new MaterialSpecificationOptionModel
{
MaterialSpecificationId = o.MSpecificationId.ToString(),
Seq = o.Seq,
Name = o.Name,
MaterialSpecificationOptionId = o.MSOptionId.ToString()
}).OrderBy(o => o.Seq).ToList()
}).OrderBy(x => x.Seq).ToList()
};
var upStreamOrganizationIds = OrganizationDataAccessor.GetUpStreamOrganizationIds(material.OrganizationId, true);
createFormModel.MaterialTypeSelectItems.AddRange(context.Materials.Where(x => upStreamOrganizationIds.Contains(x.OrganizationId)).Select(x => x.MaterialType).Distinct().OrderBy(x => x).Select(x => new SelectListItem
{
Value = x,
Text = x
}).ToList());
createFormModel.MaterialTypeSelectItems.First(x => x.Value == material.MaterialType).Selected = true;
requestResult.ReturnData(createFormModel);
}
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
}
return(requestResult);
}
public static RequestResult GetEditFormModel(string materialSpecificationId)
{
RequestResult requestResult = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var specification = context.MSpecifications.First(x => x.MSpecificationId == new Guid(materialSpecificationId));
var editFormModel = new EditFormModel()
{
MaterialSpecificationId = specification.MSpecificationId.ToString(),
OrganizationId = specification.OrganizationId.ToString(),
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(specification.OrganizationId),
MaterialTypeSelectItems = new List <SelectListItem>()
{
Define.DefaultSelectListItem(Resources.Resource.Select),
new SelectListItem()
{
Text = string.Format("{0}...", Resources.Resource.Create),
Value = Define.New
}
},
FormInput = new FormInput()
{
MaterialType = specification.MaterialType,
Name = specification.Name
},
MaterialSpecificationOptionModels = context.MSOptions.Where(x => x.MSpecificationId == specification.MSpecificationId).Select(x => new MaterialSpecificationOptionModel
{
MaterialSpecificationOptionId = x.MSOptionId.ToString(),
Name = x.Name,
Seq = x.Seq
}).OrderBy(x => x.Seq).ToList()
};
var upStreamOrganizationIds = OrganizationDataAccessor.GetUpStreamOrganizationIds(specification.OrganizationId, true);
editFormModel.MaterialTypeSelectItems.AddRange(context.MSpecifications.Where(x => upStreamOrganizationIds.Contains(x.OrganizationId)).Select(x => x.MaterialType).Distinct().OrderBy(x => x).Select(x => new SelectListItem
{
Value = x,
Text = x
}).ToList());
if (!string.IsNullOrEmpty(specification.MaterialType) && editFormModel.MaterialTypeSelectItems.Any(x => x.Value == specification.MaterialType))
{
editFormModel.MaterialTypeSelectItems.First(x => x.Value == specification.MaterialType).Selected = true;
}
requestResult.ReturnData(editFormModel);
}
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
}
return(requestResult);
}