public int AddtoPersonalDetails(PersonalDetailsModel p_detail)
{
SqlConnection sqlConnection = OpenConnection();
sqlConnection.Open();
storedProcedureName = "sp_addEmployeePersonalDetails";
sqlCommand = createSqlCommand(sqlConnection, storedProcedureName);
sqlCommand.Parameters.AddWithValue("@firstName", p_detail.FirstName);
sqlCommand.Parameters.AddWithValue("@lastName", p_detail.LastName);
sqlCommand.Parameters.AddWithValue("@emailID", p_detail.EmailID);
sqlCommand.Parameters.AddWithValue("@mobileNumber", p_detail.Mobile);
sqlCommand.Parameters.AddWithValue("@alternateMobileNumber", p_detail.Phone);
sqlCommand.Parameters.AddWithValue("@Adress1", p_detail.Address1);
sqlCommand.Parameters.AddWithValue("@Address2", p_detail.Address2);
sqlCommand.Parameters.AddWithValue("@currentCountry", p_detail.CurrentCountry);
sqlCommand.Parameters.AddWithValue("@homeCountry", p_detail.HomeCountry);
sqlCommand.Parameters.AddWithValue("@zipCode", p_detail.ZipCode);
//command.Parameters.AddWithValue("@employeeID", p_detail.EmployeeID);
int result = sqlCommand.ExecuteNonQuery();
closeConnection(sqlConnection);
return(result);
}
public int UpdateToPersonalDetails(PersonalDetailsModel p_detail)
{
sqlConnection = OpenConnection();
sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "sp_editEmployeePersonalDetails";
sqlCommand.Parameters.AddWithValue("@firstName", p_detail.FirstName);
sqlCommand.Parameters.AddWithValue("@lastName", p_detail.LastName);
sqlCommand.Parameters.AddWithValue("@emailID", p_detail.EmailID);
sqlCommand.Parameters.AddWithValue("@mobileNumber", p_detail.Mobile);
sqlCommand.Parameters.AddWithValue("@alternateMobileNumber", p_detail.Phone);
sqlCommand.Parameters.AddWithValue("@Adress1", p_detail.Address1);
sqlCommand.Parameters.AddWithValue("@Address2", p_detail.Address2);
sqlCommand.Parameters.AddWithValue("@currentCountry", p_detail.CurrentCountry);
sqlCommand.Parameters.AddWithValue("@homeCountry", p_detail.HomeCountry);
sqlCommand.Parameters.AddWithValue("@zipCode", p_detail.ZipCode);
sqlCommand.Parameters.AddWithValue("@employeeID", p_detail.EmployeeID);
int result = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
return(result);
}
public ActionResult Index(PersonalDetailsModel model)
{
if (ModelState.IsValid)
{
var insertUser = new PersonalDetailsBL();
var insertUserModel = new TeamManagement.BO.PersonalDetail
{
FirstName = model.FirstName,
IdNumber = model.IdNumber,
Surname = model.LastName
};
string message = insertUser.Insert(insertUserModel);
if (message.Equals(String.Empty))
{
model.successMessage = true;
model.errorMessage = "Record Successfully updated";
return(View(model));
}
else
{
model.successMessage = false;
model.errorMessage = message;
return(View(model));
}
}
return(View());
}
public string savePersonalDetails(PersonalDetailsModel obj)
{
string JSONString = string.Empty;
SqlCommand com = new SqlCommand("USP_SAVE_PERSONALINFO", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@pId", obj.id);
com.Parameters.AddWithValue("@pLEGALNAME", obj.FullName);
com.Parameters.AddWithValue("@pDOB", obj.DOB);
com.Parameters.AddWithValue("@pGENDER", obj.Gender_id);
com.Parameters.AddWithValue("@pMarital_Status", obj.Marital_id);
com.Parameters.AddWithValue("@pNationality", obj.Natioanality_id);
con.Open();
com.ExecuteNonQuery();
con.Close();
return(JSONString);
}
public void AddPersonalInfo(PersonalDetailsModel PersonalDetailsModelClient)
{
var manager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(new ApplicationDbContext()));
var currentUser = manager.FindById(User.Identity.GetUserId());
int id = currentUser.UserInfo.Id;
PersonalDetails pd = new PersonalDetails();
pd.firstName = PersonalDetailsModelClient.firstName;
pd.lastName = PersonalDetailsModelClient.lastName;
pd.profession = PersonalDetailsModelClient.profession;
pd.contactNumber = PersonalDetailsModelClient.contactNumber;
pd.currentCity = PersonalDetailsModelClient.currentCity;
pd.currentCountry = PersonalDetailsModelClient.currentCountry;
pd.dateOfBirth = Convert.ToDateTime(PersonalDetailsModelClient.dateOfBirth);
pd.imageUrl = PersonalDetailsModelClient.imageUrl;
pd.UserInfoID = id;
PersonalDetailsBusinessLayer pdBal = new PersonalDetailsBusinessLayer();
pdBal.InsertPersonalDetails(pd);
}
protected void EmployeeDetails_EditButtonID_Click(object sender, EventArgs e)
{
PersonalDetailsModel personal_details = new PersonalDetailsModel()
{
FirstName = FirstNameTextbox.Text,
LastName = LastNameTextbox.Text,
EmailID = EmailIDTextBox.Text,
Contact = ContactTextBox.Text,
Mobile = Convert.ToInt32(MobileTextBox.Text),
Phone = Convert.ToInt64(PhoneTextBox.Text),
Address1 = Address1TextBox.Text,
Address2 = Address2TextBox.Text,
HomeCountry = HomeTextBox.Text,
CurrentCountry = CurrentCountryTextBox.Text,
ZipCode = Convert.ToInt32(ZipCodeTextBox.Text),
EmployeeID = Convert.ToInt16(EmployeeIDTextBox.Text)
};
EmployeeDataAccessLayer employeeDataAccessLayer = new EmployeeDataAccessLayer();
employeeDataAccessLayer.UpdateToPersonalDetails(personal_details);
}
