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