public string EmployeeToAdminReg(userUpdation update)
{
try
{
string q1 = "", q2 = "";
q1 = "select count(*) from nworksuser where uid='" + update.uid + "';";
MySqlCommand cmd1 = new MySqlCommand(q1, conn);
conn.Open();
Int32 count = Convert.ToInt32(cmd1.ExecuteScalar());
conn.Close();
cmd1.Dispose();
if (count != 0)
{
q2 = "update nWorksUser set fname='" + update.fname + "',mname='" + update.mname + "',lname='" + update.lname + "',dob='" + update.dob + "',gender='" + update.gender + "',desg='" + update.desg + "',hire_date='" + update.hire_date + "',username='******',addressline1='" + update.addressLine1 + "',addressline2='" + update.addressLine2 + "',state='" + update.state + "',city='" + update.city + "',pincode='" + update.pincode + "',country='" + update.country + "',mobileno='" + update.mobileNo + "',_type='" + update._type + "',useractive='" + update.userActive + "',leavedate='" + update.leaveDate + "',annivarsary='" + update.anniversary + "',email='" + update.email + "' where uid='" + update.uid + "';";
MySqlCommand MyCommand = new MySqlCommand(q2, conn);
MySqlDataReader MyReader;
conn.Open();
MyReader = MyCommand.ExecuteReader();
conn.Close();
return(string.Format("Registration is Successful!"));
}
else
{
return(string.Format(update.fname + " " + update.lname + " is not found!"));
}
}
catch (Exception ex)
{
return(string.Format(ex.ToString()));
}
}
async public void promot()
{
if (isConnected == "Connected")
{
if (validateMobileNumber(mobileNumber.Text) == true)
{
if (validatePincode(pinCode.Text) == true)
{
if (validateEmail(emailAddress.Text) == true)
{
if (password.Text == confirmPassword.Text)
{
userUpdation obj = new userUpdation();
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 = "Admin_Employee";
obj.userActive = "true";
obj.leaveDate = "1900-01-01";
obj.anniversary = dateOfAnniversary.Date.ToString("yyyy-MM-dd");
obj.desg = desg.Text;
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 + "EmployeeToAdminRegistration", content);
if (response.IsSuccessStatusCode)
{
var content1 = await response.Content.ReadAsStringAsync();
await DisplayAlert(" nWorksLeaveApp", content1.ToString(), "OK");
await this.Navigation.PopAsync();
}
else
{
await DisplayAlert(" nWorksLeaveApp", "Response is not Received!", "OK");
}
}
catch (Exception ex)
{
await DisplayAlert(" nWorksLeaveApp", "Unable to connect server, Try again!", "OK");
Debug.WriteLine(ex.ToString());
}
}
else
{
await DisplayAlert(" nWorksLeaveApp", "Password and Confirm Password does not matched!", "OK");
}
}
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");
}
}
