protected void Page_Load(object sender, EventArgs e)
{
Helpdesk.Utilitaire.Databases.Scripts.CheckStatut(msgboxpanel);
try
{
int id = 0;
if (System.Web.HttpContext.Current.Request.Cookies["userInfo"]["ID"] != null)
{
id = Int32.Parse(System.Web.HttpContext.Current.Request.Cookies["userInfo"]["ID"]);
}
using (Helpdesk.Entities.Agences.AgenceEntities ag = new Helpdesk.Entities.Agences.AgenceEntities())
{
var req = from value in ag.Historique_Login where value.ID_User == id select value;
var res = req.ToList();
titreEnv[0] = "Host Name : ";
titreEnv[1] = "@IP : ";
titreEnv[2] = "Date : ";
titreEnv[3] = "Time : ";
int nl = res.Count;
valuesEnv = new String[nl, 4];
int ligne = 0;
int colomne = 0;
foreach (Helpdesk.Entities.Agences.Historique_Login histlo in res)
{
valuesEnv[ligne, colomne] = histlo.Hostname;
valuesEnv[ligne, colomne + 1] = histlo.IPAdresse;
valuesEnv[ligne, colomne + 2] = histlo.Date.Value.Date.ToShortDateString();
valuesEnv[ligne, colomne + 3] = histlo.Time.ToString();
ligne++;
}
GetUserInfo();
}
}
catch (Exception x) { Helpdesk.Utilitaire.Utilites.MSG(msgboxpanel, x.Message, "Erreur"); }
}
public static void SendForgotmail(HtmlContainerControl div, String email)
{
using (Helpdesk.Entities.Agences.AgenceEntities db = new Helpdesk.Entities.Agences.AgenceEntities())
{
var req = from value in db.Responsables where (value.Email == email) select value;
var r = req.FirstOrDefault();
if (r != null)
{
SendMailMessage("*****@*****.**", email, "", "", "Your password Request", "Username : "******" \n Password : "******"password sent to your email adress", "Successful");
}
else
{
Utilites.MSG(div, "email not registred in database", "Invalid Email");
}
}
}
public static void Dashboard(HtmlContainerControl div)
{
try
{
using (Helpdesk.Entities.Agences.AgenceEntities dbses = new Helpdesk.Entities.Agences.AgenceEntities())
{
if (System.Web.HttpContext.Current.Request.Cookies["userInfo"] != null)
{
Utilites.redirect("Dashboard.aspx");
}
else
{
}
}
}
catch (System.Data.SqlClient.SqlException sql) { Utilites.MSG(div, sql.Message, sql.Errors.ToString()); }
}
public static void LoginScript(HtmlContainerControl div, String username, String password)
{
try
{
using (Helpdesk.Entities.Agences.AgenceEntities db = new Helpdesk.Entities.Agences.AgenceEntities())
{
String encryptedpass = Utilitaire.Encryption.AESEncryption.Encrypt(password);
var req = from valeur in db.Responsables where (valeur.Username == username && valeur.Password == encryptedpass && (valeur.Niveau == 1 || valeur.Niveau == 2) && valeur.Role == 1) select valeur;
var r = req.FirstOrDefault();
if (r != null)
{
Utilites.MSG(div, "Login Successfull", "Successful");
HttpCookie userck = new HttpCookie("userInfo");
userck.Values["ID"] = r.ID.ToString();
userck.Values["Password"] = r.Password;
userck.Values["Username"] = r.Username;
userck.Values["Nom"] = r.Nom;
userck.Values["Email"] = r.Email;
userck.Values["Prenom"] = r.Prenom;
userck.Values["Level"] = r.Niveau.ToString();
userck.Expires = DateTime.Now.AddDays(30);
System.Web.HttpContext.Current.Response.Cookies.Add(userck);
Helpdesk.Entities.Agences.Historique_Login hislog = new Entities.Agences.Historique_Login()
{
ID_User = r.ID, Time = DateTime.Now.TimeOfDay, Date = DateTime.Now.Date, Hostname = Helpdesk.Utilitaire.Reseau.Network.GetHostname(), IPAdresse = Helpdesk.Utilitaire.Reseau.Network.GetIpLocale()
};
db.AddToHistorique_Login(hislog);
db.SaveChanges();
Utilites.redirect("Dashboard.aspx");
}
else
{
Utilites.MSG(div, "Your login was not found in database", "Invalid Login");
}
}
}
catch (System.Data.SqlClient.SqlException sql) { Utilites.MSG(div, sql.Message, sql.Errors.ToString()); }
}
//To use in Responsable.aspx
public static void LoginStatut(HtmlContainerControl div, System.Web.UI.WebControls.Label LoginName)
{
if (System.Web.HttpContext.Current.Request.Cookies["userInfo"] != null)
{
int ID = Int32.Parse(System.Web.HttpContext.Current.Request.Cookies["userInfo"]["ID"]);
using (Helpdesk.Entities.Agences.AgenceEntities db = new Helpdesk.Entities.Agences.AgenceEntities())
{
var req = from value in db.Responsables where (value.ID == ID) select value;
var r = req.FirstOrDefault();
if (r != null)
{
HttpCookie userck = new HttpCookie("userInfo");
userck.Values["ID"] = r.ID.ToString();
userck.Values["Password"] = r.Password;
userck.Values["Username"] = r.Username;
userck.Values["Nom"] = r.Nom;
userck.Values["Email"] = r.Email;
userck.Values["Prenom"] = r.Prenom;
userck.Values["Level"] = r.Niveau.ToString();
userck.Expires = System.Web.HttpContext.Current.Request.Cookies["userInfo"].Expires;
System.Web.HttpContext.Current.Response.Cookies.Add(userck);
LoginName.Text = r.Nom + " " + r.Prenom;
}
else
{
HttpCookie userck = new HttpCookie("userInfo");
userck.Expires = DateTime.Now.AddDays(-30);
System.Web.HttpContext.Current.Response.Cookies.Add(userck);
Utilites.redirect("Account/login.aspx");
}
}
}
else
{
Utilites.redirect("Account/login.aspx");
}
}