public userRegistration loginUser(userRegistration userData)
{
userRegistration user = new userRegistration();
_conn.Open();
SqlCommand command = new SqlCommand("spGetuser", _conn)
{
CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.AddWithValue("@email", userData.email);
command.Parameters.AddWithValue("@password", userData.password);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
user = (new userRegistration
{
userId = (int)reader["userId"],
firstName = (string)reader["firstName"],
lastName = (string)reader["lastName"],
email = (string)reader["email"],
password = (string)reader["password"],
role = (string)reader["role"]
});
}
}
_conn.Close();
return(user);
}
public string userRegistration(userRegistration userRegister)
{
try
{
string Query1 = "select count(*) from nworksuser where username='******' and _password='******';";
MySqlCommand cmd = new MySqlCommand(Query1, conn);
conn.Open();
Int32 count = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
cmd.Dispose();
if (count != 0)
{
return(string.Format("Userid or Username is already exist!"));
}
else
{
string Query = "insert into nWorksUser values('" + userRegister.uid + "','" + userRegister.fname + "','" + userRegister.mname + "','" + userRegister.lname + "','" + userRegister.dob + "','" + userRegister.gender + "','" + userRegister.desg + "','" + userRegister.hire_date + "','" + userRegister.username + "','" + Encrypt(userRegister.password) + "','" + userRegister.addressLine1 + "','" + userRegister.addressLine2 + "','" + userRegister.state + "','" + userRegister.city + "','" + userRegister.pincode + "','" + userRegister.country + "','" + userRegister.mobileNo + "','" + userRegister._type + "','" + userRegister.userActive + "','" + userRegister.leaveDate + "','" + userRegister.anniversary + "','" + userRegister.email + "','" + userRegister.inout_status + "');";
MySqlCommand MyCommand = new MySqlCommand(Query, conn);
MySqlDataReader MyReader;
conn.Open();
MyReader = MyCommand.ExecuteReader();
conn.Close();
return(string.Format("Registration Successful!"));
}
}
catch (Exception ex)
{
return(string.Format(ex.ToString()));
}
}
public string userRegistration(userRegistration userUpdate)
{
try
{
string Query = "update nWorksUser set fname='" + userUpdate.fname + "',mname='" + userUpdate.mname + "',lname='" + userUpdate.lname + "',dob='" + userUpdate.dob + "',gender='" + userUpdate.gender + "',desg='" + userUpdate.desg + "',hire_date='" + userUpdate.hire_date + "',username='******',addressline1='" + userUpdate.addressLine1 + "',addressline2='" + userUpdate.addressLine2 + "',state='" + userUpdate.state + "',city='" + userUpdate.city + "',pincode='" + userUpdate.pincode + "',country='" + userUpdate.country + "',mobileno='" + userUpdate.mobileNo + "',_type='" + userUpdate._type + "',useractive='" + userUpdate.userActive + "',leavedate='" + userUpdate.leaveDate + "',annivarsary='" + userUpdate.anniversary + "',email='" + userUpdate.email + "' where uid='" + userUpdate.uid + "';";
MySqlCommand MyCommand = new MySqlCommand(Query, conn);
MySqlDataReader MyReader;
conn.Open();
MyReader = MyCommand.ExecuteReader();
conn.Close();
string q = "update additional_earned_leaves set Rolled_Over_from_Previous_Year='" + userUpdate.Leaves_Rolled_Over_from_Previous_yr + "',Earned_in_current_year='" + userUpdate.Additional_Earned_Leaves + "' where uid='" + userUpdate.uid + "' and Current_Year='" + DateTime.Today.Year + "';";
MySqlCommand cmd = new MySqlCommand(q, conn);
MySqlDataReader rdr;
conn.Open();
rdr = cmd.ExecuteReader();
conn.Close();
return(string.Format("Upadation Successful!"));
}
catch (Exception ex)
{
return(string.Format("Failure in Upadation! Please Contact Admin!"));
}
}
public IActionResult RegisterUser([FromBody] userRegistration userData)
{
userRegistration result = _service.addUser(userData);
return(Ok(new response <userRegistration> {
StatusCode = (int)HttpStatusCode.OK, Message = "successful", Data = result
}));
}
public IActionResult loginUser([FromBody] userRegistration userData)
{
string result = _service.loginUser(userData);
return(Ok(new response <string> {
StatusCode = (int)HttpStatusCode.OK, Message = "successful", Data = result
}));
}
public ActionResult login(userRegistration user)
{
if (ModelState.IsValid)
{
if (user.is)
{
}
else
{
ModelState.AddModelError("", "invalid credentials");
}
}
public ActionResult RegistrationDetails([FromBody] userRegistration reg)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
else
{
ScoreGeniusAPI.BusinessLogic.BusinessLogic bl = new ScoreGeniusAPI.BusinessLogic.BusinessLogic();
int result = bl.userRegistration(reg);
return(Ok(
result
));
}
//return Unauthorized();
}
public string GenerateToken(userRegistration account)
{
var tokenDescriptor = new SecurityTokenDescriptor
{
Subject = new System.Security.Claims.ClaimsIdentity(new Claim[] {
new Claim(ClaimTypes.Email, account.email),
new Claim(ClaimTypes.UserData, account.userId.ToString()),
new Claim(ClaimTypes.Role, account.role)
}),
Expires = DateTime.UtcNow.AddDays(1),
SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(secretKey),
SecurityAlgorithms.HmacSha256Signature)
};
var token = tokenHandler.WriteToken(tokenHandler.CreateToken(tokenDescriptor));
return(token);
}
public userRegistration addUser(userRegistration userData)
{
SqlCommand command = new SqlCommand("spAddUser")
{
CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.AddWithValue("@firstName", userData.firstName);
command.Parameters.AddWithValue("@lastName", userData.lastName);
command.Parameters.AddWithValue("@email", userData.email);
command.Parameters.AddWithValue("@password", userData.password);
command.Parameters.AddWithValue("@phone", userData.phone);
_conn.Open();
command.Connection = _conn;
command.ExecuteNonQuery();
_conn.Close();
return(userData);
}
public ActionResult Login(userRegistration user)
{
using (MyDbContext db = new MyDbContext())
{
var usr = db.UserRegistraion.Single(u => u.UserID == u.UserID && u.Password == user.Password);
if (user != null)
{
Session["UserID"] = user.UserID.ToString();
Session["Username"] = user.Username.ToString();
return(RedirectToAction("Loggedin"));
}
else
{
ModelState.AddModelError(" ", "Username or Password is wrong.");
}
}
return(View());
}
public ActionResult Register(userRegistration account)
{
if (ModelState.IsValid)
{
using (MyDbContext db = new MyDbContext())
{
db.UserRegistraion.Add(account);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = account.FirstName + " " + account.LastName + "successfully registered.";
}
{
return(View());
}
}
public ActionResult Index(userRegistration user)
{
if (ModelState.IsValid)
{
if (db.userRegistrations.Any(x => x.emailAddress == user.emailAddress))
{
ViewBag.ErrorMessage = "email address already exist";
}
else
{
db.userRegistrations.Add(user);
db.SaveChanges();
ViewBag.Message = "Registered Successfully ;)";
}
ModelState.Clear();
}
return(View(user));
}
public int InsertUserRegistration(userRegistration reg)
{
SqlCommand cmd = new SqlCommand("Sp_AddUserRegistration", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("Name", reg.name);
cmd.Parameters.AddWithValue("Password", reg.password);
cmd.Parameters.AddWithValue("ReTypepass", reg.retypepassword);
cmd.Parameters.AddWithValue("Email", reg.email);
conn.Open();
int k = cmd.ExecuteNonQuery();
if (k != 0)
{
return(1);
}
conn.Close();
return(0);
}
async public void UpdateEmployee()
{
if (isConnected == "Connected")
{
if (validateMobileNumber(mobileNumber.Text) == true)
{
if (validatePincode(pinCode.Text) == true)
{
if (validateEmail(emailAddress.Text) == true)
{
userRegistration obj = new userRegistration();
obj.Leaves_Rolled_Over_from_Previous_yr = float.Parse(Leaves_From_Past_Year.Text.ToString());
obj.Additional_Earned_Leaves = float.Parse(additional_earned_leaves.Text.ToString());
obj.uid = empNo.Text;
obj.fname = empFname.Text;
obj.mname = empMname.Text;
obj.lname = empLname.Text;
obj.dob = dateOfBirth.Date.ToString("yyyy-MM-dd");
obj.hire_date = dateOfHire.Date.ToString("yyyy-MM-dd");
obj.username = username.Text;
obj.addressLine1 = address1.Text;
obj.addressLine2 = address2.Text;
obj.state = state.Text;
obj.city = city.Text;
obj.pincode = int.Parse(pinCode.Text);
obj.country = country.Text;
obj.mobileNo = mobileNumber.Text;
obj._type = "Employee";
obj.userActive = "true";
obj.leaveDate = "1900-01-01";
obj.anniversary = dateOfAnniversary.Date.ToString("yyyy-MM-dd");
obj.desg = desg.Text;
obj.inout_status = "Outside";
obj.email = emailAddress.Text;
obj.leaveDate = LeaveDatePicker.Date.ToString("yyyy-MM-dd");
if (switchActiveInactive.IsToggled == true)
{
obj.userActive = "true";
}
else
{
obj.userActive = "false";
}
if (maleCheck == 1 && femaleCheck == 0)
{
obj.gender = "Male";
}
else
{
obj.gender = "Female";
}
try
{
var json = JsonConvert.SerializeObject(obj);
var content = new StringContent(json, Encoding.UTF8, "application/json");
HttpClient Client = new HttpClient();
HttpResponseMessage response = null;
response = await Client.PostAsync(ColorResources.baseUrl + "manageemployee", content);
if (response.IsSuccessStatusCode)
{
var content1 = await response.Content.ReadAsStringAsync();
await DisplayAlert(" nWorksLeaveApp", content1.ToString(), "OK");
await this.Navigation.PopAsync();
}
}
catch (Exception ex)
{
await DisplayAlert(" nWorksLeaveApp", "Unable to connect server, Try again!", "OK");
Debug.WriteLine(ex.ToString());
}
}
else
{
await DisplayAlert(" nWorksLeaveApp", "Email is invalid!", "OK");
}
}
else
{
await DisplayAlert(" nWorksLeaveApp", "Pincode is invalid!", "OK");
pinCode.Focus();
}
}
else
{
await DisplayAlert(" nWorksLeaveApp", "Mobile Number is invalid!", "OK");
mobileNumber.Focus();
}
}
else
{
await DisplayAlert(" nWorksLeaveApp", "No Internet Connection, Try Again!", "OK");
}
}
public string loginUser(userRegistration userData)
{
userRegistration result = _repository.loginUser(userData);
string token = _tokenManager.GenerateToken(result);
return token;
}
public userRegistration addUser(userRegistration userData)
{
userRegistration result = _repository.addUser(userData);
return result;
}
async public void register()
{
await this.Navigation.PushModalAsync(new Loading());
try
{
if (isConnected == "Connected")
{
if (validateMobileNumber(mobileNumber.Text) == true)
{
if (validatePincode(pinCode.Text) == true)
{
if (validateEmail(emailAddress.Text) == true)
{
if (password.Text == confirmPassword.Text)
{
userRegistration obj = new userRegistration();
obj.uid = empNo.Text;
obj.fname = empFname.Text;
obj.mname = empMname.Text;
obj.lname = empLname.Text;
obj.dob = dateOfBirth.Date.ToString("yyyy-MM-dd");
obj.hire_date = dateOfHire.Date.ToString("yyyy-MM-dd");
obj.username = username.Text;
obj.password = password.Text;
obj.addressLine1 = address1.Text;
obj.addressLine2 = address2.Text;
obj.state = state.Text;
obj.city = city.Text;
obj.pincode = int.Parse(pinCode.Text);
obj.country = country.Text;
obj.mobileNo = mobileNumber.Text;
obj._type = "Employee";
obj.userActive = "true";
obj.leaveDate = "1900-01-01";
obj.anniversary = dateOfAnniversary.Date.ToString("yyyy-MM-dd");
obj.desg = desg.Text;
obj.inout_status = "Outside";
obj.email = emailAddress.Text;
if (maleCheck == 1 && femaleCheck == 0)
{
obj.gender = "Male";
}
else
{
obj.gender = "Female";
}
try
{
var json = JsonConvert.SerializeObject(obj);
var content = new StringContent(json, Encoding.UTF8, "application/json");
HttpClient Client = new HttpClient();
HttpResponseMessage response = null;
response = await Client.PostAsync(ColorResources.baseUrl + "userRegistration", content);
if (response.IsSuccessStatusCode)
{
var content1 = await response.Content.ReadAsStringAsync();
await DisplayAlert("Message", content1.ToString(), "OK");
clearAllFields();
await this.Navigation.PopAsync();
}
}
catch (Exception ex)
{
await DisplayAlert(" nWorksLeaveApp", ex.ToString(), "OK");
}
}
else
{
await DisplayAlert(" nWorksLeaveApp", "Password and Confirm Password does not matched!", "OK");
}
}
else
{
await DisplayAlert(" nWorksLeaveApp", "Email is invalid!", "OK");
emailAddress.Focus();
}
}
else
{
await DisplayAlert(" nWorksLeaveApp", "Pincode is invalid!", "OK");
pinCode.Focus();
}
}
else
{
await DisplayAlert(" nWorksLeaveApp", "Mobile Number is invalid!", "OK");
mobileNumber.Focus();
}
}
else
{
await DisplayAlert(" nWorksLeaveApp", "No Internet Connection, Try Again!", "OK");
}
}
catch (Exception ex)
{
await DisplayAlert(" nWorksLeaveApp", "Unable to connect server, Try again!", "OK");
Debug.WriteLine(ex.ToString());
}
await this.Navigation.PopModalAsync();
}
public int userRegistration(userRegistration reg)
{
int res = dal.InsertUserRegistration(reg);
return(res);
}
