public async Task <JsonResult> Create(BaseDataViewModel model)
{
return(await ExecuteWithErrorHandling(async() =>
{
var cq = model.ToDataResult <NhomCoQuanResult>().Update(u => { u.CreatedBy = UserName; });
return await ExecuteResultAsync(async() => await NhomCoQuanRepository.AddAsync(cq));
}));
}
public async Task <JsonResult> Create(BaseDataViewModel model)
{
return(await ExecuteWithErrorHandling(async() =>
{
var result = model.ToDataResult <LinhVucCongViecResult>().Update(u => { u.CreatedBy = UserName; });
return await ExecuteResultAsync(async() => await CongViecRepository.AddAsync(result));
}));
}
public async Task <JsonResult> Create(BaseDataViewModel model)
{
return(await ExecuteWithErrorHandling(async() =>
{
var ht = model.ToDataResult <MucDoHoanThanhResult>().Update(u => { u.CreatedBy = UserName; });
return await ExecuteResultAsync(async() => await MucDoRepository.AddAsync(ht));
}));
}
public BaseDataViewModel GetBaseGameCounts()
{
var baseCounts = new BaseDataViewModel
{
ChampionsCount = this.championsRepository.AllAsNoTracking().Count(),
ItemsCount = this.itemsRepository.AllAsNoTracking().Count(),
SummonerSpellsCount = this.summonerSpellsRepository.AllAsNoTracking().Count(),
RunesCount = this.runesRepository.AllAsNoTracking().Count(),
};
return(baseCounts);
}
public async Task <JsonResult> Edit(int id, BaseDataViewModel model)
{
return(await ExecuteWithErrorHandling(async() =>
{
var vq = model.ToDataResult <NhomCoQuanResult>().Update(u =>
{
u.Id = id;
u.LastUpdatedBy = UserName;
});
return await ExecuteResultAsync(async() => await NhomCoQuanRepository.UpdateAsync(vq));
}));
}
public async Task <JsonResult> Edit(int id, BaseDataViewModel model)
{
return(await ExecuteWithErrorHandling(async() =>
{
var cv = model.ToDataResult <LinhVucCongViecResult>().Update(u =>
{
u.Id = id;
u.LastUpdatedBy = UserName;
});
return await ExecuteResultAsync(async() => await CongViecRepository.UpdateAsync(cv));
}));
}
public ActionResult Index()
{
var currentProject = GetProjectInSession();
if (currentProject == null)
{
return(View(new List <BaseDataViewModel>()));
}
var userId = User.Identity.GetUserId();
var registeredUsers = HttpContext.GetOwinContext().GetUserManager <ApplicationUserManager>().Users.Where(e => e.Id == userId).Include("UserInfo").ToList();
if (!registeredUsers.Any())
{
return(View(new List <BaseDataViewModel>()));
}
var enrolledBy = registeredUsers[0].UserInfo.Id;
var approved = (int)EnumManager.ApprovalStatus.Approved;
var baseDataList = new List <BaseDataViewModel>();
var connStr = ConfigurationManager.ConnectionStrings["crimsDbEntities"].ConnectionString;;
var conn = new MySqlConnection(connStr);
conn.Open();
if (User.IsInRole("Admin") || User.IsInRole("Site_Administrator"))
{
var sql = $"SELECT t.*, o.* FROM basedatas t JOIN userprofiles o ON o.Id = t.CreatedBy WHERE t.ProjectCode ='{currentProject.ProjectCode}' AND t.ApprovalStatus = '{approved}'";
var cmd = new MySqlCommand(sql, conn);
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
if (!rdr.HasRows)
{
continue;
}
var dateRegistered = Convert.ToDateTime(rdr["EnrollmentDate"].ToString());
var enrollmentDateStr = dateRegistered.ToString("dd/MM/yyyy");
var newUser = new BaseDataViewModel
{
TableId = Convert.ToInt32(rdr["TableId"].ToString()),
EnrollmentId = rdr["EnrollmentId"].ToString(),
ProjectCode = rdr["ProjectCode"].ToString(),
ProjectSiteId = rdr["ProjectSiteId"].ToString(),
Surname = rdr["Surname"].ToString(),
Firstname = rdr["Firstname"].ToString(),
EnrollmentOfficer = rdr["FullName"] + " (" + rdr["PhoneNumber"] + ")",
MiddleName = rdr["MiddleName"].ToString(),
Gender = rdr["Gender"].ToString(),
Title = rdr["Title"].ToString(),
Email = rdr["Email"].ToString(),
EnrollmentDateStr = enrollmentDateStr,
MobileNumber = rdr["MobileNumber"].ToString(),
CuntryCode = rdr["CuntryCode"].ToString(),
ProjectPrimaryCode = rdr["ProjectPrimaryCode"].ToString(),
DOB = rdr["DOB"].ToString(),
BiometricStatus = "Completed",
ApprovalStatus = Convert.ToInt32(rdr["ApprovalStatus"].ToString()),
EnrollmentDate = dateRegistered,
ValidIdNumber = rdr["ValidIdNumber"].ToString()
};
baseDataList.Add(newUser);
}
}
}
else
{
if (!User.IsInRole("Enrollee"))
{
var sql2 = $"SELECT t.*, o.* FROM basedatas t JOIN userprofiles o ON o.Id = t.CreatedBy WHERE t.ProjectCode ='{currentProject.ProjectCode}' AND t.ApprovalStatus = '{approved}' AND (t.CreatedBy = '{enrolledBy}' OR t.LastUpdatedby = '{enrolledBy}')";
var cmd2 = new MySqlCommand(sql2, conn);
using (var rdr = cmd2.ExecuteReader())
{
while (rdr.Read())
{
if (!rdr.HasRows)
{
continue;
}
var dateRegistered = Convert.ToDateTime(rdr["EnrollmentDate"].ToString());
var enrollmentDateStr = dateRegistered.ToString("dd/MM/yyyy");
var newUser = new BaseDataViewModel
{
TableId = Convert.ToInt32(rdr["TableId"].ToString()),
EnrollmentId = rdr["EnrollmentId"].ToString(),
ProjectCode = rdr["ProjectCode"].ToString(),
ProjectSiteId = rdr["ProjectSiteId"].ToString(),
Surname = rdr["Surname"].ToString(),
Firstname = rdr["Firstname"].ToString(),
EnrollmentOfficer = rdr["FullName"] + " (" + rdr["PhoneNumber"] + ")",
MiddleName = rdr["MiddleName"].ToString(),
Gender = rdr["Gender"].ToString(),
Title = rdr["Title"].ToString(),
EnrollmentDateStr = enrollmentDateStr,
Email = rdr["Email"].ToString(),
MobileNumber = rdr["MobileNumber"].ToString(),
CuntryCode = rdr["CuntryCode"].ToString(),
ProjectPrimaryCode = rdr["ProjectPrimaryCode"].ToString(),
DOB = rdr["DOB"].ToString(),
BiometricStatus = "Completed",
ApprovalStatus = Convert.ToInt32(rdr["ApprovalStatus"].ToString()),
EnrollmentDate = dateRegistered,
ValidIdNumber = rdr["ValidIdNumber"].ToString()
};
baseDataList.Add(newUser);
}
}
}
else
{
return(Redirect("Enrollment"));
}
}
if (!baseDataList.Any())
{
return(View(new List <BaseDataViewModel>()));
}
baseDataList.ForEach(p =>
{
var enumName = Enum.GetName(typeof(EnumManager.ApprovalStatus), p.ApprovalStatus);
if (enumName != null)
{
p.ApprovalStatusStr = enumName.Replace("_", " ");
}
});
return(View(baseDataList));
}
