/////////////////////////////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"); } } }
//===========================================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"); } } }
//=======================================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"); } } }