/// <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); }