public void AddCompanyStats(
string CompanyCode,
int OpenedThisYear,
int SettledThisYear,
int CurrentVersion,
string[] userlist,
string[] ipaddresses,
DateTime[] userLastLoggedOn
)
{
using (DataBaseContext context = new DataBaseContext())
{
int currentIndex = 0;
var company = (from obj in context.Companies
where obj.CompanyCode == CompanyCode
select obj).First();
if (company.CompanyDetail != null)
{
company.CompanyDetail.OpenedThisYear = OpenedThisYear;
company.CompanyDetail.SettledThisYear = SettledThisYear;
company.CompanyDetail.CurrentVersion = CurrentVersion;
}
else
{
CompanyDetail newDetail = new CompanyDetail();
newDetail.OpenedThisYear = OpenedThisYear;
newDetail.SettledThisYear = SettledThisYear;
newDetail.CurrentVersion = CurrentVersion;
newDetail.Company = company;
context.AddToCompanyDetails(newDetail);
}
bool canInsertUser = (company.SettUsers.Count() == userlist.Count() &&
company.SettUsers.Count() == ipaddresses.Count() &&
company.SettUsers.Count() == userLastLoggedOn.Count()
);
if (canInsertUser)
{
foreach (var current in company.SettUsers)
{
SettUser newUser = new SettUser();
newUser.UserName = userlist[currentIndex];
newUser.IPAddress = ipaddresses[currentIndex]; //??? needs change type of field ipaddress
newUser.LastLogonDate = userLastLoggedOn[currentIndex];
newUser.Company = company;
context.AddToSettUsers(newUser);
++currentIndex;
}
}
else
{
//Handle error here
}
}
}
public async Task <IActionResult> Delete(long UserId = 0, long SettingId = 0)
{
SettUser settUser = await _context.SettUser.SingleAsync(m => m.UserId == UserId && m.SettingId == SettingId);
if (settUser == null)
{
return(HttpNotFound());
}
return(View(settUser));
}
// GET: SettUsers/Edit/5
public async Task <IActionResult> Edit(long UserId = 0, long SettingId = 0)
{
SettUser settUser = await _context.SettUser.SingleAsync(m => m.UserId == UserId && m.SettingId == SettingId);
if (settUser == null)
{
return(HttpNotFound());
}
ViewData["SettingId"] = new SelectList(_context.DictSettUser, "Id", "Setting", settUser.SettingId);
ViewData["UserId"] = new SelectList(_context.Users, "Id", "User", settUser.UserId);
return(View(settUser));
}
public async Task <IActionResult> Edit(SettUser settUser)
{
if (ModelState.IsValid)
{
_context.Update(settUser);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewData["SettingId"] = new SelectList(_context.DictSettUser, "Id", "Setting", settUser.SettingId);
ViewData["UserId"] = new SelectList(_context.Users, "Id", "User", settUser.UserId);
return(View(settUser));
}
public async Task <IActionResult> DeleteConfirmed(long UserId = 0, long SettingId = 0)
{
SettUser settUser = await _context.SettUser.SingleAsync(m => m.UserId == UserId && m.SettingId == SettingId);
if (settUser == null)
{
return(HttpNotFound());
}
_context.SettUser.Remove(settUser);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
