public async Task <IActionResult> Save([FromBody] LeaveType leaveType)
{
int result = 0;
try
{
leaveType.ID = Guid.NewGuid();
context.Add(leaveType);
result = await context.SaveChangesAsync();
}
catch (Exception ex)
{
logger.LogError(ex.ToString());
}
return(Ok(result));
}
public async Task <IActionResult> Save([FromBody] EmployeeInsurance employeeInsurance)
{
int result = 0;
try
{
employeeInsurance.EmployeeInsuranceId = Guid.NewGuid();
context.Add(employeeInsurance);
result = await context.SaveChangesAsync();
}
catch (Exception ex)
{
logger.LogError(ex.ToString());
}
return(Ok(result));
}
public async Task <IActionResult> Create([Bind("Id,Access,Accommodates,Bathrooms,BedTypeId,Bedrooms,CancellationPolicyId,CleaningFee,Description,ExtraPeople,GuestsIncluded,HostId,HouseRules,Interaction,IsBusinessTravelReady,Latitude,ListingUrl,Longitude,MaximumNights,MinimumNights,MonthlyPrice,Name,NeighborhoodId,NeighborhoodOverview,Notes,PictureUrl,Price,PropertyTypeId,RequireGuestPhoneVerification,RequireGuestProfilePicture,ReviewScoresAccuracy,ReviewScoresCheckin,ReviewScoresCleanliness,ReviewScoresCommunication,ReviewScoresLocation,ReviewScoresRating,ReviewScoresValue,RoomTypeId,SecurityDeposit,Space,SquareFeet,Summary,Transit,WeeklyPrice")] Listing listing)
{
if (ModelState.IsValid)
{
_context.Add(listing);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["BedTypeId"] = new SelectList(_context.BedTypes, "Id", "Name", listing.BedTypeId);
ViewData["CancellationPolicyId"] = new SelectList(_context.CancellationPolicies, "Id", "Name", listing.CancellationPolicyId);
ViewData["HostId"] = new SelectList(_context.Hosts, "Id", "PictureUrl", listing.HostId);
ViewData["NeighborhoodId"] = new SelectList(_context.Neighborhoods, "Id", "Name", listing.NeighborhoodId);
ViewData["PropertyTypeId"] = new SelectList(_context.PropertyTypes, "Id", "Name", listing.PropertyTypeId);
ViewData["RoomTypeId"] = new SelectList(_context.RoomTypes, "Id", "Name", listing.RoomTypeId);
return(View(listing));
}
public async Task <IActionResult> Save([FromBody] ClaimRequest claimRequest)
{
int result = 0;
try
{
claimRequest.ID = Guid.NewGuid();
context.Add(claimRequest);
result = await context.SaveChangesAsync();
}
catch (Exception ex)
{
logger.LogError(ex.ToString());
}
return(Ok(result));
}
public async Task <IActionResult> Create([Bind("Id,Brandid,Modelid,Colorid,Status,Plate,Dailyprice")] Car car)
{
if (ModelState.IsValid)
{
_context.Add(car);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
//ViewData["BrandName"] = new SelectList(_context.Brands, "Brandname", "Brandname");
ViewData["Brandid"] = new SelectList(_context.Brands, "Id", "Id", car.Brandid);
ViewData["Colorid"] = new SelectList(_context.Colors, "Id", "Id", car.Colorid);
ViewData["Modelid"] = new SelectList(_context.Models, "Id", "Id", car.Modelid);
return(View(car));
}
public bool InsertFinaTable()
{
var finaList = new List <FinaDifficultyModel>();
using (StreamReader r = new StreamReader(@"C:\Users\pontu\Desktop\SoP\DiveComp\DiveComp.Data\Helpers\FinaTable.json"))
{
string json = r.ReadToEnd();
finaList = JsonConvert.DeserializeObject <List <FinaDifficultyModel> >(json);
}
foreach (var diveobject in finaList)
{
db.Add(diveobject);
}
db.SaveChanges();
return(true);
}
public async Task <IActionResult> Create([Bind("ID,InstitutionID,Name")] School school)
{
if (User.FindFirst("Role").Value == "Admin")
{
if (ModelState.IsValid)
{
_context.Add(school);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(school));
}
else
{
return(NotFound("Access Dinied"));
}
}
public IActionResult Register(AuthViewModel Auth)
{
System.Console.WriteLine(Auth.RegForm);
UserModel submission = new UserModel()
{
FirstName = Auth.RegForm.FirstName,
LastName = Auth.RegForm.LastName,
Email = Auth.RegForm.Email,
Password = Auth.RegForm.Password,
ConfirmPassword = Auth.RegForm.ConfirmPassword
};
string check = submission.Email == null ? null : submission.Email.ToLower();
UserModel Query = _context.Users.Where(user => user.Email.ToLower() == check).FirstOrDefault();
if (ModelState.IsValid && Query == null)
{
PasswordHasher <UserModel> Hasher = new PasswordHasher <UserModel> ();
submission.Password = Hasher.HashPassword(submission, submission.Password);
_context.Add(submission);
_context.SaveChanges();
HttpContext.Session.SetInt32("UserId", submission.UserId);
return(RedirectToAction("Result"));
}
else
{
TempData["fname"] = submission.FirstName;
TempData["lname"] = submission.LastName;
TempData["emailAddress"] = submission.Email;
foreach (string key in ModelState.Keys)
{
string field = key.Substring(8);
System.Console.WriteLine(field);
ModelStateEntry entry = ModelState[key];
string error = entry.Errors.Select(e => e.ErrorMessage).FirstOrDefault();
System.Console.WriteLine(error);
TempData[field] = error;
}
if (Query != null && TempData["Email"] == null)
{
TempData["Email"] = "Email is not unique.";
}
return(RedirectToAction("Index"));
}
}
public async Task <IActionResult> Create([Bind("Transfuzjaid,Pielegniarkaid,Badaniaid,Pacjentid,PotrzebnaIlosc,DataTransfuzji")] Transfuzja transfuzja)
{
if (ModelState.IsValid)
{
_context.Add(transfuzja);
await _context.SaveChangesAsync();
_context.Attach(transfuzja).State = EntityState.Detached;
return(RedirectToAction(nameof(Index)));
}
var pacjent = _context.Pacjent.Include(x => x.Osoba);
var pielegniarka = _context.Pielegniarka.Include(x => x.Osoba);
ViewData["Badaniaid"] = new SelectList(_context.Badania, "Badaniaid", "Badaniaid", transfuzja.Badaniaid);
ViewData["Pacjentid"] = new SelectList(pacjent, "Pacjentid", "Info", transfuzja.Pacjentid);
ViewData["Pielegniarkaid"] = new SelectList(pielegniarka, "Pielegniarkaid", "Info", transfuzja.Pielegniarkaid);
return(View(transfuzja));
}
public async Task <IActionResult> Save([FromBody] Employee employee)
{
int result = 0;
try
{
employee.ID = Guid.NewGuid();
employee.ApprovalLineId = Guid.Empty;
employee.CreatedDate = DateTime.Now;
employee.ModifiedDate = DateTime.Now;
context.Add(employee);
result = await context.SaveChangesAsync();
}
catch (Exception ex)
{
logger.LogError(ex.ToString());
}
return(Ok(result));
}
public async Task <IActionResult> Create([Bind("Donacjaid,Donatorid,Badaniaid,Pielegniarkaid,Typid,IloscDonacji,Datadonacji")] Donacja donacja)
{
if (ModelState.IsValid)
{
_context.Add(donacja);
await _context.SaveChangesAsync();
_context.Attach(donacja).State = EntityState.Detached;
return(RedirectToAction(nameof(Index)));
}
var donator = _context.Donator.Include(x => x.Osoba).Where(x => x.Osobaid != null);
var pielegniarki = _context.Pielegniarka.Include(x => x.Osoba).Where(x => x.Osobaid != null);
ViewData["Badaniaid"] = new SelectList(_context.Badania, "Badaniaid", "Badaniaid", donacja.Badaniaid);
ViewData["Donatorid"] = new SelectList(donator, "Donatorid", "Info", donacja.Donatorid);
ViewData["Pielegniarkaid"] = new SelectList(pielegniarki, "Pielegniarkaid", "Info", donacja.Pielegniarkaid);
ViewData["Typid"] = new SelectList(_context.TypDonacji, "Typid", "Typ", donacja.Typid);
return(View(donacja));
}
public async Task <IActionResult> Save([FromBody] Leave leave)
{
int result = 0;
try
{
leave.ID = Guid.NewGuid();
leave.CreatedDate = DateTime.Now;
leave.ModifiedDate = DateTime.Now;
leave.Status = "Submitted";
leave.IsTaken = false;
context.Add(leave);
result = await context.SaveChangesAsync();
}
catch (Exception ex)
{
logger.LogError(ex.ToString());
}
return(Ok(result));
}
/// <summary>
/// Adds an employee to the databse.
/// </summary>
/// <param name="salary"></param>
/// <param name="properties"></param>
/// <returns>returns the number of rows affected </returns>
public int AddEmployee(double salary, params string[] properties)
{
string DeptID = FetchDepartmentId(properties[5]);
CheckForDuplicateEmail(properties[2]);
using var context = new ModelContext();
var newEmployee = new Employee
{
EmployeeId = Guid.NewGuid().ToString(),
FirstName = properties[0],
LastName = properties[1],
Email = properties[2],
PhoneNumber = properties[3],
State = properties[4],
Salary = salary,
DepartmentId = DeptID
};
context.Add <Employee>(newEmployee);
return(context.SaveChanges());
}
protected override void AddItem(EduLevelInfo item)
{
ModelContext.Add(item);
ModelContext.SaveChanges();
}
public void Run()
{
UiHelpers.InitConsole();
// drop database file for testing purpose
//File.Delete(ModelContext.DataBaseFile);
using (var db = new ModelContext()) {
// create DB if not exists
db.Database.EnsureDeleted();
db.Database.EnsureCreated();
GsoLogger.LoggingEnabled = false;
// populate DB
if (db.Persons.OfType <Admin>().Count() == 0)
{
db.Add(new Admin()
{
FirstName = "Adalbert", LastName = "Acker", Department = "Service"
});
db.Add(new Admin()
{
FirstName = "Agate", LastName = "Ahrweiler", Department = "Service"
});
db.SaveChanges();
}
if (db.Persons.OfType <Employee>().Where(p => !(p is Admin)).Count() == 0)
{
var boss = new Employee()
{
FirstName = "Egon", LastName = "Boss", Department = "Customer"
};
db.Add(boss);
db.Add(new Employee()
{
FirstName = "Ernst", LastName = "Ecker", LineManager = boss, Department = "Customer"
});
db.Add(new Employee()
{
FirstName = "Emilia", LastName = "Eichberg", LineManager = boss, Department = "Customer"
});
db.SaveChanges();
}
if (db.Persons.OfType <Member>().Count() == 0)
{
db.AddRange(SvcImport.ImportMembers3(@"../../../Data/fake-persons.txt"));
db.SaveChanges();
}
if (db.Mediums.Count() == 0)
{
var mediums = SvcImport.ImportMediums3(@"../../../Data/spiegel-bestseller.txt");
db.AddRange(mediums);
db.SaveChanges();
}
if (db.Items.Count() == 0)
{
db.Add(new Item()); // { Id = 1000 });
db.Add(new Item());
db.Add(new Item());
db.SaveChanges();
}
GsoLogger.LoggingEnabled = true;
//ShowStuff();
var svc = new SvcCityLibrary(db);
var menu = new UiMenu(svc);
while (true)
{
menu.ShowMainMenu();
Console.ReadLine();
}
Console.WriteLine("\nDone.");
Console.ReadLine();
}
}
protected override void AddItem(PositionInfo item)
{
ModelContext.Add(item);
ModelContext.SaveChanges();
}
public IActionResult AddCodes([Bind("CountryId,NetworkId,R,Values")] Codes codes)
{
if (ModelState.IsValid)
{
bool _isNewCodeAdded = false;
foreach (var code in codes.Values)
{
var codeInDb = _context.Codes.Where(c => c.R == codes.R && c.Value == code).FirstOrDefault();
if (codeInDb == null)
{
#region Reduce codes
if (codes.R.Length == 1)
{
var _Rcodes = _context.Codes.Where(c => c.R == codes.R);
// R = root, nothing to add
if (_Rcodes.Count() != 0 && _Rcodes.FirstOrDefault().Value == null)
{
break;
}
// all codes of specific R and network
var _codesByNetworkAndR = _Rcodes.Where(c => c.NetworkId == codes.NetworkId);
if (_codesByNetworkAndR != null)
{
// all entries d** and dd*
var _entriesCodes = _codesByNetworkAndR.Where(c => c.Value.StartsWith(code.Remove(code.Length - 2)));
if (codes.Values.Count() == 1)
{
if (_entriesCodes != null)
{
// filter codes to find AB codes of one network // 3 -> 2
List <Code> _threeDigitsCodes = new List <Code>();
foreach (var c in _entriesCodes)
{
if (c.Value.Length == 3 && c.Value.StartsWith(code.Remove(code.Length - 1)))
{
_threeDigitsCodes.Add(c);
}
}
if (_threeDigitsCodes.Count > 0)
{
if (_threeDigitsCodes.Count == 9)
{
// check if DB contains collapsed codes of specific network. Ex.: [country][R][00*]
// 2 -> 1
List <Code> _twoDigitsCodes = new List <Code>();
foreach (var _code in _entriesCodes)
{
if (_code.Value.Length == 2 && _code.Value.StartsWith(code.Remove(code.Length - 2)))
{
_twoDigitsCodes.Add(_code);
}
}
if (_twoDigitsCodes.Count() == 9)
{
// check if DB contains collapsed codes by R. Ex.: [country][R]
// 1 -> R
List <Code> _oneDigitCodes = new List <Code>();
foreach (var _code in _entriesCodes)
{
if (_code.Value.Length == 1)
{
_oneDigitCodes.Add(_code);
}
}
if (_oneDigitCodes.Count == 99)
{
_context.Codes.RemoveRange(_oneDigitCodes);
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId,
NetworkId = codes.NetworkId,
R = codes.R,
Value = null
});
_isNewCodeAdded = true;
}
else
{
_context.Codes.RemoveRange(_twoDigitsCodes);
_context.Codes.RemoveRange(_threeDigitsCodes);
// collapse codes to one digit code (value)
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId,
NetworkId = codes.NetworkId,
R = codes.R,
Value = code.Remove(code.Length - 2)
});
_isNewCodeAdded = true;
}
}
else
{
_context.Codes.RemoveRange(_threeDigitsCodes);
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId,
NetworkId = codes.NetworkId,
R = codes.R,
Value = code.Remove(code.Length - 1)
});
_isNewCodeAdded = true;
}
}
else
{
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId, NetworkId = codes.NetworkId, R = codes.R, Value = code
});
_isNewCodeAdded = true;
}
}
else
{
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId, NetworkId = codes.NetworkId, R = codes.R, Value = code
});
_isNewCodeAdded = true;
}
}
}
else if (codes.Values.Count() == 10)
{
// 2 -> 1
List <Code> _twoDigitsCodes = new List <Code>();
List <Code> _threeDigitsCodes = new List <Code>();
foreach (var _code in _entriesCodes)
{
if (_code.Value.Length == 2 && _code.Value.StartsWith(code.Remove(code.Length - 2)))
{
_twoDigitsCodes.Add(_code);
}
else if (_code.Value.Length == 3 && _code.Value.StartsWith(code.Remove(code.Length - 2)))
{
_threeDigitsCodes.Add(_code);
}
}
if (_twoDigitsCodes.Count == 9)
{
// 1 -> R
List <Code> _oneDigitCodes = new List <Code>();
foreach (var _code in _entriesCodes)
{
if (_code.Value.Length == 1)
{
_oneDigitCodes.Add(_code);
}
}
if (_oneDigitCodes.Count == 9)
{
_context.Codes.RemoveRange(_oneDigitCodes);
if (_threeDigitsCodes.Count > 0)
{
_context.Codes.RemoveRange(_threeDigitsCodes);
}
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId,
NetworkId = codes.NetworkId,
R = codes.R,
Value = null
});
_isNewCodeAdded = true;
}
else
{
_context.Codes.RemoveRange(_twoDigitsCodes);
if (_threeDigitsCodes.Count > 0)
{
_context.Codes.RemoveRange(_threeDigitsCodes);
}
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId,
NetworkId = codes.NetworkId,
R = codes.R,
Value = code.Remove(code.Length - 2)
});
_isNewCodeAdded = true;
}
}
else
{
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId,
NetworkId = codes.NetworkId,
R = codes.R,
Value = code.Remove(code.Length - 1)
});
_isNewCodeAdded = true;
}
break;
}
else if (codes.Values.Count() == 500)
{
// 1 -> R
List <Code> _oneDigitCodes = new List <Code>();
byte _count = 0;
foreach (var _code in _codesByNetworkAndR)
{
if (_code.Value?.Length == 1)
{
_oneDigitCodes.Add(_code);
}
}
for (int i = 0; i < 5; i++)
{
if (_oneDigitCodes.Find(c => c.Value == i.ToString()) != null)
{
++_count;
}
}
// check if from one table
if (_oneDigitCodes.Count == 5 && _count == 5)
{
_context.RemoveRange(_Rcodes);
_context.Add(new Code()
{
CountryId = codes.CountryId,
NetworkId = codes.NetworkId,
R = codes.R,
Value = null
});
_isNewCodeAdded = true;
}
else
{
// 3 -> 1
_context.RemoveRange(_oneDigitCodes);
for (int i = 0; i < codes.Values.Count(); i += 100)
{
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId,
NetworkId = codes.NetworkId,
R = codes.R,
Value = codes.Values[i].Remove(codes.Values[i].Length - 2)
});
}
_isNewCodeAdded = true;
}
break;
}
}
else
{
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId, NetworkId = codes.NetworkId, R = codes.R, Value = code
});
_isNewCodeAdded = true;
}
}
else
{
if (codes.Values.Count() == 1)
{
if (codes.R.Remove(codes.R.Length - 1).Length > 0)
{
string _zone = codes.R;
string _code = code;
Dictionary <string, string> _keyValuePairs = new Dictionary <string, string>();
while (_zone.Remove(_zone.Length - 1).Length > 0)
{
_code = $"{_zone[_zone.Length - 1]}{_code.Remove(_code.Length - 1)}";
_keyValuePairs.Add(_zone.Remove(_zone.Length - 1), _code);
_zone = _zone.Remove(_zone.Length - 1);
}
// retreive root code
Code _rootCode = null;
foreach (var item in _keyValuePairs)
{
_rootCode = _context.Codes.Where(c => c.R == item.Key && c.Value == item.Value).FirstOrDefault();
}
if (_rootCode != null)
{
int _networkId = 0;
// expand _rootCode
string t = $"{codes.R}{code}".Remove(0, $"{_rootCode.R}{_rootCode.Value}".Length);
for (int i = 0; i <= 9; i++)
{
// codes painting
if (i.ToString()[0] != t[0])
{
_networkId = _rootCode.NetworkId;
}
else
{
_networkId = codes.NetworkId;
}
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId,
NetworkId = _networkId,
R = $"{_rootCode.R}{_rootCode.Value[0]}",
Value = $"{_rootCode.Value[1]}{_rootCode.Value[2]}{i}"
});
}
// add new code
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId,
NetworkId = codes.NetworkId,
R = codes.R,
Value = code
});
// delete _rootCode
if (_context.Codes.Remove(_rootCode) != null)
{
_isNewCodeAdded = true;
break;
}
}
}
var _inLineDBCodes = _context.Codes.Where(c =>
c.NetworkId == codes.NetworkId &&
c.R == codes.R &&
c.Value.StartsWith(code.Remove(code.Length - 1)));
if (_inLineDBCodes.Count() == 9)
{
string _parentCode = codes.R[codes.R.Length - 1] + code.Remove(code.Length - 1);
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId,
NetworkId = codes.NetworkId,
R = codes.R.Remove(codes.R.Length - 1),
Value = _parentCode
});
_isNewCodeAdded = true;
_context.Codes.RemoveRange(_inLineDBCodes);
break;
}
}
else if (codes.Values.Count() == 10)
{
string _parentCode = codes.R[codes.R.Length - 1] + code.Remove(code.Length - 1);
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId,
NetworkId = codes.NetworkId,
R = codes.R.Remove(codes.R.Length - 1),
Value = _parentCode
});
_isNewCodeAdded = true;
break;
}
_context.Codes.Add(new Code()
{
CountryId = codes.CountryId, NetworkId = codes.NetworkId, R = codes.R, Value = code
});
_isNewCodeAdded = true;
}
#endregion
}
else
{//reassign code
if (codeInDb.NetworkId == codes.NetworkId)
{
continue;
}
codeInDb.NetworkId = codes.NetworkId;
_context.Entry(codeInDb).State = EntityState.Modified;
_isNewCodeAdded = true;
}
}
if (_isNewCodeAdded == false)
{
return(new StatusCodeResult(StatusCodes.Status400BadRequest));
}
_context.SaveChanges();
return(new StatusCodeResult(StatusCodes.Status200OK));
}
return(new StatusCodeResult(StatusCodes.Status400BadRequest));
}
protected override void AddItem(DocumentTypeInfo item)
{
ModelContext.Add <DocumentTypeInfo> (item);
ModelContext.SaveChanges();
}
protected override void AddItem(ScienceRecordTypeInfo item)
{
ModelContext.Add(item);
ModelContext.SaveChanges();
}
protected override void AddItem(AchievementTypeInfo item)
{
ModelContext.Add(item);
ModelContext.SaveChanges();
}
protected override void AddItem(EduFormInfo item)
{
ModelContext.Add <EduFormInfo> (item);
ModelContext.SaveChanges();
}