public static string Create_Personel(string last_name, string first_name, string role, string pass, DateTime dt_exp)
{
using (DataClasses1DataContext conn = new DataClasses1DataContext())
{
string user_name = Generate_User_Name(last_name, first_name);
while (true)
{
var zap = (from p in conn.Personel where p.uname == user_name select p);
if (role != "man" & role != "wor" & role != "adm")//poprawnosc roli
{
return("Coś poszło nie tak, popraw role");
}
else if (zap.Any())//unikatowy login bedzie sprawdzac aż wygeneruje unikatowy login
{
user_name = Generate_User_Name(last_name, first_name);
}
else
{
break;
}
}
{
Personel new_per = new Personel
{
lname = last_name,
fname = first_name,
uname = user_name,
password = LoginSection.MD5Hash(pass),
role = role
};
if (dt_exp != DateTime.ParseExact("01.01.2000", "dd.MM.yyyy", null) && dt_exp < DateTime.MaxValue && dt_exp > DateTime.MinValue)
{
new_per.dt_exp = dt_exp;
}
conn.Personel.InsertOnSubmit(new_per);
conn.SubmitChanges();
return("Pomyslnie dodano do BD: " + user_name);
}
}
}
public static void Modify_Personel(string user_name, string last_name, string first_name, string role, string pass, DateTime dt_exp)
{
using (DataClasses1DataContext conn = new DataClasses1DataContext())
{
Personel up_per = conn.Personel.SingleOrDefault(x => x.uname == user_name);
up_per.lname = last_name;
up_per.fname = first_name;
// up_per.uname = user_name_up;
up_per.role = role;
if (pass != "nowe haslo")
{
up_per.password = LoginSection.MD5Hash(pass);
}
if (dt_exp != DateTime.ParseExact("01.01.2000", "dd.MM.yyyy", null) && dt_exp < DateTime.MaxValue && dt_exp > DateTime.MinValue)
{
up_per.dt_exp = dt_exp;
}
conn.SubmitChanges();
}
}