public static bool DeleteUser(String userId)
{
var context = new ShipmentEntities3();
int userid1 = Convert.ToInt32(userId);
var query = from user in context.UserTables
where user.UserID == userid1
select user;
if (query != null)
{
try
{
foreach (UserTable user in query)
{
context.UserTables.Remove(user);
}
context.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
return false;
}
public static bool Authenticate(String userID,String password)
{
var context = new ShipmentEntities3();
List<UserTable> userList=context.UserTables.ToList();
foreach (UserTable user in userList)
{
if (user.UserID.Equals(userID) && user.Password.Equals(password))
return true;
}
return false;
}
public static UserTable FindUser(String userid)
{
var context = new ShipmentEntities3();
/* List<UserTable> userList = context.UserTables.ToList();
foreach (UserTable user in userList)
{
if (user.UserID.Equals(userID))
return user;
}*/
var query = from user in context.UserTables
where user.UserID.ToString() == userid
select user;
UserTable userTable=query.First<UserTable>();
if (userTable != null)
return userTable;
return null;
}
public static bool Authenticate(String userID, String password)
{
int userId = 0;
int.TryParse(userID, out userId);
var context = new ShipmentEntities3();
UserTable user = (from u in context.UserTables
where u.UserID == userId && u.Password == password
select u).FirstOrDefault();
//foreach (UserTable user in userList)
//{
// if (user.UserID.Equals(userId) && user.Password.Equals(password))
// return true;
//}
if (user != null)
{
return true;
}
return false;
}
public static bool InsertUser(String userID, String password, String country, String gender)
{
try
{
var context = new ShipmentEntities3();
UserTable user1 = new UserTable();
user1.UserID = Int32.Parse(userID);
user1.Password = password;
user1.Country = country;
user1.Gender = gender;
context.UserTables.Add(user1);
context.SaveChanges();
context.Dispose();
return true;
}
catch (Exception e)
{
return false;
}
}
public static UserTable FindUser(int userid)
{
var context = new ShipmentEntities3();
/* List<UserTable> userList = context.UserTables.ToList();
foreach (UserTable user in userList)
{
if (user.UserID.Equals(userID))
return user;
}*/
var query =(from user in context.UserTables
where userid==user.UserID
select user);
foreach (UserTable user in query)
{
if (user!= null)
return user;
}
return null;
}
public static bool DeleteUser(String userId)
{
var context = new ShipmentEntities3();
var query = from user in context.UserTables
where user.UserID.ToString() == userId
select user;
if (query != null)
{
try
{
context.UserTables.Remove((UserTable)query);
context.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
return false;
}
public static bool UpdateUser(UserTable userTable)
{
var context = new ShipmentEntities3();
var query = from user in context.UserTables
where user.UserID == userTable.UserID
select user;
foreach (UserTable user in query)
{
user.Password = userTable.Password;
user.Country = userTable.Country;
user.Gender = userTable.Gender;
}
try
{
context.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}