public VM_Login()
{
_model = new M_Login();
_model.ProgressData.ProgressValue = 100;
_model.ProgressData.ProgressIndeterminate = true;
_model.ProgressData.ProgressVisibility = Visibility.Collapsed;
}
public V_Menu(M_Login mLogin)
{
InitializeComponent();
this.mLogin = mLogin;
cMenu.AbrirFormulario <V_PanelMenu>(pnlMenu);
if (!mLogin.Roll.Equals("Administrador"))
{
btnUsuario.Enabled = false;
btnRoll.Enabled = false;
}
}
public bool login(M_Login mLogin)
{
Con = base.conexion();
SQL = "spLogin";
try
{
Con.Open();
coman = new MySqlCommand(SQL, Con);
coman.CommandType = CommandType.StoredProcedure;
coman.Parameters.AddWithValue("@dn", mLogin.Dni);
mSDR = coman.ExecuteReader();
if (mSDR.Read())
{
if (mLogin.Password.Equals(mSDR[2].ToString()))
{
mLogin.Id = int.Parse(mSDR[0].ToString());
mLogin.Dni = mSDR[1].ToString();
mLogin.Nombre = mSDR[3].ToString();
mLogin.Apellidos = mSDR[4].ToString();
mLogin.Telefono = mSDR[5].ToString();
mLogin.CorreoElectronico = mSDR[6].ToString();
mLogin.FechaNacimiento = mSDR[7].ToString();
mLogin.Roll = mSDR[8].ToString();
return(true);
}
}
return(false);
}
catch (MySqlException ex)
{
Console.WriteLine("Error " + ex.Message.ToString());
return(false);
}
finally
{
try
{
Con.Close();
}
catch (MySqlException ex)
{
Console.WriteLine("Error " + ex.Message);
}
}
}
public M_Login getUserLogin(M_Login Usr)
{
try
{
using (DBLinqDataContext datacontext = new DBLinqDataContext())
{
datacontext.Connection.ConnectionString = Connection_;
M_Login usr = new M_Login();
string pass = Encrypt_Decrypt.Encrypt(Usr.Password_, Password);
System.Data.Linq.ISingleResult <_getUserloginResult> loggedUser = datacontext._getUserlogin(Usr.User_ID, pass);
foreach (_getUserloginResult result in loggedUser)
{
if (result.UserId.Equals(Usr.User_ID) && result.Password.Equals(pass))
{
usr.User_ID = result.UserId;
usr.UserGroup_ID = result.UserGroupID;
usr.Is_Active = result.IsActive;
// usr.Is_Vat = result.IsVat;
usr.PassowordExpiry_Date = result.PassowordExpiryDate.ToString();
usr.Person_Name = result.PersonName;
usr.Customer_ID = result.ParentCustomerId;
if (usr.Is_Active == "N")
{
return(null);
}
else
{
return(usr);
}
}
}
return(null);
}
}
catch (Exception ex)
{
// Console.WriteLine(ex.Message.ToString());
ErrorLog.LogError(ex);
return(null);
}
}
public ActionResult isLogin(F_Login formModel)
{
M_Login model = new M_Login();
if (formModel.requestLogin == "isLogin")
{
if (model.getLogin(formModel))
{
return(Json(SystemClass.returnResultJsonSuccess()));
}
else
{
return(Json(SystemClass.returnResultJsonFailure()));
}
}
else
{
return(Json(SystemClass.returnResultJsonFailure()));
}
}
public JsonResult Login(M_Login login)
{
string result = "Error";
var loggedU = objUser.getUserLogin(login);
if (loggedU != null)
{
_USession Session = new _USession();
Session.Customer_ID = loggedU.Customer_ID;
Session.User_Id = loggedU.User_ID;
Session.User_Group = loggedU.UserGroup_ID;
Session.Person_Name = loggedU.Person_Name;
Session.PFX_path = "~/Signature/DesmondM/W_M_S_L_Weerasinghe_NCE.pfx";
Session.SignatureIMG_Path = "~/Signature/DesmondM/Sachithra-Weerasinghe's_signature_in_high_res.png";
result = "Succes";
}
else
{
result = "Failed";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}