public DBModel.Admin getAnsatt(string id) { if (id == null) { var ansatt = new DBModel.Admin() { AnsattId = "0", }; return ansatt; } var ansatte = new DBModel.Admin() { AnsattId = "s1", Epost = "*****@*****.**", Firstname = "Arne", Lastname = "Hansen", Stilling = "Leder" }; return ansatte; }
public List<DBModel.Admin> getAnsattList(string status) { var liste = new List<DBModel.Admin>(); var ansatte = new DBModel.Admin(); if (status == null) { ansatte = new DBModel.Admin() { AnsattId = "", }; liste.Add(ansatte); liste.Add(ansatte); liste.Add(ansatte); return liste; } ansatte = new DBModel.Admin() { AnsattId = "s1", Epost = "*****@*****.**", Firstname = "Arne", Lastname = "Hansen", Stilling = "Leder" }; liste.Add(ansatte); liste.Add(ansatte); liste.Add(ansatte); return liste; }
public List<DBModel.Admin> sokAnsattList(string sok) { try { var liste = new List<DBModel.Admin>(); if (sok == "" || sok == null) return getAnsattList(); var ansatte = db.Admins.Where(u => u.Firstname.Contains(sok) || u.Lastname.Contains(sok) || u.AnsattId.Contains(sok)); foreach (var item in ansatte) { var ansatt = new DBModel.Admin(); ansatt.AnsattId = item.AnsattId; ansatt.Epost = item.Epost; ansatt.Firstname = item.Firstname; ansatt.Lastname = item.Lastname; ansatt.Stilling = item.Stilling; liste.Add(ansatt); } return liste; } catch (System.Data.SqlClient.SqlException ex) { SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (InvalidOperationException ex) { SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (ArgumentException ex) { SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (NullReferenceException ex) { SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (SystemException ex) { SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (Exception ex) { SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } return null; }
public DBModel.Admin getAnsatt(string id) { try { if (id == null || id == "") return null; var dbAdmin = db.Admins.FirstOrDefault(u => u.AnsattId == id); if (dbAdmin != null) { var admin = new DBModel.Admin(); admin.AnsattId = dbAdmin.AnsattId; admin.Epost = dbAdmin.Epost; admin.Firstname = dbAdmin.Firstname; admin.Lastname = dbAdmin.Lastname; admin.Stilling = dbAdmin.Stilling; return admin; } return null;//admin ikke funnet. } catch (System.Data.SqlClient.SqlException ex) { SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (InvalidOperationException ex) { SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (ArgumentException ex) { SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (NullReferenceException ex) { SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (SystemException ex) { SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } catch (Exception ex) { SWKA.WriteLine("Message :" + ex.Message + "<br/>" + Environment.NewLine + "StackTrace :" + ex.StackTrace + "" + Environment.NewLine + "Date :" + DateTime.Now.ToString()); SWKA.WriteLine(Environment.NewLine + "-----------------------------------------------------------------------------" + Environment.NewLine); } return null; }