public IActionResult Get([FromBody] SignIn signIn)
{
var loginAccess = new LoginAccess(_config);
var token = loginAccess.GenerateJSONWebToken(signIn);
return(string.IsNullOrEmpty(token)? (IActionResult)Unauthorized(): Ok(new { jwt = token }));
}
public static LoginAccess LoadLoginAccess()
{
try
{
if (!GestioneMySql.OpenConnection())
{
throw new Exception("Errore nell'apertura della connessione.");
}
LoginAccess loginAccess;
using (MySqlCommand cmd = new MySqlCommand("SELECT DT_LOGIN, KEY_LOG, USER_ID FROM LOGIN_ACCESS INNER JOIN LOGIN ON LOGIN.KEY_LOG = KEY_LOG_ACC ORDER BY DT_LOGIN DESC LIMIT 1", GestioneMySql.connection))
{
loginAccess = new LoginAccess();
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
loginAccess.USER_ID = dr.GetString("USER_ID");
loginAccess.DT_LOGIN = DateTime.ParseExact(dr.GetString("DT_LOGIN"), "yyyyMMddHHmmss", null, System.Globalization.DateTimeStyles.None);
loginAccess.KEY_LOG = dr.GetUInt16("KEY_LOG");
}
dr.Close();
}
GestioneMySql.CloseConnection();
return(loginAccess);
}
catch (Exception ex)
{
GestioneMySql.CloseConnection();
MessageBox.Show("Errore: " + ex.Message);
return(null);
}
}
//CRUD-LOGIN
private async Task LoginDataAsync()
{
await Task.Delay(0);
dbconn.conn.Open();
var query = $"SELECT * FROM Employee WHERE id = '{model.id}' AND password = '******'";
var cmd = new SqlCommand(query, dbconn.conn);
var dr = cmd.ExecuteReader();
if (dr.HasRows)
{
MainFormView main = new MainFormView();
LoginAccess login = new LoginAccess();
login.Hide();
main.Show();
while (dr.Read())
{
App.Uid = dr[0].ToString();
App.UserName = dr[1].ToString();
}
}
else
{
MessageBox.Show("DATA USER NOT FOUND", "WARNING");
}
}
public static List <LoginAccess> GetLoginAccessListByUser(User oUser)
{
List <LoginAccess> listLoginAccess = new List <LoginAccess>();
DBHelper Data = new DBHelper();
SqlDataReader dr = null;
Data.Command.CommandType = CommandType.StoredProcedure;
Data.Command.CommandText = "spLoginAccessListByUser";
Data.Command.Parameters.Add(new SqlParameter("@a_vcLoginID", oUser.ID));
try
{
dr = Data.ExecuteReader();
if (dr != null)
{
while (dr.Read())
{
LoginAccess oLoginAccess = new LoginAccess();
oLoginAccess.LoginID = Convert.ToString(dr["LoginID"]);
oLoginAccess.BCISSection = Convert.ToString(dr["BCISSection"]);
oLoginAccess.AccessType = Convert.ToString(dr["AccessType"]);
oLoginAccess.IsGranted = Convert.ToString(dr["Granted"]);
listLoginAccess.Add(oLoginAccess);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dr.Close();
}
return(listLoginAccess);
}
public async Task <AuthResponse> Login(LoginAccess loginAccess)
{
var user = await _context.Usuarios.FirstOrDefaultAsync(x => x.Correo == loginAccess.Email);
if (user is null)
{
throw new KeyNotFoundException("Correo o contraseña es incorrecta");
}
using var hmac = new HMACSHA512(user.ContraseñaSalt);
var computedHash = hmac.ComputeHash(Encoding.UTF8.GetBytes(loginAccess.Password));
for (int i = 0; i < computedHash.Length; i++)
{
if (computedHash[i] != user.ContraseñaHash[i])
{
throw new KeyNotFoundException("Correo o contraseña es incorrecta");
}
}
var token = CreateToken(user.Nombre);
var userResponse = _mapper.Map <AuthResponse>(user);
userResponse.Token = token;
return(userResponse);
}
public IHttpActionResult LoginCliente(ClienteRequest cli)
{
ClienteResponse objClienteRS = new ClienteResponse();
LoginAccess objLogin = new LoginAccess();
var lstCliente = objLogin.LeerCliente(cli.EmailCliente, cli.PasswordCliente);
if (lstCliente.Count() > 0)
{
objClienteRS.LoginSuccess = true;
objClienteRS.CodCliente = lstCliente.FirstOrDefault().CodCliente;
objClienteRS.EmailCliente = lstCliente.FirstOrDefault().EmailCliente.Trim();
objClienteRS.NomCliente = lstCliente.FirstOrDefault().NomCliente;
objClienteRS.ApePaterno = lstCliente.FirstOrDefault().ApePaterno;
objClienteRS.ApeMaterno = lstCliente.FirstOrDefault().ApeMaterno;
objClienteRS.TipoIdioma = lstCliente.FirstOrDefault().TipoIdioma;
}
else
{
objClienteRS.LoginSuccess = false;
var message = new HttpResponseMessage(HttpStatusCode.BadRequest)
{
Content = new StringContent("No se encontro el cliente.")
};
throw new HttpResponseException(message);
}
return(Ok(objClienteRS));
}
public IHttpActionResult GetPropuestaViaje(PropuestaRequest Pro)
{
LPropuesta objPropuesta = new LPropuesta();
LoginAccess objPlantilla = new LoginAccess();
LItinerario objItinerario = new LItinerario();
ItinerarioResponse objTourResponse = new ItinerarioResponse();
var lstPropuesta = objPropuesta.LeerPropuestaViaje(Convert.ToInt32(Pro.CodCliente));
var lstBanner = objPlantilla.LeeImage(Int32.Parse(lstPropuesta.FirstOrDefault().NroPedido), Int32.Parse(lstPropuesta.FirstOrDefault().NroPropuesta), Int32.Parse(lstPropuesta.FirstOrDefault().NroVersion));
var lstItinerario = objItinerario.LeerItinerarioViaje(lstPropuesta.FirstOrDefault().NroPedido, lstPropuesta.FirstOrDefault().NroPropuesta, lstPropuesta.FirstOrDefault().NroVersion);
if (lstPropuesta.Count() > 0)
{
objTourResponse.Main = lstPropuesta.ToList();
objTourResponse.Banner = lstBanner.ToList();
objTourResponse.Itinerario = lstItinerario.ToList();
return(Ok(objTourResponse));
}
else
{
var message = new HttpResponseMessage(HttpStatusCode.BadRequest)
{
Content = new StringContent("No se encontro la Propuesta.")
};
throw new HttpResponseException(message);
}
//var json = new JavaScriptSerializer().Serialize(objTourResponse);
//string output = JsonConvert.SerializeObject(objTourResponse);
//string json = JsonConvert.SerializeObject(objTourResponse, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore });
}
public IHttpActionResult GetAcceso(AccesoRequest acc)
{
string Mensaje;
ClienteResponse objClienteRS = new ClienteResponse();
LoginAccess objAcceso = new LoginAccess();
var lstCliente = objAcceso.LeerCorreo(acc.EmailCliente);
if (lstCliente.Count() > 0)
{
objClienteRS.ClaveCliente = lstCliente.FirstOrDefault().ClaveCliente.Trim();
acc.Cuerpo = acc.Cuerpo + " " + objClienteRS.ClaveCliente;
EnviarCorreoSendGrid(acc.NombreEmisor, acc.EmailEmisor, acc.EmailCliente, acc.Asunto, acc.Cuerpo);
Mensaje = "OK, Se envio el Correo Satisfactoriamente";
return(Ok(Mensaje));
}
else
{
objClienteRS.LoginSuccess = false;
var message = new HttpResponseMessage(HttpStatusCode.BadRequest)
{
Content = new StringContent("No se encontro El Correo en la Base de Datos... Verifique por favor")
};
throw new HttpResponseException(message);
}
}
public IHttpActionResult GetURL(ClienteRequest cli)
{
string URL = Data.StrUrl;
ClienteResponse objClienteRS = new ClienteResponse();
LoginAccess objLogin = new LoginAccess();
var lstCliente = objLogin.LeeIDCliente(Int32.Parse(cli.CodigoCliente));
if (lstCliente.Count() > 0)
{
objClienteRS.IDCliente = lstCliente.FirstOrDefault().IDCliente;
URL = URL + "/" + objClienteRS.IDCliente;
}
else
{
var message = new HttpResponseMessage(HttpStatusCode.BadRequest)
{
Content = new StringContent("No se encontro el IDcliente.")
};
throw new HttpResponseException(message);
}
return(Ok(URL));
}
private void btnLogin_Click(object sender, EventArgs e)
{
LoginAccess lg = new LoginAccess();
if (lg.getLogin(txtUserName.Text, txtPassword.Text))
{
this.Close();
}
}
public ActionResult EmpLogin(UserLogin user)
{
var login = new LoginAccess();
int userId = login.CheckEmployeeLogin(user.userName, user.password);
if (userId > 0)
{
Session["employeeId"] = userId;
return(RedirectToAction("SignUp", "SetupSignUp"));
}
TempData["lbl"] = "Incorrect Username & Password combination. Please confirm entry and resubmit.";
return(RedirectToAction("EmpLogin", "Login"));
}
public ActionResult EmployeeLogin(UserLogin user)
{
var login = new LoginAccess();
int userId = login.CheckEmployeeLogin(user.userName, user.password);
if (userId > 0)
{
Session["employeeId"] = userId;
return(RedirectToAction("EmployeeDetail", "EmployeeDashBoard"));
}
else
{
return(RedirectToAction("EmployeeLogin", "Login", new { lbl = "Incorrect Username & Password combination. Please confirm entry and resubmit." }));
}
}
private async Task ReadDataAsync()
{
await Task.Delay(0);
dbconn.conn.Open();
var query = $"SELECT * FROM Member";
var cmd = new SqlCommand(query, dbconn.conn);
var dr = cmd.ExecuteReader();
if (dr.HasRows)
{
MainFormView main = new MainFormView();
LoginAccess login = new LoginAccess();
login.Hide();
main.Show();
while (dr.Read())
{
while (dr.Read())
{
collection.Add(new Member
{
id = dr[0].ToString(),
membership_id = dr[1].ToString(),
name = dr[2].ToString(),
email = dr[3].ToString(),
phone_number = dr[4].ToString(),
address = dr[5].ToString(),
date_of_birth = dr[6].ToString(),
gender = dr[7].ToString(),
created_at = dr[8].ToString(),
last_updated_at = dr[9].ToString(),
deleted_at = dr[10].ToString(),
});
}
}
}
else
{
MessageBox.Show("DATA USER NOT FOUND", "WARNING");
}
dbconn.conn.Close();
}
public IHttpActionResult GetImageTour(PlantillaTourRequest Pla)
{
PlantillaTourResponse objPlantillaTour = new PlantillaTourResponse();
LoginAccess objPlantilla = new LoginAccess();
var lstImagenTour = objPlantilla.LeeImageTour(Int32.Parse(Pla.NroPedido), Int32.Parse(Pla.NroPropuesta), Int32.Parse(Pla.NroVersion));
if (lstImagenTour.Count() > 0)
{
return(Ok(lstImagenTour.ToList()));
}
else
{
var message = new HttpResponseMessage(HttpStatusCode.BadRequest)
{
Content = new StringContent("No se encontro la Plantilla para el Tour.")
};
throw new HttpResponseException(message);
}
}
public ActionResult UserLogin(UserLogin user)
{
try
{
//string ip = Request.UserHostAddress;
DataSet dsUser = new DataSet();
var login = new LoginAccess();
var step = new StepAccess();
User userData = new User();
userData.UserName = user.userName;
//pass user name to database and get user details
dsUser = login.CheckUserLogin(userData);
if (dsUser.Tables[0].Rows.Count > 0)
{
userData.UserId = int.Parse(dsUser.Tables[0].Rows[0]["user_id"].ToString());
userData.UserName = dsUser.Tables[0].Rows[0]["user_name"].ToString();
userData.Password = dsUser.Tables[0].Rows[0]["password"].ToString();
userData.RoleId = int.Parse(dsUser.Tables[0].Rows[0]["role_id"].ToString());
if (userData.RoleId == 4)
{
DataSet dsDelearCompany = new DataSet();
dsDelearCompany = login.GetDealerUserCompanyBranch(userData.UserId);
if (dsDelearCompany.Tables[0].Rows[0]["company_id"].ToString() != "")
{
userData.Company_Id = int.Parse(dsDelearCompany.Tables[0].Rows[0]["company_id"].ToString());
userData.CompanyName = dsDelearCompany.Tables[0].Rows[0]["company_name"].ToString();
}
if (dsDelearCompany.Tables[0].Rows[0]["branch_id"].ToString() != "")
{
userData.BranchId = int.Parse(dsDelearCompany.Tables[0].Rows[0]["branch_id"].ToString());
userData.BranchName = dsDelearCompany.Tables[0].Rows[0]["branch_name"].ToString();
}
}
else
{
userData.BranchId = int.Parse(dsUser.Tables[0].Rows[0]["branch_id"].ToString());
userData.BranchName = dsUser.Tables[0].Rows[0]["branch_name"].ToString();
if (dsUser.Tables[0].Rows[0]["company_id"].ToString() != "")
{
userData.Company_Id = int.Parse(dsUser.Tables[0].Rows[0]["company_id"].ToString());
userData.CompanyType = int.Parse(dsUser.Tables[0].Rows[0]["company_type"].ToString());
userData.CompanyCode = dsUser.Tables[0].Rows[0]["company_code"].ToString();
}
else
{
userData.Company_Id = 0;
}
userData.CompanyName = dsUser.Tables[0].Rows[0]["company_name"].ToString();
}
userData.step_status = int.Parse(dsUser.Tables[0].Rows[0]["step_status"].ToString());
//To compair Database password and user enter password
string passwordFromDB = userData.Password;
char[] delimiter = { ':' };
string[] split = passwordFromDB.Split(delimiter);
var checkCharHave = passwordFromDB.ToLowerInvariant().Contains(':');
if (passwordFromDB == null || (checkCharHave == false))
{
Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" was unable to login, Entered password did not match", DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
return(RedirectToAction("UserLogin", "Login", new { lbl = "Incorrect Username & Password combination. Please confirm entry and resubmit." }));
}
string passwordEncripted = PasswordEncryption.encryptPassword(user.password, split[1]);
if (string.Compare(passwordEncripted, passwordFromDB) == 0)
{
//user object pass to session
Session["AuthenticatedUser"] = userData;
// Does not complete atleast one cycle
if (userData.step_status == 0)
{
if (userData.RoleId == 3)
{
Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" was unable to login", DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
return(RedirectToAction("UserLogin", "Login", new { lbl = "Company setup process is on going please contact admin." }));
}
else
{
Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" has logged successfully", DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
if (userData.Company_Id == 0)
{
Session["companyStep"] = 1;
return(RedirectToAction("Index", "SetupProcess"));
}
else if (userData.Company_Id > 0)
{
if (userData.RoleId == 1)
{
DataSet dsStepNo = new DataSet();
dsStepNo = step.checkSuperAdminLoginWhileCompanySetup(userData);
if (dsStepNo.Tables[0].Rows.Count > 0)
{
Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString());
return(RedirectToAction("Index", "SetupProcess"));
}
else
{
LoanSetupStep loanStep = new LoanSetupStep();
DataSet dsLoanStepNo = new DataSet();
dsLoanStepNo = step.checkUserLoginWhileLoanSetup(userData);
if (dsLoanStepNo.Tables[0].Rows.Count > 0)
{
loanStep.CompanyId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["company_id"].ToString());
loanStep.BranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["branch_id"].ToString());
loanStep.stepId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["step_number"].ToString());
loanStep.nonRegisteredBranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["non_registered_branch_id"].ToString());
if (dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString() != "")
{
loanStep.loanId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString());
}
else
{
loanStep.loanId = 0;
}
Session["loanStep"] = loanStep;
if (userData.RoleId == 1)
{
return(RedirectToAction("Step" + (loanStep.stepId + 5), "SetupProcess"));
}
}
}
}
else
{
//if step table has record pass(company id and branch id)
DataSet dsStepNo = new DataSet();
dsStepNo = step.checkUserLoginWhileCompanySetup(userData);
if (dsStepNo.Tables[0].Rows.Count > 0)
{
Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString());
return(RedirectToAction("Index", "SetupProcess"));
}
else
{
//No Step recor in relavent Company and branch
LoanSetupStep loanStep = new LoanSetupStep();
DataSet dsLoanStepNo = new DataSet();
dsLoanStepNo = step.checkUserLoginWhileLoanSetup(userData);
if (dsLoanStepNo.Tables[0].Rows.Count > 0)
{
loanStep.CompanyId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["company_id"].ToString());
loanStep.BranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["branch_id"].ToString());
loanStep.stepId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["step_number"].ToString());
loanStep.nonRegisteredBranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["non_registered_branch_id"].ToString());
if (dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString() != "")
{
loanStep.loanId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString());
}
else
{
loanStep.loanId = 0;
}
Session["loanStep"] = loanStep;
return(RedirectToAction("Step" + (loanStep.stepId + 5), "SetupProcess"));
}
}
}
}
}
}
// Complete cycle and no start new cycle
else if (userData.step_status == 1 || userData.step_status == 2)
{
//delete just added unit if exists
UnitAccess ua = new UnitAccess();
ua.DeleteJustAddedUnits(userData.UserId);
//insert log
Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" has logged successfully", DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
return(RedirectToAction("UserDetails", "UserManagement"));
}
// atleast one cycle complete and Start new cycle
//else if (userData.step_status == 2)
//{
// //delete just added unit if exists
// UnitAccess ua = new UnitAccess();
// ua.DeleteJustAddedUnits(userData.UserId);
// //insert log
// Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" has logged successfully", DateTime.Now);
// int islog = (new LogAccess()).InsertLog(log);
// if (userData.RoleId == 1)
// {
// DataSet dsStepNo = new DataSet();
// dsStepNo = step.checkSuperAdminLoginWhileCompanySetup(userData);
// if (dsStepNo.Tables[0].Rows.Count > 0)
// {
// Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString());
// Session["isNotCompleteStep"] = 1;
// //return RedirectToAction("Index", "SetupProcess");
// return RedirectToAction("UserLogin", "Login");
// }
// else
// {
// LoanSetupStep loanStep = new LoanSetupStep();
// DataSet dsLoanStepNo = new DataSet();
// dsLoanStepNo = step.checkUserLoginWhileLoanSetup(userData);
// if (dsLoanStepNo.Tables[0].Rows.Count > 0)
// {
// loanStep.CompanyId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["company_id"].ToString());
// loanStep.BranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["branch_id"].ToString());
// loanStep.stepId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["step_number"].ToString());
// loanStep.nonRegisteredBranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["non_registered_branch_id"].ToString());
// if (dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString() != "")
// {
// loanStep.loanId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString());
// }
// else
// {
// loanStep.loanId = 0;
// }
// Session["isNotCompleteStep"] = 1;
// Session["loanStep"] = loanStep;
// if (userData.RoleId == 1)
// {
// //return RedirectToAction("Step" + (loanStep.stepId + 5), "SetupProcess");
// return RedirectToAction("UserLogin", "Login");
// }
// }
// }
// }
// else
// {
// //if step table has record pass(company id and branch id)
// DataSet dsStepNo = new DataSet();
// dsStepNo = step.checkUserLoginWhileCompanySetup(userData);
// if (dsStepNo.Tables[0].Rows.Count > 0)
// {
// Session["isNotCompleteStep"] = 1;
// Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString());
// return RedirectToAction("UserLogin", "Login");
// }
// else
// {
// //No Step recor in relavent Company and branch
// LoanSetupStep loanStep = new LoanSetupStep();
// DataSet dsLoanStepNo = new DataSet();
// dsLoanStepNo = step.checkUserLoginWhileLoanSetup(userData);
// if (dsLoanStepNo.Tables[0].Rows.Count > 0)
// {
// loanStep.CompanyId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["company_id"].ToString());
// loanStep.BranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["branch_id"].ToString());
// loanStep.stepId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["step_number"].ToString());
// loanStep.nonRegisteredBranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["non_registered_branch_id"].ToString());
// if (dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString() != "")
// {
// loanStep.loanId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString());
// }
// else
// {
// loanStep.loanId = 0;
// }
// Session["isNotCompleteStep"] = 1;
// Session["loanStep"] = loanStep;
// //return RedirectToAction("Step" + (loanStep.stepId + 5), "SetupProcess");
// return RedirectToAction("UserLogin", "Login");
// }
// //if SA stepstatus 2 and no records in loan setup and companysetup
// else
// {
// return RedirectToAction("UserDetails", "Usermanagement");
// }
// }
// }
//}
else
{
//insert log
Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" was unable to login", DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
return(RedirectToAction("UserLogin", "Login", new { lbl = "Company setup process is on going please contact admin." }));
}
// //check Company setup process
// //Check SuperAdmin
// //company ID null or 0 then redirect to step process 1
// if (userData.Company_Id == 0)
// {
// Session["companyStep"] = 1;
// return RedirectToAction("Index", "SetupProcess");
// }
// else if (userData.Company_Id > 0)
// {
// //check branch count more than one and
// if (userData.RoleId == 1)
// {
// //check branch count in view and step table row count
// //IF more than branch count and has step record ask question
// DataSet dsStepNo = new DataSet();
// dsStepNo = step.checkSuperAdminLoginWhileCompanySetup(userData);
// if (dsStepNo.Tables[0].Rows.Count > 0)
// {
// int bcount = 0;
// if (dsStepNo.Tables[0].Rows[0]["branchCount"].ToString() != "")
// {
// bcount = int.Parse(dsStepNo.Tables[0].Rows[0]["branchCount"].ToString());
// }
// int scount = 0;
// if (dsStepNo.Tables[0].Rows[0]["stepCount"].ToString() != "")
// {
// scount = int.Parse(dsStepNo.Tables[0].Rows[0]["stepCount"].ToString());
// }
// if (bcount <= scount)
// {
// Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString());
// return RedirectToAction("Index", "SetupProcess");
// }
// else
// {
// //message: Not complete Step, Do you want to complete it.
// Session["isNotCompleteStep"] = 1;
// Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString());
// return RedirectToAction("UserLogin", "Login");
// }
// }
// else
// {
// LoanSetupStep loanStep = new LoanSetupStep();
// DataSet dsLoanStepNo = new DataSet();
// dsLoanStepNo = step.checkUserLoginWhileLoanSetup(userData);
// if (dsLoanStepNo.Tables[0].Rows.Count > 0)
// {
// loanStep.CompanyId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["company_id"].ToString());
// loanStep.BranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["branch_id"].ToString());
// loanStep.stepId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["step_number"].ToString());
// loanStep.nonRegisteredBranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["non_registered_branch_id"].ToString());
// if (dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString() != "")
// {
// loanStep.loanId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString());
// }
// else
// {
// loanStep.loanId = 0;
// }
// Session["loanStep"] = loanStep;
// if (userData.RoleId == 1)
// {
// return RedirectToAction("Step" + (loanStep.stepId + 5), "SetupProcess");
// }
// }
// else
// {
// //Redirect to Super Admin dashboard
// return RedirectToAction("UserDetails", "UserManagement");
// }
// }
// }
// else
// {
// //if step table has record pass(company id and branch id)
// DataSet dsStepNo = new DataSet();
// dsStepNo = step.checkUserLoginWhileCompanySetup(userData);
// if (dsStepNo.Tables[0].Rows.Count > 0)
// {
// Session["companyStep"] = int.Parse(dsStepNo.Tables[0].Rows[0]["step_number"].ToString());
// if (userData.RoleId == 2)
// {
// return RedirectToAction("Index", "SetupProcess");
// }
// else
// {
// return RedirectToAction("UserLogin", "Login", new { lbl = "Company setup process is on going please contact admin." });
// }
// }
// else
// {
// //No Step recor in relavent Company and branch
// LoanSetupStep loanStep = new LoanSetupStep();
// DataSet dsLoanStepNo = new DataSet();
// dsLoanStepNo = step.checkUserLoginWhileLoanSetup(userData);
// if (dsLoanStepNo.Tables[0].Rows.Count > 0)
// {
// loanStep.CompanyId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["company_id"].ToString());
// loanStep.BranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["branch_id"].ToString());
// loanStep.stepId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["step_number"].ToString());
// loanStep.nonRegisteredBranchId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["non_registered_branch_id"].ToString());
// if (dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString() != "")
// {
// loanStep.loanId = int.Parse(dsLoanStepNo.Tables[0].Rows[0]["loan_id"].ToString());
// }
// else
// {
// loanStep.loanId = 0;
// }
// Session["loanStep"] = loanStep;
// if (userData.RoleId == 2)
// {
// //return RedirectToAction("Index", "SetupProcess");
// return RedirectToAction("Step" + (loanStep.stepId+5), "SetupProcess");
// }
// }
// else
// {
// if (userData.RoleId == 2)
// {
// //Redirect to Branch Admin dashboard
// return RedirectToAction("UserDetails", "UserManagement");
// }
// else
// {
// //Redirect to User dashboard
// return RedirectToAction("UserDetails", "UserManagement");
// }
// }
// }
// }
// }
//}
//else
//{
// //User Name Correct but user enter password does not match with database password value
// return RedirectToAction("UserLogin", "Login", new { lbl = "Incorrect Username or Password, please confirm and submit." });
//}
//insert log entry
}
else
{
//User Name Correct but user enter password does not match with database password value
Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" was unable to login, Entered password did not match ", DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
return(RedirectToAction("UserLogin", "Login", new { lbl = "Incorrect Username & Password combination. Please confirm entry and resubmit." }));
}
}
else
{
//Incorrect UserName
Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, 0, "User Login", "User : "******" was unable to login, Entered username did not exist ", DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
return(RedirectToAction("UserLogin", "Login", new { lbl = "Incorrect Username & Password combination. Please confirm entry and resubmit." }));
}
}
catch
{
return(RedirectToAction("UserLogin", "Login", new { lbl = "An error has occurred.Please try again later" }));
}
return(RedirectToAction("UserLogin", "Login"));
}
