/// <summary> /// database connection for Registrion /// </summary> /// <param name="data"> store the Complete Employee information</param> /// <returns></returns> public async Task <bool> EmployeeRegister(EmployeeModel data) { try { SqlConnection connection = DatabaseConnection(); //password encrption string Password = EncryptedPassword.EncodePasswordToBase64(data.Password); //for store procedure and connection to database SqlCommand command = StoreProcedureConnection("spUserRegister", connection); command.Parameters.AddWithValue("@EmployeeName", data.EmployeeName); command.Parameters.AddWithValue("@Username", data.Username); command.Parameters.AddWithValue("@Password", Password); command.Parameters.AddWithValue("@Gender", data.Gender); command.Parameters.AddWithValue("@City", data.City); command.Parameters.AddWithValue("@EmailID", data.EmailID); command.Parameters.AddWithValue("@Designation", data.Designation); command.Parameters.AddWithValue("@WorkingExperience", data.WorkingExperience); connection.Open(); int Response = await command.ExecuteNonQueryAsync(); connection.Close(); if (Response != 0) { return(true); } else { return(false); } } catch (Exception e) { throw new Exception(e.Message); } }
public bool ParkingLogin(ParkingCL data) { try { SqlCommand command = StoreProcedureConnection("spParkingLogin", connection); string Password = EncryptedPassword.EncodePasswordToBase64(data.Password); command.Parameters.AddWithValue("@ParkingId", data.ParkingId); command.Parameters.AddWithValue("@Password", Password); connection.Open(); int Response = command.ExecuteNonQuery(); connection.Close(); if (Response != 0) { return(true); } else { return(false); } } catch (Exception e) { throw new Exception(e.Message); } }
/// <summary> /// database connection for Login /// </summary> /// <param name="data"> Login API</param> /// <returns></returns> public async Task <int> EmployeeLogin(Login data) { try { SqlConnection connection = DatabaseConnection(); //password encrption string Password = EncryptedPassword.EncodePasswordToBase64(data.Password); SqlCommand command = StoreProcedureConnection("splogin_pro", connection); command.Parameters.AddWithValue("@Username", data.Username); command.Parameters.AddWithValue("@Password", Password); command.Parameters.AddWithValue("@Designation", data.Designation); connection.Open(); SqlDataReader reader = await command.ExecuteReaderAsync(); int Status = 0; while (reader.Read()) { Status = reader.GetInt32(0); } connection.Close(); if (Status == 1) { return(1); } else { return(0); } } catch (Exception e) { throw new Exception(e.Message); } }
/// <summary> /// database connection for Registrion /// </summary> /// <param name="data"> store the Complete Employee information</param> /// <returns></returns> public async Task <bool> UserRegister(Usermodel data) { try { SqlConnection connection = DatabaseConnection(); //password encrption string Password = EncryptedPassword.EncodePasswordToBase64(data.Password); //for store procedure and connection to database SqlCommand command = StoreProcedureConnection("spParkingUserRegister", connection); command.Parameters.AddWithValue("@FirstName", data.FirstName); command.Parameters.AddWithValue("@LastName", data.LastName); command.Parameters.AddWithValue("@EmailID", data.EmailID); command.Parameters.AddWithValue("@Password", Password); command.Parameters.AddWithValue("@UserRole", data.UserRole); command.Parameters.AddWithValue("@CreateDate", data.CreateDate); connection.Open(); int Response = await command.ExecuteNonQueryAsync(); connection.Close(); if (Response != 0) { return(true); } else { return(false); } } catch (Exception e) { throw new Exception(e.Message); } }
/// <summary> /// Checking for valid user using MailID and Password /// </summary> /// <param name="Info"></param> /// <returns></returns> public bool LoginVerification(Login Info) { try { bool input = Enum.TryParse <Driver>(Info.DriverCategory, true, out Driver driver); if (input != true) { throw new Exception("Invalid Driver Category"); } string MailID = Info.MailID; string Password = EncryptedPassword.EncodePasswordToBase64(Info.Password); //Password Encrypted string DriverCategory = Info.DriverCategory; var Result = dBContext.Users.Where(u => u.MailID == MailID && u.Password == Password && u.DriverCategory == DriverCategory).FirstOrDefault(); if (Result != null) { return(true); } else { return(false); } } catch (Exception e) { throw new Exception(e.Message); } }
public UserDetails Registration(UserRegistration userRegistration) { UserDetails details = new UserDetails(); try { string connectoin = Configuration.GetConnectionString("MyConnection"); DateTime createdDate; createdDate = DateTime.Now; using (SqlConnection sqlConnection = new SqlConnection(connectoin)) { string Password = EncryptedPassword.EncodePasswordToBase64(userRegistration.Password); SqlCommand sqlCommand = new SqlCommand("SpAddUserDetails", sqlConnection); sqlCommand.CommandType = System.Data.CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@FirstName", userRegistration.FirstName); sqlCommand.Parameters.AddWithValue("@LastName", userRegistration.LastName); sqlCommand.Parameters.AddWithValue("@Email", userRegistration.Email); sqlCommand.Parameters.AddWithValue("@Password", Password); sqlCommand.Parameters.AddWithValue("@Address", userRegistration.Address); sqlCommand.Parameters.AddWithValue("@City", userRegistration.City); sqlCommand.Parameters.AddWithValue("@PhoneNumber", userRegistration.PhoneNumber); sqlCommand.Parameters.AddWithValue("@CreatedDate", createdDate); sqlConnection.Open(); SqlDataReader reader = sqlCommand.ExecuteReader(); Console.WriteLine("output=", reader); if (reader.HasRows) { while (reader.Read()) { details.UserId = Convert.ToInt32(reader["UserId"].ToString()); details.FirstName = reader["FirstName"].ToString(); details.LastName = reader["LastName"].ToString(); details.UserRole = reader["UserRole"].ToString(); details.Email = reader["Email"].ToString(); details.Address = reader["Address"].ToString(); details.City = reader["City"].ToString(); details.PhoneNumber = reader["PhoneNumber"].ToString(); } } else { Console.WriteLine("No Data Found"); } sqlConnection.Close(); } return(details); } catch (Exception ex) { throw new Exception(ex.Message); } }
//Method for User login public UserRegistration login(UserLogin user) { UserRegistration userLogin = new UserRegistration(); try { //Connection string declared string connect = Configuration.GetConnectionString("MyConnection"); //Password encrypted string Password = EncryptedPassword.EncodePasswordToBase64(user.Password); using (SqlConnection Connection = new SqlConnection(connect)) { SqlCommand sqlCommand = new SqlCommand("UserLogin", Connection); sqlCommand.CommandType = System.Data.CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@Email", user.Email); sqlCommand.Parameters.AddWithValue("@Password", Password); //connection open Connection.Open(); //read data form the database SqlDataReader reader = sqlCommand.ExecuteReader(); //While Loop For Reading status result from SqlDataReader. while (reader.Read()) { userLogin.UserId = Convert.ToInt32(reader["UserId"].ToString()); userLogin.FirstName = reader["FirstName"].ToString(); userLogin.LastName = reader["LastName"].ToString(); userLogin.Gender = reader["Gender"].ToString(); userLogin.Email = reader["Email"].ToString(); userLogin.Address = reader["Address"].ToString(); userLogin.Designation = reader["Designation"].ToString(); userLogin.Salary = Convert.ToDouble(reader["Salary"].ToString()); userLogin.MobileNumber = reader["MobileNumber"].ToString(); userLogin.Password = reader["Password"].ToString(); } //connection close Connection.Close(); } } catch (Exception ex) { throw new Exception(ex.Message); } return(userLogin); }
//Method to register user in the dataabase public UserDetails Registration(UserRegistration user) { UserDetails details = new UserDetails(); try { //Connection string declared string connect = Configuration.GetConnectionString("MyConnection"); //password encrypted string Password = EncryptedPassword.EncodePasswordToBase64(user.Password); DateTime createdDate; createdDate = DateTime.Now; using (SqlConnection Connection = new SqlConnection(connect)) { SqlCommand sqlCommand = new SqlCommand("UserRegistration", Connection); sqlCommand.CommandType = System.Data.CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@FirstName", user.FirstName); sqlCommand.Parameters.AddWithValue("@LastName", user.LastName); sqlCommand.Parameters.AddWithValue("@Email", user.Email); sqlCommand.Parameters.AddWithValue("@Password", Password); sqlCommand.Parameters.AddWithValue("@PhoneNumber", user.PhoneNumber); //connection open Connection.Open(); // Read data form database SqlDataReader reader = sqlCommand.ExecuteReader(); //While Loop For Reading status result from SqlDataReader. while (reader.Read()) { details.UserId = Convert.ToInt32(reader["id"].ToString()); details.FirstName = reader["FirstName"].ToString(); details.LastName = reader["LastName"].ToString(); details.Email = reader["Email"].ToString(); details.PhoneNumber = reader["PhoneNumber"].ToString(); } //connection close Connection.Close(); } return(details); } catch (Exception ex) { throw new Exception(ex.Message); } }
public int UpdateEmployee(ParkingCL data) { try { SqlCommand com = StoreProcedureConnection("spUpdateParkingDetails", connection); string Password = EncryptedPassword.EncodePasswordToBase64(data.Password); com.Parameters.AddWithValue("@ParkingId", data.ParkingId); com.Parameters.AddWithValue("VehicalNo", data.VehicalNo); com.Parameters.AddWithValue("VehicalBrand", data.VehicalBrand); com.Parameters.AddWithValue("VehicalColor", data.VehicalColor); if (data.ExitTime > data.EntryTime && data.ParkingType != "Own") { data.ChargePerHr = CHARGE_PER_HR; } com.Parameters.AddWithValue("ChargePerHr", data.ChargePerHr); com.Parameters.AddWithValue("EntryTime", data.EntryTime); com.Parameters.AddWithValue("DriverCategory", data.DriverCategory); com.Parameters.AddWithValue("ParkingType", data.ParkingType); if (data.ExitTime < data.EntryTime) { data.ExitTime = data.EntryTime; } com.Parameters.AddWithValue("ExitTime", data.ExitTime); com.Parameters.AddWithValue("@Password", Password); connection.Open(); int Response = com.ExecuteNonQuery(); connection.Close(); if (Response == 0) { return(0); } else { return(1); } } catch (Exception e) { throw new Exception(e.Message); } finally { connection.Close(); } }
public bool ParkingRegisterDatails(ParkingUser Info) { try { string Encrypted = Info.Password; Info.Password = EncryptedPassword.EncodePasswordToBase64(Encrypted); var Result = Parking.ParkingRegisterDatails(Info); if (!Result.Equals(null)) { return(true); } else { return(false); } } catch (Exception e) { throw new Exception(e.Message); } }
/// <summary> /// Add Information to Register the user /// Return the status true ro false /// </summary> /// <param name="Info"></param> /// <returns></returns> public bool AddUser(Users Info) { try { string Encrypted = Info.Password; Info.Password = EncryptedPassword.EncodePasswordToBase64(Encrypted); //Password get Encrypted var Result = User.AddUser(Info); if (!Result.Equals(null)) { return(true); } else { return(false); } } catch (Exception e) { throw new Exception(e.Message); } }
//method to register new user public UserRegistration register(UserRegistration user) { try { string Encrypted = user.Password; user.Password = EncryptedPassword.EncodePasswordToBase64(Encrypted); var Result = parkingLot.AddUser(user); if (!Result.Equals(null)) { return(user); } else { throw new Exception("Not found"); } } catch (Exception exception) { throw new Exception(exception.Message); } }
//Method to update user record by id public object UpdateUserRecord(int UserId, UserRegistration details) { try { //variables declared string Email = details.Email; string Password = EncryptedPassword.EncodePasswordToBase64(details.Password); //validating Email and Id var Validation = dbContext.UserDetails.Where(u => u.Email == Email && u.ID != UserId).FirstOrDefault(); if (Validation != null) { throw new Exception("User Already Exist"); } //validating and updating user id records in the database var record = (from x in dbContext.UserDetails where x.ID == UserId select x).First(); if (record != null) { record.FirstName = details.FirstName; record.LastName = details.LastName; record.Email = details.Email; record.Password = Password; record.UserType = details.UserType; record.ModifiedDate = DateTime.Now; dbContext.SaveChanges(); return(record); } else { return(false); } } catch (Exception exception) { throw new Exception(exception.Message); } }
/// <summary> /// database connection for Login /// </summary> /// <param name="user"> Login API</param> /// <returns></returns> public UserDetails UserLogin(Login user) { UserDetails details = new UserDetails(); try { SqlConnection connection = DatabaseConnection(); //password encrption string Password = EncryptedPassword.EncodePasswordToBase64(user.Password); SqlCommand command = StoreProcedureConnection("spLogin", connection); command.Parameters.AddWithValue("@EmailID", user.EmailID); command.Parameters.AddWithValue("@Password", Password); connection.Open(); //read data form the database SqlDataReader reader = command.ExecuteReader(); //While Loop For Reading status result from SqlDataReader. while (reader.Read()) { details.ID = Convert.ToInt32(reader["ID"].ToString()); details.FirstName = reader["FirstName"].ToString(); details.LastName = reader["LastName"].ToString(); details.UserRole = reader["UserRole"].ToString(); details.EmailID = reader["EmailID"].ToString(); } //connection close connection.Close(); return(details); } catch (Exception ex) { throw new Exception(ex.Message); } }
public UserDetails Login(UserLogin user) { UserDetails details = new UserDetails(); try { string connect = Configuration.GetConnectionString("MyConnection"); //Password encrypted string Password = EncryptedPassword.EncodePasswordToBase64(user.Password); using (SqlConnection Connection = new SqlConnection(connect)) { SqlCommand sqlCommand = new SqlCommand("SpAddUserLogin", Connection); sqlCommand.CommandType = System.Data.CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@Email", user.Email); sqlCommand.Parameters.AddWithValue("@Password", Password); Connection.Open(); SqlDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { details.UserId = Convert.ToInt32(reader["UserId"].ToString()); details.FirstName = reader["FirstName"].ToString(); details.LastName = reader["LastName"].ToString(); details.UserRole = reader["UserRole"].ToString(); details.Email = reader["Email"].ToString(); details.Address = reader["Address"].ToString(); details.City = reader["City"].ToString(); details.PhoneNumber = reader["PhoneNumber"].ToString(); } Connection.Close(); } return(details); } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool ParkingLoginDatails(Login Info) { try { string MailID = Info.MailID; string Password = EncryptedPassword.EncodePasswordToBase64(Info.Password); var Result = dBContext.Users.Where(u => u.MailID == MailID && u.Password == Password).FirstOrDefault(); if (Result != null) { return(true); } else { return(false); } } catch (Exception e) { throw new Exception(e.Message); } }
public object UpdateUserRecord(Users Info, int ID) { try { string MailID = Info.MailID; string Password = EncryptedPassword.EncodePasswordToBase64(Info.Password); var Validation = dBContext.Users.Where(u => u.MailID == MailID && u.ID != ID).FirstOrDefault(); if (Validation != null) { throw new Exception("User Already Exist "); } var Entries = (from x in dBContext.Users where x.ID == ID select x).First(); if (Entries != null) { Entries.FirstName = Info.FirstName; Entries.LastName = Info.LastName; Entries.MailID = Info.MailID; Entries.Password = Password; Entries.DriverCategory = Info.DriverCategory; Entries.ModifiedDate = DateTime.Now; dBContext.SaveChanges(); return(Entries); } else { return(false); } } catch (Exception e) { throw new Exception(e.Message); } }
public UserLogin Login(UserLogin user) { try { //validating UserType bool inputUserType = Enum.TryParse <UserTypes.User>(user.UserTypes, true, out UserTypes.User type); if (inputUserType != true) { throw new Exception("Invalid User Category"); } //variable declared string Email = user.Email; int UserId = user.UserId; //password encrypted string Password = EncryptedPassword.EncodePasswordToBase64(user.Password); //User category string UserType = user.UserTypes; //Validating Login details var Result = dbContext.UserDetails.Where(v => v.ID == UserId && v.Email == Email && v.Password == Password && v.UserType == UserType).FirstOrDefault(); if (Result != null) { return(user); } else { throw new Exception("Login failed"); } } catch (Exception exception) { throw new Exception(exception.Message); } }
//Method to add user details public Response AddUserDetails(UserRegistration user) { Response response = new Response(); try { //Connection string declared string connect = Configuration.GetConnectionString("MyConnection"); //password encrypted string Password = EncryptedPassword.EncodePasswordToBase64(user.Password); using (SqlConnection Connection = new SqlConnection(connect)) { SqlCommand sqlCommand = new SqlCommand("UserRegistration", Connection); sqlCommand.CommandType = System.Data.CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@FirstName", user.FirstName); sqlCommand.Parameters.AddWithValue("@LastName", user.LastName); sqlCommand.Parameters.AddWithValue("@Gender", user.Gender); sqlCommand.Parameters.AddWithValue("@Email", user.Email); sqlCommand.Parameters.AddWithValue("@Address", user.Address); sqlCommand.Parameters.AddWithValue("@Designation", user.Designation); sqlCommand.Parameters.AddWithValue("@Salary", user.Salary); sqlCommand.Parameters.AddWithValue("@MobileNumber", user.MobileNumber); sqlCommand.Parameters.AddWithValue("@Password", Password); //connection open Connection.Open(); //declare variable int status = 0; //Execute query status = sqlCommand.ExecuteNonQuery(); try { SqlDataReader dataReader = sqlCommand.ExecuteReader(); while (dataReader.Read()) { response.UserId = Convert.ToInt32(dataReader["UserId"].ToString()); response.FirstName = dataReader["FirstName"].ToString(); response.LastName = dataReader["LastName"].ToString(); response.Gender = dataReader["Gender"].ToString(); response.Email = dataReader["Email"].ToString(); response.Address = dataReader["Address"].ToString(); response.Designation = dataReader["Designation"].ToString(); response.Salary = Convert.ToDouble(dataReader["Salary"].ToString()); response.MobileNumber = dataReader["MobileNumber"].ToString(); response.Password = dataReader["Password"].ToString(); } } catch { Response myReturnData = new Response() { message = "Error" }; string json = JsonConvert.SerializeObject(myReturnData); } //connection close Connection.Close(); //validation if (status == 1) { response.status = "Valid Email"; response.data = "Entered"; } else { response.status = "Invalid Email"; response.data = "Not entered"; } } return(response); } catch (Exception ex) { throw new Exception(ex.Message); } }