/////////////////////////////Insert Data To DataBase Function/////////////////////////////////////////////// public string Insert(UserInformation userInformation) { using (Justice_Ngwenya_Project_API_DBEntities dBEntities = new Justice_Ngwenya_Project_API_DBEntities()) { try { UserInformation uowUserInformation = new UserInformation(); uowUserInformation.User_ID = userInformation.User_ID; uowUserInformation.First_Name = userInformation.First_Name; uowUserInformation.Last_Name = userInformation.Last_Name; uowUserInformation.Gender = userInformation.Gender; uowUserInformation.Organization = userInformation.Organization; uowUserInformation.Phone_Number = userInformation.Phone_Number; uowUserInformation.Postal_Code = userInformation.Postal_Code; uowUserInformation.Province = userInformation.Province; uowUserInformation.Email = userInformation.Email; uowUserInformation.Date_Of_Birth = userInformation.Date_Of_Birth; uowUserInformation.Country = userInformation.Country; uowUserInformation.City = userInformation.City; uowUserInformation.Age = userInformation.Age; uowUserInformation.Address = userInformation.Address; dBEntities.UserInformation.Add(uowUserInformation); dBEntities.SaveChanges(); return("Success"); } catch (Exception) { return("Failed"); } } }
//=========================================Get User Information Function======================================================= public string LoadUser(string userId) { using (Justice_Ngwenya_Project_API_DBEntities dBEntities = new Justice_Ngwenya_Project_API_DBEntities()) { try { var user = (from a in dBEntities.UserInformation where a.User_ID == userId select a).FirstOrDefault(); UserInformation uowUserInformation = new UserInformation { User_ID = user.User_ID, First_Name = user.First_Name, Last_Name = user.Last_Name, Gender = user.Gender, Organization = user.Organization, Phone_Number = user.Phone_Number, Postal_Code = user.Postal_Code, Province = user.Province, Email = user.Email, Date_Of_Birth = user.Date_Of_Birth, Country = user.Country, City = user.City, Age = user.Age, Address = user.Address }; return(new JavaScriptSerializer().Serialize(uowUserInformation)); } catch (Exception) { return("Failed"); } } }
//===========================================Update UserInformation Function =========================================================== public string Update(UserInformation userInformation) { using (Justice_Ngwenya_Project_API_DBEntities dBEntities = new Justice_Ngwenya_Project_API_DBEntities()) { try { var user = (from a in dBEntities.UserInformation where a.User_ID == userInformation.User_ID select a).FirstOrDefault(); user.First_Name = userInformation.First_Name; user.Last_Name = userInformation.Last_Name; user.Gender = userInformation.Gender; user.Organization = userInformation.Organization; user.Phone_Number = userInformation.Phone_Number; user.Postal_Code = userInformation.Postal_Code; user.Province = userInformation.Province; user.Email = userInformation.Email; user.Date_Of_Birth = userInformation.Date_Of_Birth; user.Country = userInformation.Country; user.City = userInformation.City; user.Age = userInformation.Age; user.Address = userInformation.Address; dBEntities.SaveChanges(); return("Success"); } catch (Exception) { return("Failed"); } } }
//Get all Customers public string getAllCustomers() { try { List <Customer> customerList = new List <Customer>(); using (Justice_Ngwenya_Project_API_DBEntities db = new Justice_Ngwenya_Project_API_DBEntities()) { customerList = db.Customer.ToList <Customer>(); return(JsonConvert.SerializeObject(customerList)); } } catch (Exception ex) { return(null); } }
//=======================================Delete User Function============================================ public string Delete(string userID) { using (Justice_Ngwenya_Project_API_DBEntities dBEntities = new Justice_Ngwenya_Project_API_DBEntities()) { try { UserInformation info = dBEntities.UserInformation.Single(a => a.User_ID == userID); dBEntities.UserInformation.Remove(info); dBEntities.SaveChanges(); return("Success"); } catch (Exception) { return("Failed"); } } }