/// <summary>
/// Method of class EmployerDetailsHRDAL for saving EmployerDetails in database
/// </summary>
/// <param name="employerDetailsEntity">Object of EmployerDetailsEntity</param>
/// <returns>System.Int32</returns>
public int SaveEmployerDetailsDAL(EmployerDetailsHREntity employerDetailsEntity)
{
try
{
connection.Open();
//Add parameter for stored procedure
SqlParameter[] sparam = { new SqlParameter("@hrid", employerDetailsEntity.HrId),
new SqlParameter("@companyName", employerDetailsEntity.CompanyName),
new SqlParameter("@companyProfile",employerDetailsEntity.CompanyProfile),
new SqlParameter("@employerHRFullName", employerDetailsEntity.EmployerHRFullName),
new SqlParameter("@companyContactNumber", employerDetailsEntity.CompanyContactNumber),
new SqlParameter("@mobileNumber", employerDetailsEntity.MobileNumber),
new SqlParameter("@address", employerDetailsEntity.Address),
new SqlParameter("@countryId", employerDetailsEntity.CountryId),
new SqlParameter("@stateId", employerDetailsEntity.StateId),
new SqlParameter("@cityId", employerDetailsEntity.CityId),
new SqlParameter("@areaId", employerDetailsEntity.AreaId),
new SqlParameter("@pincode", employerDetailsEntity.Pincode),
new SqlParameter("@officialEmailId", employerDetailsEntity.OfficialEmailId),
new SqlParameter("@password", employerDetailsEntity.Password),
new SqlParameter("@status", employerDetailsEntity.Status),
new SqlParameter("@photo", "~/UploadImages/"+employerDetailsEntity.Photo)
};
int result = SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, Constants.sp_HR_InsertEmployerDetails, sparam);
return result;
}
catch (System.Exception)
{
throw;
}
finally
{
connection.Close();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
EmployerDetailsHRBAL employerDetailsHRBAL = new EmployerDetailsHRBAL();
EmployerDetailsHREntity employerDetailsHREntity = new EmployerDetailsHREntity();
// Assign values to the entities
employerDetailsHREntity.HrId = 1;
employerDetailsHREntity.CompanyName = txtCompanyName.Text.Trim();
employerDetailsHREntity.CompanyProfile = txtCompanyProfile.Text.Trim();
employerDetailsHREntity.EmployerHRFullName = txtEmployerHRFullName.Text.Trim();
employerDetailsHREntity.CompanyContactNumber = txtCompanyContactNo.Text.Trim();
employerDetailsHREntity.MobileNumber = txtMobileNumber.Text.Trim();
employerDetailsHREntity.Address = txtAddress.Text.Trim();
employerDetailsHREntity.CountryId = Convert.ToInt32(ddlCountry.SelectedValue);
employerDetailsHREntity.StateId = Convert.ToInt32(ddlState.SelectedValue);
employerDetailsHREntity.CityId = Convert.ToInt32(ddlCity.SelectedValue);
employerDetailsHREntity.AreaId = Convert.ToInt32(ddlArea.SelectedValue);
employerDetailsHREntity.Pincode = Convert.ToInt32(txtPincode.Text.Trim());
employerDetailsHREntity.OfficialEmailId = txtOfficialEMailId.Text.Trim();
employerDetailsHREntity.Password = txtPassword.Text.Trim();
employerDetailsHREntity.Status = rbtlistStatus.SelectedItem.Text;
// Check if fileupload control has a file.
if (FileUploadPhoto.PostedFile != null)
{
employerDetailsHREntity.Photo = Path.GetFileName(FileUploadPhoto.PostedFile.FileName);
FileUploadPhoto.SaveAs(Server.MapPath("~/UploadImages/" + employerDetailsHREntity.Photo));
}
// Saving data to the database
int result = employerDetailsHRBAL.SaveEmployerDetailsBAL(employerDetailsHREntity);
if (result > 0)
{
Response.Write("<script language='javascript'>alert('Save Employer Details Successfully')</script>");
}
else
{
Response.Write("<script language='javascript'>alert('Employer Details won't saved')</script>");
}
}
catch (Exception)
{
//throw;
}
}
/// <summary>
/// Update employer details method in EmployerDetailsHRBAL class
/// </summary>
/// <param name="employerDetailsEntity">Object of EmployerDetailsHRBAL</param>
/// <returns>System.Int32</returns>
public int UpdateEmployerDetailsBAL(EmployerDetailsHREntity employerDetailsHREntity)
{
EmployerDetailsHRDAL employerDetailsHRDAL = new EmployerDetailsHRDAL();
return employerDetailsHRDAL.UpdateEmployerDetailsDAL(employerDetailsHREntity);
}
