public static RequestResult GetDetailViewModel(string pId, Account account)
{
RequestResult requestResult = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var person = context.People.First(p => p.LoginId == pId);
requestResult.ReturnData(new DetailViewModel()
{
Permission = account.OrganizationPermission(person.OrganizationId),
OrganizationId = person.OrganizationId.ToString(),
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(person.OrganizationId),
PId = person.LoginId,
Name = person.Name,
EMail = person.Email,
Title = person.Title,
IsMobilePerson = person.IsMobilePerson,
RoleNames = person.Roles.Select(r => r.Name).ToList()
});
}
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
//throw;
}
return(requestResult);
}
public static RequestResult GetCopyFormModel(string pId)
{
RequestResult requestResult = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var person = context.People.First(p => p.LoginId == pId);
requestResult.ReturnData(new CreateFormModel()
{
OrganizationId = person.Organization.ToString(),
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(person.OrganizationId),
RoleModels = context.Roles.Select(r => new RoleModel {
RoleId = r.RoleId, RoleName = r.Name
}).OrderBy(r => r.RoleId).ToList(),
FormInput = new FormInput()
{
Title = person.Title,
IsMobilePerson = person.IsMobilePerson
}
});
}
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
throw;
}
return(requestResult);
}
public static RequestResult GetAccount(List <Models.Shared.Organization> organizations, Guid personId)
{
RequestResult requestResult = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var person = context.People.FirstOrDefault(x => x.PersonId == personId);
if (person != null)
{
//requestResult = GetAccount(organizations, person);
}
else
{
requestResult.Failed();
}
}
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
}
return(requestResult);
}
public static List <PersonModel> GetAllPeople()
{
var accountList = new List <PersonModel>();
try
{
using (CFContext context = new CFContext())
{
accountList = context.People.Select(p => new PersonModel
{
ID = p.LoginId,
Name = p.Name,
OrganizationId = p.OrganizationId.ToString()
}).ToList();
}
}
catch (Exception e)
{
accountList = new List <PersonModel>();
Logger.Log(MethodBase.GetCurrentMethod(), e);
//throw;
}
return(accountList);
}
public static RequestResult GetCreateFormModel(Guid organizationId)
{
RequestResult requestResult = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
requestResult.ReturnData(new CreateFormModel()
{
OrganizationId = organizationId.ToString(),
ParentOrganizationFullName = OrganizationDataAccessor.GetOrganizationFullName(organizationId),
RoleModels = context.Roles.Select(r => new RoleModel {
RoleId = r.RoleId, RoleName = r.Name
}).OrderBy(r => r.RoleId).ToList()
});
}
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
//throw;
}
return(requestResult);
}
public static RequestResult Create(CreateFormModel createFormModel)
{
RequestResult result = new RequestResult();
try
{
if (createFormModel.FormInput.Type == Define.Other || createFormModel.FormInput.Type == Define.New)
{
result.ReturnFailedMessage(string.Format("{0} {1}", Resources.Resource.Unsupported, Resources.Resource.AbnormalReasonType));
}
else
{
using (CFContext context = new CFContext())
{
var exists = context.AbnormalReasons.FirstOrDefault(x => x.OrganizationId == new Guid(createFormModel.OrganizationId) && x.Type == createFormModel.FormInput.Type && x.ARId == createFormModel.FormInput.ARId);
if (exists == null)
{
Guid abnormalReasonId = Guid.NewGuid();
context.AbnormalReasons.Add(new CF.Models.Maintenance.AbnormalReason()
{
AbnormalReasonId = abnormalReasonId,
OrganizationId = new Guid(createFormModel.OrganizationId),
Type = createFormModel.FormInput.Type,
ARId = createFormModel.FormInput.ARId,
Name = createFormModel.FormInput.Name,
LastModifyTime = DateTime.Now,
Solutions = createFormModel.SolutionModels.Select(x => new CF.Models.Maintenance.Solution()
{
SolutionId = new Guid(x.SolutionId),
SId = x.SId,
Name = x.Name,
Type = x.Type,
OrganizationId = new Guid(createFormModel.OrganizationId)
}).ToList(),
});
context.SaveChanges();
result.ReturnData(abnormalReasonId, string.Format("{0} {1} {2}", Resources.Resource.Create, Resources.Resource.AbnormalReason, Resources.Resource.Success));
}
else
{
result.ReturnFailedMessage(string.Format("{0} {1}", Resources.Resource.ARId, Resources.Resource.Exists));
}
}
}
}
catch (Exception ex)
{
var err = new Error(MethodBase.GetCurrentMethod(), ex);
Logger.Log(err);
result.ReturnError(err);
}
return(result);
}
private ValidationResult DirectlyValid(object value, ValidationContext validationContext)
{
using (CFContext db = new CFContext())
{
string Name = GetName(validationContext);
PropertyInfo IdProp = validationContext.ObjectInstance.GetType().GetProperties().FirstOrDefault(x => x.CustomAttributes.Count(a => a.AttributeType == typeof(KeyAttribute)) > 0);
var Id = IdProp.GetValue(validationContext.ObjectInstance, null);
Type entityType = validationContext.ObjectType;
IQueryable result = db.Set(entityType).Where(Name + "==@0", value);
int count = 0;
if (Id != null || Name != IdProp.Name)
{
result = result.Where(IdProp.Name + "<>@0", Id);
}
count = result.Count();
if (count == 0 || value == null)
{
return(ValidationResult.Success);
}
else
{
return(new ValidationResult(ErrorMessageString));
}
}
}
public static void DeleteCheckpoints(CFContext context, List<string> selectedList)
{
foreach(var checkpointId in selectedList)
{
context.Checkpoints.Remove(context.Checkpoints.First(x => x.CheckpointId == new Guid(checkpointId)));
}
}
public static void DeleteAbnormalReason(CFContext context, List<string> selectedList)
{
foreach(var abnormalReasonId in selectedList)
{
context.AbnormalReasons.Remove(context.AbnormalReasons.First(x => x.AbnormalReasonId == new Guid(abnormalReasonId)));
}
}
public static RequestResult Delete(Guid organizationId)
{
RequestResult requestResult = new RequestResult();
try
{
var organizationIds = GetDownStreamOrganizationIds(organizationId, true);
using (CFContext context = new CFContext())
{
DeleteHelper.DeleteOrganization(context, organizationIds);
context.SaveChanges();
}
requestResult.ReturnSuccessMessage(string.Format("{0} {1} {2}", Resources.Resource.Delete, Resources.Resource.Organization, Resources.Resource.Success));
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
//throw;
}
return(requestResult);
}
public static RequestResult GetAccount(LoginFormModel loginFormModel)
{
RequestResult requestResult = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var person = context.People.FirstOrDefault(x => x.LoginId == loginFormModel.LoginId);
if (person != null)
{
requestResult.ReturnData(person);
}
else
{
requestResult.ReturnFailedMessage(Resources.Resource.LoginIdNotExist);
}
}
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
}
return(requestResult);
}
public static RequestResult Delete(List <string> selectedList)
{
RequestResult requestResult = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
DeleteHelper.DeleteMaterial(context, selectedList);
context.SaveChanges();
}
requestResult.ReturnSuccessMessage(string.Format("{0} {1} {2}", Resources.Resource.Delete, Resources.Resource.Material, Resources.Resource.Success));
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
}
return(requestResult);
}
public static OrganizationModel GetOrganization(Guid parentOrganizationId)
{
OrganizationModel organizationModel = null;
try
{
using (CFContext db = new CFContext())
{
var query = db.Organizations.Include("Manager").First(x => x.OrganizationId == parentOrganizationId);
organizationModel = new OrganizationModel()
{
AncestorOrganizationId = GetAncestorOrganizationId(query.OrganizationId),
OrganizationId = query.OrganizationId,
OId = query.OId,
Name = query.Name,
FullName = GetOrganizationFullName(query.OrganizationId),
//ManagerId = query.Manager.ManagerId
};
}
}
catch (Exception ex)
{
organizationModel = null;
Logger.Log(MethodBase.GetCurrentMethod(), ex);
}
return(organizationModel);
}
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(Guid organizationId, Account account)
{
RequestResult requestResult = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var organization = context.Organizations.Include("Manager").Where(o => o.OrganizationId == organizationId).Select(o => new { o.OrganizationId, o.ParentId, o.OId, o.Name, o.Manager }).First();
requestResult.ReturnData(new DetailViewModel()
{
OrganizationId = organization.OrganizationId.ToString(),
Permission = account.OrganizationPermission(organizationId),
ParentOrganizationFullName = GetOrganizationFullName(organization.ParentId),
OId = organization.OId,
Name = organization.Name,
EditableOrganizations = GetEditableOrganizationIds(organizationId).Union(GetDownStreamOrganizationIds(organizationId, true)).Select(x => GetOrganizationFullName(x)).OrderBy(x => x).ToList(),
QueryableOrganizations = GetQueryableOrganizationIds(organizationId).Select(x => GetOrganizationFullName(x)).OrderBy(x => x).ToList(),
//ManagerList=organization.Manager
});
}
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
//throw;
}
return(requestResult);
}
public static void DeleteSolutions(CFContext context, List<string> selectedList)
{
foreach(var solutionId in selectedList)
{
context.Solutions.Remove(context.Solutions.First(x => x.SolutionId == new Guid(solutionId)));
}
}
public static List <Models.Shared.Organization> GetAllOrganizations()
{
var organizations = new List <Models.Shared.Organization>();
try
{
using (CFContext context = new CFContext())
{
organizations = context.Organizations.Select(x => new Models.Shared.Organization
{
OrganizationId = x.OrganizationId,
ParentId = x.ParentId,
OId = x.OId,
Name = x.Name
}).ToList();
}
}
catch (Exception e)
{
organizations = new List <Models.Shared.Organization>();
Logger.Log(MethodBase.GetCurrentMethod(), e);
}
return(organizations);
}
public static RequestResult GetRootTreeItem(List <Organization> organizationList, Guid rootOrganizationId, Account account)
{
RequestResult requestResult = new RequestResult();
try
{
var treeItemList = new List <TreeItem>();
var attributes = new Dictionary <Define.EnumTreeAttribute, string>()
{
{ Define.EnumTreeAttribute.NodeType, string.Empty },
{ Define.EnumTreeAttribute.ToolTip, string.Empty },
{ Define.EnumTreeAttribute.OrganizationId, string.Empty },
{ Define.EnumTreeAttribute.EquipmentType, string.Empty },
{ Define.EnumTreeAttribute.MaterialId, string.Empty }
};
using (CFContext context = new CFContext())
{
var organization = organizationList.First(x => x.OrganizationId == rootOrganizationId);
var treeItem = new TreeItem()
{
Title = organization.Name
};
attributes[Define.EnumTreeAttribute.NodeType] = Define.EnumTreeNodeType.Organization.ToString();
attributes[Define.EnumTreeAttribute.ToolTip] = string.Format("{0}/{1}", organization.OId, organization.Name);
attributes[Define.EnumTreeAttribute.OrganizationId] = organization.OrganizationId.ToString();
attributes[Define.EnumTreeAttribute.EquipmentType] = string.Empty;
attributes[Define.EnumTreeAttribute.MaterialId] = string.Empty;
foreach (var attribute in attributes)
{
treeItem.Attributes[attribute.Key.ToString()] = attribute.Value;
}
var haveDownStreamOrganization = organizationList.Any(x => x.ParentId == organization.OrganizationId && account.VisibleOrganizationIds.Contains(x.OrganizationId));
var haveMaterial = account.QueryableOrganizationIds.Contains(organization.OrganizationId) && context.Materials.Any(x => x.OrganizationId == organization.OrganizationId);
if (haveDownStreamOrganization || haveMaterial)
{
treeItem.State = "closed";
}
treeItemList.Add(treeItem);
}
requestResult.ReturnData(treeItemList);
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
//throw;
}
return(requestResult);
}
public static List <Guid> GetUpStreamOrganizationIds(Guid organizationId, bool include)
{
var itemList = new List <Guid>();
try
{
if (include)
{
itemList.Add(organizationId);
}
using (CFContext context = new CFContext())
{
if (organizationId != new Guid())
{
var organization = context.Organizations.First(x => x.OrganizationId == organizationId);
while (organization.ParentId != new Guid())
{
organization = context.Organizations.First(x => x.OrganizationId == organization.ParentId);
itemList.Add(organization.OrganizationId);
}
itemList.Add(new Guid());
}
}
}
catch (Exception e)
{
itemList = null;
Logger.Log(MethodBase.GetCurrentMethod(), e);
}
return(itemList);
}
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 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 ChangePassword(PasswordFormModel passwordFormModel, Account account)
{
RequestResult requestResult = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var person = context.People.First(p => p.LoginId == account.Id);
if (string.Compare(person.Password, passwordFormModel.OriginalPassword, false) == 0)
{
person.Password = passwordFormModel.NewPassword;
person.LastModifyTime = DateTime.Now;
context.SaveChanges();
requestResult.ReturnSuccessMessage(Resources.Resource.ChangePassword + " " + Resources.Resource.Success);
}
else
{
requestResult.ReturnFailedMessage(Resources.Resource.WrongPassword);
}
}
}
catch (Exception e)
{
var error = new Error(MethodBase.GetCurrentMethod(), e);
Logger.Log(error);
requestResult.ReturnError(error);
}
return(requestResult);
}
public static RequestResult Delete(List <string> selectedList)
{
RequestResult result = new RequestResult();
try
{
#if !DEBUG
using (TransactionScope trans = new TransactionScope())
{
#endif
using (CFContext context = new CFContext())
{
DeleteHelper.DeleteAbnormalReason(context, selectedList);
context.SaveChanges();
}
#if !DEBUG
trans.Complete();
}
#endif
result.ReturnSuccessMessage(string.Format("{0} {1} {2}", Resources.Resource.Delete, Resources.Resource.AbnormalReason, Resources.Resource.Success));
}
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 object DeletePhoto(string uniqueID)
{
RequestResult result = new RequestResult();
try
{
using (CFContext context = new CFContext())
{
var material = context.Materials.First(x => x.MaterialId == new Guid(uniqueID));
//material.Extension = string.Empty;
//db.SaveChanges();
result.Success();
}
}
catch (Exception ex)
{
var err = new Error(MethodBase.GetCurrentMethod(), ex);
Logger.Log(err);
result.ReturnError(err);
}
return(result);
}
public static List <Guid> GetDownStreamOrganizations(Guid OrganizationId, bool Include)
{
var itemList = new List <Guid>();
try
{
if (Include)
{
itemList.Add(OrganizationId);
}
using (CFContext context = new CFContext())
{
//向下搜尋
var organizations = context.Organizations.Where(x => x.ParentId == OrganizationId).Select(x => x.OrganizationId).ToList();
while (organizations.Count > 0)
{
itemList.AddRange(organizations);
organizations = context.Organizations.Where(x => organizations.Contains(x.ParentId)).Select(x => x.OrganizationId).ToList();
}
}
}
catch (Exception ex)
{
itemList = null;
Logger.Log(MethodBase.GetCurrentMethod(), ex);
}
return(itemList);
}
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 void DeleteMaterial(CFContext context, List<string> selectedList)
{
foreach(var materialId in selectedList)
{
context.Materials.Remove(context.Materials.First(x => x.MaterialId == new Guid(materialId)));
context.MaterialSpecificationOptions.RemoveRange(context.MaterialSpecificationOptions.Where(x => x.MaterialId == new Guid(materialId)).ToList());
}
}
public void UpdateEndereco(Endereco endereco)
{
using (Context = new CFContext())
{
Context.Entry(endereco).State = EntityState.Modified;
Context.SaveChanges();
}
}
