public void Insert(PositionViewModelRequest viewModel)
{
var model = _mapper.Map <Position>(viewModel);
_positionRepository.Add(model);
_unitOfWork.Commit();
}
public virtual ActionResult CreatePosition(Position model)
{
model.IsActive = true;
_positionRepository.Add(model);
_unitOfWork.Commit();
return(RedirectToAction("Position"));
}
public async Task <ActionResult> PostPosition([FromBody] Position position)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
await _positionRepository.Add(position);
return(CreatedAtAction("PostPosition", new { id = position.PositionId }, position));
}
public void PositionRepository_AddTest()
{
IPositionRepository positionRepository = IoCFactory.Instance.CurrentContainer.Resolve <IPositionRepository>();
Position position1 = new Position()
{
Id = new Guid("0c11fc14-c881-c335-e1e8-08d1b45385cd"),
Title = "testPosition"
};
positionRepository.Add(position1);
positionRepository.UnitOfWork.Commit();
Position byId = positionRepository.GetElementById(position1.Id);
Assert.IsNotNull((object)byId);
Assert.IsTrue(byId.Id == position1.Id);
}
/// <summary>
/// 添加或修改
/// </summary>
/// <param name="model"></param>
public void AddOrModity(Position model)
{
model.PyCode = model.PositionName.ToConvertPyCode();
if (!string.IsNullOrEmpty(model.Id))
{
model.LastUpdateDate = DateTime.Now;
positionRepository.Modity(model);
}
else
{
model.GenerateNewIdentity();
model.CreateDate = DateTime.Now;
model.LastUpdateDate = DateTime.Now;
positionRepository.Add(model);
}
positionRepository.SaveChanges();
}
public override object Add(Position position)
{
// Validate dữ liệu
var serviceResult = base.Validate(position);
if (serviceResult != null)
{
return(serviceResult);
}
// Gọi hàm thêm mới khách hàng
var rowEffects = _positionRepository.Add(position);
return(new ServiceResult()
{
Data = rowEffects, MisaCode = MISACode.IsValid
});
}
public Position GetPosition(string name)
{
var position = positions[name.ToLower()] as Position;
if (position == null)
{
Position position1 = new Position
{
Name = name
};
_repository.Add(position1);
position = position1;
}
return(position);
}
public async Task Add(List <Position> positions)
{
Tournament tournament = await _tournamentRepository.Get(positions[0].TournamentID);
foreach (Position position in positions)
{
await _positionRepository.Add(position);
if (position.Qualified || position.NoPosition == 1)
{
Team team = await _teamRepository.Get(position.TeamID);
switch (tournament.TournamentType.Format)
{
case TournamentFormat.Qualification:
team.WorldCupQualifications++;
break;
case TournamentFormat.WorldCup:
team.WorldCupTitles++;
break;
case TournamentFormat.ConfederationsCup:
team.ConfederationsCupTitles++;
break;
case TournamentFormat.ConfederationTournament:
team.ConfederationTournamentTitles++;
break;
}
_teamRepository.Update(team);
}
}
await _positionRepository.SaveChanges();
}
public void CreatePosition(Position position)
{
positionRepository.Add(position);
}
public Position Add(Position entity)
{
return(_position.Add(entity));
}
public Position Add(Position Position)
{
return(_PositionRepository.Add(Position));
}
public int Upload(string fileName, out string returnMsg, bool isInitial = false)
{
ExcelPackage package;
IList <Item> listOfItems = new List <Item>();
returnMsg = string.Empty;
//string strorageconn = System.Configuration.ConfigurationSettings.AppSettings.Get("StorageConnectionString");
//CloudStorageAccount storageacc = CloudStorageAccount.Parse(strorageconn);
//CloudBlobClient blobClient = storageacc.CreateCloudBlobClient();
//CloudBlobContainer container = blobClient.GetContainerReference("itemimages");
if (isInitial)
{
var excelFile = Resource.仓库物品资料汇总表;
var templateStream = new MemoryStream(excelFile);
package = new ExcelPackage(templateStream);
}
else
{
if (string.IsNullOrEmpty(fileName))
{
return(-2);
}
var fi = new FileInfo(fileName);
package = new ExcelPackage(fi);
}
var workbook = package.Workbook;
var worksheet = workbook.Worksheets["物品资料汇总表"];
if (worksheet == null)
{
return(0);
}
InitalImagesToLocal(_resourceName, worksheet);
var end = worksheet.Dimension.End;
for (var row = 9; row < end.Row; row++)
{
var itemObject = new Item
{
ItemId = Guid.NewGuid(),
DefaultPositionName = "Stage",
UpdateDate = DateTime.Now
};
for (var col = 1; col <= worksheet.Dimension.End.Column; col++)
{
var readValue = worksheet.Cells[row, col].Value == null ? "" : worksheet.Cells[row, col].Value.ToString();
switch (col)
{
case 1:
if (readValue == "")
{
break;
}
else
{
itemObject.SerialNumber = int.Parse(readValue); //序号
}
break;
case 3:
itemObject.Code = readValue; // 编号
break;
case 4:
itemObject.Status = readValue; //状态
if (readValue.Contains("Active"))
{
itemObject.Status = "现行Active";
}
else if (readValue.Contains("Discountinue"))
{
itemObject.Status = "中止Discountinue";
}
else if (readValue.Contains("Cancel"))
{
itemObject.Status = "取消Cancel";
}
else if (readValue.Contains("Deactive"))
{
itemObject.Status = "下线Deactive";
}
else
{
itemObject.Status = "";
}
break;
case 5:
itemObject.Category = readValue; //物品类别
break;
case 6:
itemObject.ProjectCategory = readValue; //所属转项类
break;
case 7:
itemObject.SubCategory = readValue; //物品种类
break;
case 8:
itemObject.BigCategory = readValue; //物品大类
break;
case 9:
itemObject.SmallCategory = readValue; //物品小类
break;
case 10:
itemObject.DetailCategory = readValue; //物品细类
break;
case 11:
itemObject.AdjustCategory = readValue; //调整类
break;
case 12:
itemObject.Attribute = readValue; //物品属性
break;
case 13:
itemObject.Property = readValue; //资产类型
break;
case 14:
itemObject.ChineseName = readValue.Replace("\n", " "); //中文名
break;
case 15:
itemObject.EnglishName = readValue.Replace("\n", " "); //英文名
break;
case 16:
break;
case 17:
itemObject.Brand = readValue; //品牌
break;
case 18:
itemObject.Model = readValue; //型号
break;
case 19:
itemObject.Specification = readValue; //规格
break;
case 20:
itemObject.Dimension = readValue; //尺寸
break;
case 21:
itemObject.Length = readValue; //长
break;
case 22:
itemObject.Width = readValue; //宽
break;
case 23:
itemObject.Height = readValue; //高
break;
case 25:
itemObject.Unit = readValue; //单位
break;
case 26:
if (readValue == "")
{
itemObject.Price = 0;
}
else
{
itemObject.Price = double.Parse(readValue); //单价
}
break;
case 27:
itemObject.Package = readValue; //包装数量
break;
case 28:
itemObject.PackageLength = readValue; //包装长
break;
case 29:
itemObject.PackageWidth = readValue; //包装宽
break;
case 30:
itemObject.PackageHeight = readValue; //包装高
break;
case 31:
itemObject.Detail = readValue; //详细信息链接
break;
case 35:
if (readValue == "")
{
itemObject.Max = 0;
}
else
{
itemObject.Max = double.Parse(readValue); //库存上限
}
break;
case 36:
if (readValue == "")
{
itemObject.Min = 0;
}
else
{
itemObject.Min = double.Parse(readValue); //库存下限
}
break;
case 38:
itemObject.FirstSupplier = readValue.TrimEnd().TrimStart(); // 一级供应商
break;
case 41:
itemObject.SecondSupplier = readValue.TrimEnd().TrimStart(); // 二级供应商
break;
case 44:
itemObject.ThirdSupplier = readValue.TrimEnd().TrimStart(); // 三级供应商
break;
case 48:
itemObject.CostCategory = readValue;
break;
case 50:
itemObject.ArrangeOrder = readValue;
break;
case 51:
itemObject.ArrangePosition = readValue;
break;
}
}
if (itemObject.SerialNumber > 0)
{
listOfItems.Add(itemObject);
}
}
try
{
var existingItems = _itemRepository.GetAll();
var existingPositions = _positionRepository.GetAll();
if (!existingItems.Any())
{
_itemRepository.CleanUp();
_itemRepository.AddRange(listOfItems);
}
else
{
foreach (var item in listOfItems)
{
var existingItem = existingItems.FirstOrDefault(x => x.Code == item.Code);
if (existingItem != null)
{
existingItem.Status = item.Status;
existingItem.Category = item.Category;
existingItem.ProjectCategory = item.ProjectCategory;
existingItem.SubCategory = item.SubCategory;
existingItem.BigCategory = item.BigCategory;
existingItem.SmallCategory = item.SmallCategory;
existingItem.DetailCategory = item.DetailCategory;
existingItem.AdjustCategory = item.AdjustCategory;
existingItem.Attribute = item.Attribute;
existingItem.Property = item.Property;
existingItem.ChineseName = item.ChineseName;
existingItem.EnglishName = item.EnglishName;
existingItem.Brand = item.Brand;
existingItem.Model = item.Model;
existingItem.Specification = item.Specification;
existingItem.Dimension = item.Dimension;
existingItem.Length = item.Length;
existingItem.Width = item.Width;
existingItem.Height = item.Height;
existingItem.Unit = item.Unit;
existingItem.Price = item.Price;
existingItem.Package = item.Package;
existingItem.PackageLength = item.PackageLength;
existingItem.PackageWidth = item.PackageWidth;
existingItem.PackageHeight = item.PackageHeight;
existingItem.Detail = item.Detail;
existingItem.Max = item.Max;
existingItem.Min = item.Min;
existingItem.CostCategory = item.CostCategory;
existingItem.ArrangeOrder = item.ArrangeOrder;
existingItem.ArrangePosition = item.ArrangePosition;
existingItem.Comments = item.Comments;
existingItem.FirstSupplier = item.FirstSupplier;
existingItem.SecondSupplier = item.SecondSupplier;
existingItem.ThirdSupplier = item.ThirdSupplier;
}
else
{
var positionObject = new Position()
{
ItemId = item.ItemId,
Code = item.Code,
PositionName = "Stage"
};
_positionRepository.Add(positionObject);
_itemRepository.Add(item);
}
}
}
_itemRepository.Save();
_positionRepository.Save();
return(1);
}
catch (Exception)
{
return(0);
}
}
/// <summary>
/// Seed method attempts to intsert the initial data into the database everytime when database is being updated after migration
/// </summary>
/// <param name="context">Database context on which seed method is being called (Not used in this scenario because repositories are used to insert the data)</param>
protected override void Seed(RAMS.Data.DataContext context)
{
// Add users
using (var applicationDbContext = new ApplicationDbContext())
{
var userStore = new UserStore <ApplicationUser>(applicationDbContext);
var userManager = new UserManager <ApplicationUser>(userStore);
if (userManager.FindByName("john.doe") == null)
{
var users = GetUsers();
foreach (var user in users)
{
userManager.Create(user, "123RAMSApp!");
// Add user claims for each user
if (user.UserName == "superuser")
{
userManager.AddClaim(user.Id, new Claim("FullName", "superuser"));
userManager.AddClaim(user.Id, new Claim("Role", "Manager"));
userManager.AddClaim(user.Id, new Claim("UserType", "Admin"));
userManager.AddClaim(user.Id, new Claim("UserStatus", "Active"));
}
else if (user.UserName == "john.doe")
{
userManager.AddClaim(user.Id, new Claim("FullName", "John Doe"));
userManager.AddClaim(user.Id, new Claim("Role", "Manager"));
userManager.AddClaim(user.Id, new Claim("UserType", "Agent"));
userManager.AddClaim(user.Id, new Claim("UserStatus", "Active"));
}
else if (user.UserName == "james.smith")
{
userManager.AddClaim(user.Id, new Claim("FullName", "James Smith"));
userManager.AddClaim(user.Id, new Claim("Role", "Employee"));
userManager.AddClaim(user.Id, new Claim("UserType", "Agent"));
userManager.AddClaim(user.Id, new Claim("UserStatus", "Active"));
}
else if (user.UserName == "mary.watson")
{
userManager.AddClaim(user.Id, new Claim("FullName", "Mary Watson"));
userManager.AddClaim(user.Id, new Claim("Role", "Employee"));
userManager.AddClaim(user.Id, new Claim("UserType", "Agent"));
userManager.AddClaim(user.Id, new Claim("UserStatus", "Active"));
}
else if (user.UserName == "tommy.jordan")
{
userManager.AddClaim(user.Id, new Claim("FullName", "Tommy Jordan"));
userManager.AddClaim(user.Id, new Claim("Role", "Employee"));
userManager.AddClaim(user.Id, new Claim("UserType", "Admin"));
userManager.AddClaim(user.Id, new Claim("UserStatus", "Active"));
}
else if (user.UserName == "kathy.doe")
{
userManager.AddClaim(user.Id, new Claim("FullName", "Kathy Doe"));
userManager.AddClaim(user.Id, new Claim("Role", "Employee"));
userManager.AddClaim(user.Id, new Claim("UserType", "Admin"));
userManager.AddClaim(user.Id, new Claim("UserStatus", "Active"));
}
else if (user.UserName == "jimmy.thomson")
{
userManager.AddClaim(user.Id, new Claim("FullName", "Jimmy Thomson"));
userManager.AddClaim(user.Id, new Claim("Role", "Employee"));
userManager.AddClaim(user.Id, new Claim("UserType", "Client"));
userManager.AddClaim(user.Id, new Claim("UserStatus", "Active"));
}
else if (user.UserName == "nancy.clinton")
{
userManager.AddClaim(user.Id, new Claim("FullName", "Nancy Clinton"));
userManager.AddClaim(user.Id, new Claim("Role", "Employee"));
userManager.AddClaim(user.Id, new Claim("UserType", "Client"));
userManager.AddClaim(user.Id, new Claim("UserStatus", "Active"));
}
}
}
}
// Add departments
if (!departmentRepository.GetAll().Any())
{
GetDepartments().ForEach(d => departmentRepository.Add(d));
unitOfWork.Commit();
}
// Add agents
if (!agentRepository.GetAll().Any())
{
GetAgents().ForEach(a => agentRepository.Add(a));
unitOfWork.Commit();
}
// Add clients
if (!clientRepository.GetAll().Any())
{
GetClients().ForEach(c => clientRepository.Add(c));
unitOfWork.Commit();
}
// Add admins
if (!adminRepository.GetAll().Any())
{
GetAdmins().ForEach(a => adminRepository.Add(a));
unitOfWork.Commit();
}
// Add categories
if (!categoryRepository.GetAll().Any())
{
GetCategories().ForEach(c => categoryRepository.Add(c));
unitOfWork.Commit();
}
// Add positions
if (!positionRepository.GetAll().Any())
{
GetPositions().ForEach(p => positionRepository.Add(p));
unitOfWork.Commit();
}
// Add candidates
if (!candidateRepository.GetAll().Any())
{
GetCandidates().ForEach(c => candidateRepository.Add(c));
unitOfWork.Commit();
}
// Add interiews
if (!interviewRepository.GetAll().Any())
{
GetInterviews().ForEach(i => interviewRepository.Add(i));
unitOfWork.Commit();
}
// Add notifications
if (!notificationRepository.GetAll().Any())
{
GetNotifications().ForEach(n => notificationRepository.Add(n));
unitOfWork.Commit();
}
}