public static int InserToUser(string userName, string passWord)
{
using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(Atiran.Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
int result = 0;
try
{
Atiran.Connections.AtiranAccModel.User usr = new Atiran.Connections.AtiranAccModel.User()
{
UserName = userName,
UserPassWord = System.Text.Encoding.UTF8.GetBytes(passWord),
Active = true
};
context.Users.Add(usr);
context.SaveChanges();
context.AddUser(usr.UserID, Connections.AtiranAccModel.ConnectionInfo.DatabaseName.ToString());
result = usr.UserID;
return(result);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
return(result);
}
}
}
public static bool ChangePassword(int userID, string usrname, string password)
{
using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(Atiran.Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
try
{
User ss = context.Users.Where(i => i.UserID == userID).FirstOrDefault();
{
ss.UserPassWord = System.Text.Encoding.UTF8.GetBytes(password);
}
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.InnerException.ToString());
return(false);
}
}
}
public static bool EditUser(int UserID, string userName, string passWord)
{
using (var context = new Atiran.Connections.AtiranAccModel.AccModelEntities(Atiran.Connections.AtiranAccModel.ConnectionInfo.BuildConnectionString()))
{
bool result = false;
try
{
Atiran.Connections.AtiranAccModel.User usr = context.Users.Where(i => i.UserID == UserID).FirstOrDefault();
{
//usr.UserName = userName;
usr.UserPassWord = System.Text.Encoding.UTF8.GetBytes(passWord);
};
context.SaveChanges();
result = true;
return(result);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
return(result);
}
}
}