public async Task <ActionResult> Edit(int id, VmUserItem _vmObject)
{
var roleListArr = Request.Form["RoleList"].ToArray();
for (int i = 0; i < roleListArr.Length; i++)
{
VmRoleItem _lst = new VmRoleItem();
if (roleListArr[i].ToString().All(char.IsDigit))
{
_lst.Id = int.Parse(roleListArr[i]);
_vmObject.RoleList.Add(_lst);
}
}
if (id != _vmObject.Id)
{
return(NotFound());
}
var result = await svs.Update(_vmObject);
if (result.IsSuccess)
{
return(RedirectToAction(nameof(Index)));
}
else
{
return(View(_vmObject));
}
}
public async Task <VmUserItem> ValidateUser(VM_Sys_User_Sign_In user)
{
var dbresult = await repo.GetUser(user.UserName, Md5.Encrypt(user.Password));
if (dbresult == null)
{
return(new VmUserItem());
}
else
{
var result = new VmUserItem();
Copy <Com.BudgetMetal.DBEntities.User, VmUserItem>(dbresult, result);
if (dbresult.UserRoles != null)
{
var SelectedRoles = new List <VmRoleItem>();
foreach (var dbItem in dbresult.UserRoles)
{
var resultUserRoles = new VmRoleItem();
var dbRole = await roleRepo.Get(dbItem.Role_Id);
Copy <Com.BudgetMetal.DBEntities.Role, VmRoleItem>(dbRole, resultUserRoles);
SelectedRoles.Add(resultUserRoles);
}
result.SelectedRoles = SelectedRoles;
}
var resultCompany = new VmCompanyItem();
Copy <Com.BudgetMetal.DBEntities.Company, VmCompanyItem>(dbresult.Company, resultCompany);
result.Company = resultCompany;
return(result);
}
}
public VmGenericServiceResult Insert(VmRoleItem vmRoleItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
Role r = new Role();
Copy <VmRoleItem, Role>(vmRoleItem, r);
if (r.CreatedBy.IsNullOrEmpty())
{
r.CreatedBy = r.UpdatedBy = "System";
}
repo.Add(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public async Task <VmRolePage> GetRolesByPage(string keyword, int page, int totalRecords)
{
var dbPageResult = await repo.GetPage(keyword,
(page == 0 ? Constants.app_firstPage : page),
(totalRecords == 0 ? Constants.app_totalRecords : totalRecords));
if (dbPageResult == null)
{
return(new VmRolePage());
}
var resultObj = new VmRolePage();
//resultObj.ApplicationToken = applicationToken;
resultObj.RequestId = DateTime.Now.ToString("yyyyMMddHHmmss");
resultObj.RequestDate = DateTime.Now;
resultObj.Result = new PageResult <VmRoleItem>();
resultObj.Result.Records = new List <VmRoleItem>();
Copy <PageResult <Role>, PageResult <VmRoleItem> >(dbPageResult, resultObj.Result, new string[] { "Records" });
foreach (var dbItem in dbPageResult.Records)
{
var resultItem = new VmRoleItem();
Copy <Role, VmRoleItem>(dbItem, resultItem);
resultObj.Result.Records.Add(resultItem);
}
return(resultObj);
}
public async Task <VmGenericServiceResult> Update(VmRoleItem vmRoleItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
Role r = await repo.Get(vmRoleItem.Id);
Copy <VmRoleItem, Role>(vmRoleItem, r);
if (r.UpdatedBy.IsNullOrEmpty())
{
r.UpdatedBy = "System";
}
repo.Update(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e) {
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
// GET: Roles/Details/5
public async Task <IActionResult> Details(int id)
{
VmRoleItem item = await svs.GetRoleById(id);
if (item == null)
{
return(NotFound());
}
return(View(item));
}
//public async Task<IActionResult> Create([Bind("Id, Role, RoleCode")] VmRoleItem roles)
public async Task <IActionResult> Create(VmRoleItem roles)
{
var result = svs.Insert(roles);
if (result.IsSuccess)
{
return(RedirectToAction(nameof(Index)));
}
else
{
return(View(roles));
}
}
public async Task <VmRoleItem> GetRoleById(int Id)
{
var dbPageResult = await repo.Get(Id);
if (dbPageResult == null)
{
return(new VmRoleItem());
}
var resultObj = new VmRoleItem();
Copy <Role, VmRoleItem>(dbPageResult, resultObj);
return(resultObj);
}
public async Task <List <VmRoleItem> > GetActiveRoles(string roleType)
{
var dbResult = await repo.GetAll();
var resultList = new List <VmRoleItem>();
foreach (var dbItem in dbResult)
{
var resultItem = new VmRoleItem();
if (roleType == "rfq")
{
if (dbItem.Code.StartsWith("R_"))
{
Copy <Role, VmRoleItem>(dbItem, resultItem);
resultList.Add(resultItem);
}
}
else if (roleType == "company")//admin
{
if (dbItem.Code.StartsWith("C_"))
{
Copy <Role, VmRoleItem>(dbItem, resultItem);
resultList.Add(resultItem);
}
}
else if (roleType == "quotation")
{
if (dbItem.Code.StartsWith("Q_"))
{
Copy <Role, VmRoleItem>(dbItem, resultItem);
resultList.Add(resultItem);
}
}
else
{
if ((!dbItem.Code.StartsWith("Q_")) || (!dbItem.Code.StartsWith("R_")))
{
Copy <Role, VmRoleItem>(dbItem, resultItem);
resultList.Add(resultItem);
}
}
}
return(resultList);
}
// GET: Roles/Edit/5
public async Task <IActionResult> Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
int _id = (int)id;
VmRoleItem rItem = await svs.GetRoleById(_id);
if (rItem == null)
{
return(NotFound());
}
return(View(rItem));
}
//public async Task<IActionResult> Edit(int id, [Bind("Id, Role, RoleCode, UpdatedBy, CreatedDate, CreatedBy, Version, IsActive")] roles roles)
//public async Task<IActionResult> Edit(int id, [Bind("Id, Role, RoleCode, UpdatedBy, Version, IsActive")] VmRoleItem roles)
public async Task <IActionResult> Edit(int id, VmRoleItem roles)
{
if (id != roles.Id)
{
return(NotFound());
}
var result = await svs.Update(roles);
if (result.IsSuccess)
{
return(RedirectToAction(nameof(Index)));
}
else
{
return(View(roles));
}
}
// GET: Roles/Create
public ActionResult Create()
{
VmRoleItem roleObj = new VmRoleItem();
return(View(roleObj));
}
public async Task <VmCompanyItem> GetCompanyProfileById(int Id)
{
var dbPageResult = await repo.Get(Id);
if (dbPageResult == null)
{
return(new VmCompanyItem());
}
var resultObj = new VmCompanyItem();
Copy <Com.BudgetMetal.DBEntities.Company, VmCompanyItem>(dbPageResult, resultObj);
resultObj.IsVerified = (dbPageResult.IsVerified == null) ? false : (bool)dbPageResult.IsVerified;
var dbUserList = await repoUser.GetUserByCompanyNotFilterWithConfirm(Id);
if (dbUserList == null)
{
return(resultObj);
}
resultObj.UserList = new List <VmUserItem>();
foreach (var dbUser in dbUserList)
{
List <VmRoleItem> rListItem = new List <VmRoleItem>();
if (dbUser.UserRoles != null)
{
foreach (var dbRoleItem in dbUser.UserRoles)
{
var dbRole = roleRepository.Get(dbRoleItem.Role_Id);
if (dbRole != null)
{
VmRoleItem rItem = new VmRoleItem();
rItem.Id = dbRole.Result.Id;
rItem.Name = dbRole.Result.Name;
rItem.Code = dbRole.Result.Code;
rListItem.Add(rItem);
}
}
}
VmUserItem user = new VmUserItem()
{
Id = dbUser.Id,
UserName = dbUser.UserName,
EmailAddress = dbUser.EmailAddress,
JobTitle = dbUser.JobTitle,
UserType = dbUser.UserType,
IsConfirmed = dbUser.IsConfirmed,
IsActive = dbUser.IsActive,
RoleList = rListItem
};
resultObj.UserList.Add(user);
}
var dbRepoList = await ratingRepo.GetRagintByCompany(Id);
if (dbRepoList == null)
{
return(resultObj);
}
resultObj.RatingList = new List <VmRatingItem>();
foreach (var dbRating in dbRepoList)
{
VmRatingItem rating = new VmRatingItem()
{
SpeedOfQuotation = dbRating.SpeedOfQuotation,
SpeedofDelivery = dbRating.SpeedofDelivery,
ServiceQuality = dbRating.ServiceQuality,
Price = dbRating.Price,
SpeedofProcessing = dbRating.SpeedofProcessing,
Payment = dbRating.Payment,
Title = dbRating.Title,
Description = dbRating.Description,
Ratingcol = dbRating.Ratingcol,
UserName = dbRating.User.ContactName
};
//var rating = new VmRatingItem();
//Copy<Com.BudgetMetal.DBEntities.Rating, VmRatingItem>(dbRating, rating);
resultObj.RatingList.Add(rating);
}
return(resultObj);
}
public async Task <VmUserItem> GetFormObject()
{
VmUserItem result = new VmUserItem();
var dbCList = await cRepo.GetAll();
//filter with companyId
var dbCCList = await CTrepo.GetAll();
var dbRoleList = await roleRepo.GetAll();
if (dbCList == null && dbCCList == null && dbRoleList == null)
{
return(result);
}
if (dbCList != null)
{
result.CompanyList = new List <VmCompanyItem>();
foreach (var dbcat in dbCList)
{
VmCompanyItem _company = new VmCompanyItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
result.CompanyList.Add(_company);
}
}
if (dbCCList != null)
{
result.CodeTableList = new List <VmCodeTableItem>();
foreach (var dbcat in dbCCList)
{
VmCodeTableItem _codeTable = new VmCodeTableItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
result.CodeTableList.Add(_codeTable);
}
}
if (dbRoleList != null)
{
result.RoleList = new List <VmRoleItem>();
foreach (var item in dbRoleList)
{
VmRoleItem _roleItem = new VmRoleItem()
{
Id = item.Id,
Name = item.Name
};
result.RoleList.Add(_roleItem);
}
}
return(result);
}
public async Task <VmUserItem> GetUserById(int Id)
{
var dbPageResult = await repo.GetUserById(Id);
if (dbPageResult == null)
{
return(new VmUserItem());
}
var result = new VmUserItem();
Copy <Com.BudgetMetal.DBEntities.User, VmUserItem>(dbPageResult, result);
var dbCList = await cRepo.GetAll();
//filter with companyId
var dbCCList = await CTrepo.GetAll();
var dbRoleList = await roleRepo.GetAll();
if (dbCList == null && dbCCList == null && dbRoleList == null)
{
return(result);
}
if (dbCList != null)
{
result.CompanyList = new List <VmCompanyItem>();
foreach (var dbcat in dbCList)
{
VmCompanyItem _company = new VmCompanyItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
result.CompanyList.Add(_company);
}
}
if (dbCCList != null)
{
result.CodeTableList = new List <VmCodeTableItem>();
foreach (var dbcat in dbCCList)
{
VmCodeTableItem _codeTable = new VmCodeTableItem()
{
Id = dbcat.Id,
Name = dbcat.Name
};
result.CodeTableList.Add(_codeTable);
}
}
if (dbRoleList != null)
{
result.RoleList = new List <VmRoleItem>();
foreach (var item in dbRoleList)
{
VmRoleItem _roleItem = new VmRoleItem()
{
Id = item.Id,
Name = item.Name
};
result.RoleList.Add(_roleItem);
}
}
if (dbPageResult.UserRoles != null)
{
if (dbPageResult.UserRoles.Count > 0)
{
result.SelectedRoleId = new List <int>();
foreach (var item in dbPageResult.UserRoles)
{
int roleId = item.Role_Id;
result.SelectedRoleId.Add(roleId);
}
}
else
{
//Add zero
result.SelectedRoleId = new List <int>();
result.SelectedRoleId.Add(0);
}
}
return(result);
}
