private void SaveButton_Click(object sender, EventArgs e) { try { EmployeeModel employeeModel = new EmployeeModel() { FirstName = FirstNameTextBox.Text, LastName = LastNameTextBox.Text, EmailId = EmailIdTextBox.Text, MobileNumber = Convert.ToInt64(MobileNumberTextBox.Text), AlternateMobileNumber = Convert.ToInt64(AlternateMobileNumberTextBox.Text), Address1 = Address1TextBox.Text, Address2 = Address2TextBox.Text, CurrentCountry = CurrentCountryTextBox.Text, HomeCountry = HomeCountryTextBox.Text, ZipCode = Convert.ToInt32(ZipCodeTextBox.Text) }; EmployeeDataAccessLayer EmployeeDAL = new EmployeeDataAccessLayer(); int NoOfRowsAffected = EmployeeDAL.SaveEmployeeData(employeeModel); if (NoOfRowsAffected > 0) { MessageBox.Show("Succesfully saved in Employee Detail"); } else { MessageBox.Show("Could Not Save"); } } catch (Exception exception) { MessageBox.Show("EXCEPTION OCCURED. PLEASE CONTACT ADMINISTRATOR", exception.Message); } }
protected void Button4_Click(object sender, EventArgs e) { EmployeeModel myEmployee = new EmployeeModel { firstName = TextBox1.Text, lastName = TextBox2.Text, emailId = TextBox3.Text, phoneNumber = Convert.ToInt64(TextBox4.Text), alternatePhoneNumber = Convert.ToInt64(TextBox5.Text), address1 = TextBox6.Text, address2 = TextBox7.Text, homeCountry = TextBox8.Text, currentCountry = TextBox9.Text, zipCode = Convert.ToInt32(TextBox10.Text), }; EmployeeDataAccessLayer myemployee = new EmployeeDataAccessLayer(); int result = myemployee.EditEmployeeDetail(myEmployee); if (result > 0) { string display = "Successful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } else { string display = "UnSuccessful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } }
protected void Button2_Click(object sender, EventArgs e) { ProjectModel myProject = new ProjectModel { projectName = TextBox2.Text, clientName = TextBox3.Text, location = TextBox6.Text, roles = TextBox4.Text, employeeId = Convert.ToInt32(TextBox5.Text) }; EmployeeDataAccessLayer myproject = new EmployeeDataAccessLayer(); int result = myproject.TakeProjectDetail(myProject); if (result > 0) { string display = "Successful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } else { string display = "UnSuccessful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } }
protected void Button1_Click(object sender, EventArgs e) { TechnicalModel myTechnical = new TechnicalModel { UI = TextBox1.Text, ProgrammingLanguage = TextBox2.Text, Database = TextBox3.Text, employeeId = Convert.ToInt32(TextBox4.Text) }; EmployeeDataAccessLayer mytechnical = new EmployeeDataAccessLayer(); int result = mytechnical.TakeTechnicalDetail(myTechnical); if (result > 0) { string display = "Successful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } else { string display = "UnSuccessful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } }
private void saveButton_Click(object sender, EventArgs e) { EmployeeModel myEmployee = new EmployeeModel { firstName = firstNameTextBox.Text, lastName = lastNameTextBox.Text, emailId = emailIDTextBox.Text, phoneNumber = Convert.ToInt64(phoneNumberTextBox.Text), alternatePhoneNumber = Convert.ToInt64(alternatePhoneTextBox.Text), address1 = address1TextBox.Text, address2 = address2TextBox.Text, homeCountry = homeCountryTextBox.Text, currentCountry = currentCountryTextBox.Text, zipCode = Convert.ToInt32(zipcodeTextBox.Text) }; EmployeeDataAccessLayer myempdataal = new EmployeeDataAccessLayer(); int result = myempdataal.TakeEmployeeName(myEmployee); if (result > 0) { MessageBox.Show("done"); } else { MessageBox.Show("fail"); } }
private void companyDetailsSaveButton_Click(object sender, EventArgs e) { CompanyModel myCompany = new CompanyModel() { employerName = employerNameTextBox.Text, contactNumber = Convert.ToInt32(contactNumberTextBox.Text), location = locationTextBox.Text, website = websiteTextBox.Text, employeeId = Convert.ToInt32(textBox2.Text) }; EmployeeDataAccessLayer myCompanyDal = new EmployeeDataAccessLayer(); int result = myCompanyDal.TakeCompanyDetail(myCompany); if (result > 0) { MessageBox.Show("Done"); } else { MessageBox.Show("Not done"); } }
protected void SaveButton_Click(object sender, EventArgs e) { EmployeeModel model = new EmployeeModel() { FirstName = FirstNameTextBox.Text, LastName = LastNameTextBox.Text, EmailId = EmailIdTextBox.Text, MobileNumber = Convert.ToInt64(MobileNumberTextBox.Text), AlternateMobileNumber = Convert.ToInt64(AlternateMobileNumberTextBox.Text), Address1 = Address1TextBox.Text, Address2 = Address2TextBox.Text, HomeCountry = HomeCountryTextBox.Text, CurrentCountry = CurrentCountryTextBox.Text, ZipCode = Convert.ToInt32(ZipCodeTextBox.Text) }; EmployeeDataAccessLayer EmployeeDAL = new EmployeeDataAccessLayer(); int NoOfRowsAffected = EmployeeDAL.SaveEmployeeData(model); ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert(' Employee Details SUCCESSFULLY saved');", true); }
protected void Button2_Click(object sender, EventArgs e) { CompanyModel myCompany = new CompanyModel { employerName = TextBox1.Text, contactNumber = Convert.ToInt32(TextBox2.Text), location = TextBox3.Text, website = TextBox4.Text, employeeId = Convert.ToInt32(TextBox5.Text) }; EmployeeDataAccessLayer mycompany = new EmployeeDataAccessLayer(); int result = mycompany.EditCompanyDetail(myCompany); if (result > 0) { string display = "Successful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } else { string display = "UnSuccessful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } }
public IEnumerable <Employee> Get() { // return new string[] { "value1", "value2" }; EmployeeDataAccessLayer employeeDataAccessLayer = new EmployeeDataAccessLayer(); return(employeeDataAccessLayer.GetAllEmployees()); }
protected void CompanySaveButton_Click(object sender, EventArgs e) { var model = new CompanyModel { EmployerName = EmployerNameTextBox.Text, ContactNumber = EmployerContactNumberTextBox.Text, Place = EmployerLocationTextBox.Text, Website = EmployerWebsiteTextBox.Text, EmployeeId = Convert.ToInt32(EmployeeIdTextBox.Text) }; var employeeDataAccessLayer = new EmployeeDataAccessLayer(); var result = employeeDataAccessLayer.SaveCompanyDetails(model); if (result > 0) { var display = "Successful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } else { var display = "UnSuccessful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } }
public int SaveEmployee(EmployeeModel employeeModel) { EmployeeDataAccessLayer employeeDataAccessLayer = new EmployeeDataAccessLayer(); int result = employeeDataAccessLayer.SaveEmployeeDetails(employeeModel); return(result); }
private void SubmitButton_Click(object sender, EventArgs e) { EducationalObj.CourseType = CourseTypeTextBox.Text; EducationalObj.CourseSpecialization = CourseSpecializationTextBox.Text; EducationalObj.CourseYearofPassing = CourseYearTextBox.Text; try { EmployeeDataAccessLayer EmployeeDataAccessLayerObj = new EmployeeDataAccessLayer(); string status = EmployeeDataAccessLayerObj.InsertConsultantDetails(EmployeeObj, ProjectObj, CompanyObj, TechnicalObj, EducationalObj); if (status.Equals("success")) { if (MessageBox.Show("Successfully Inserted values!!", "OK", MessageBoxButtons.OK) == DialogResult.OK) { this.Hide(); HomeScreen HomeScreenObj = new HomeScreen(); HomeScreenObj.Show(); } } else { MessageBox.Show(status); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void projectDetailsSaveButton_Click(object sender, EventArgs e) { ProjectModel myProject = new ProjectModel() { projectName = projectNameTextBox.Text, clientName = clientNameTextBox.Text, location = projectLocationTextBox.Text, roles = rolesTextBox.Text, employeeId = Convert.ToInt32(employeeIdTextBox.Text) }; EmployeeDataAccessLayer myProjectDal = new EmployeeDataAccessLayer(); ServiceReference1.Service1Client sc1 = new ServiceReference1.Service1Client(); var result = sc1.TakeProjectDetail(myProject); if (result > 0) { MessageBox.Show("Done"); } else { MessageBox.Show("Failure"); } }
protected void SaveButton_Click(object sender, EventArgs e) { Pioneertech.Consultancy.model.EmployeeDetail employeeDetail = new Pioneertech.Consultancy.model.EmployeeDetail { FirstName = FirstNameTextBox.Text, LastName = LastNameTextBox.Text, EmailId = EmailIdTextBox.Text, PhoneNumber = Convert.ToInt64(PhoneNumberTextBox.Text), AlternatePhoneNumber = Convert.ToInt64(AlternatePhoneNumberTextBox.Text), Address1 = Address1TextBox.Text, Address2 = Address2TextBox.Text, HomeCountry = HomeCountryTextBox.Text, CurrentCountry = CurrentCountryTextBox.Text, ZipCode = Convert.ToInt32(ZipCodeTextBox.Text) }; EmployeeDataAccessLayer employeeDAL = new EmployeeDataAccessLayer(); int numberOfRowEffected = employeeDAL.SaveEmployeeData(employeeDetail); if (numberOfRowEffected > 0) { string display = "Employee Data is Successfully Saved"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } else { string display = "Employee Data not Saved. Please try again."; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } }
public Employee Get(int id) { EmployeeDataAccessLayer employeeDataAccessLayers = new EmployeeDataAccessLayer(); var employee = employeeDataAccessLayers.GetEmployeeData(id); return(employee); }
public ActionResult Put(int id, [FromBody] Employee employee) { EmployeeDataAccessLayer employeeDataAccessLayer = new EmployeeDataAccessLayer(); employeeDataAccessLayer.UpdateEmployee(employee); return(Ok); }
protected void Save_Click(object sender, EventArgs e) { EmployeeDetailsModel employeeDetailobj = new EmployeeDetailsModel { FirstName = FirstNameTextBox.Text, LastName = LastNameTextBox.Text, EmailId = EmailIDTextBox3.Text, PhoneNumber = Convert.ToInt64(MobileNumberTextBox.Text), AlternatePhoneNumber = Convert.ToInt64(AlternateMobileNumberTextBox.Text), Address1 = Address1TextBox.Text, Address2 = Address2TextBox.Text, HomeCountry = HomeCountryTextBox.Text, CurrentCountry = CurrentCountryTextBox.Text, ZipCode = Convert.ToInt64(ZipCodeTextBox.Text) }; EmployeeDataAccessLayer employeeDataAccessobj = new EmployeeDataAccessLayer(); long RowsAffected = employeeDataAccessobj.SaveEmployeeSqlConnection(employeeDetailobj); if (RowsAffected > 0) { string display = "Successful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } else { string display = "UnSuccessful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } }
public ActionResult Delete(int id) { EmployeeDataAccessLayer employeeDataAccessLayers = new EmployeeDataAccessLayer(); employeeDataAccessLayers.DeleteEmployee(id); return(Ok()); }
protected void SaveButton_Click1(object sender, EventArgs e) { ProjectDetailsModel projectDetailobj = new ProjectDetailsModel { ProjectName = ProjectNameTextBox.Text, ClientName = ClientNameTextBox.Text, Location = Location_TextBox.Text, Roles = RolesTextBox.Text, EmployeeId = Convert.ToInt32(ProjectEmployeeDropDownList1.Text) }; EmployeeDataAccessLayer projectDataAccessobj = new EmployeeDataAccessLayer(); long RowsAffected = projectDataAccessobj.ProjectSqlConnection(projectDetailobj); if (RowsAffected > 0) { string display = "Successful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } else { string display = "UnSuccessful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } }
protected void Save_Click(object sender, EventArgs e) { CompanyDetailsModel companyDetailobj = new CompanyDetailsModel { EmployerName = EmployerNameTextBox.Text, ContactNumber = Convert.ToInt64(ContactNumberTextBox.Text), Location = LocationTextBox.Text, Website = WebsiteTextBox.Text, EmployeeId = Convert.ToInt32(EmployeeIDTextBox.Text) }; EmployeeDataAccessLayer companyDataAccessobj = new EmployeeDataAccessLayer(); long RowsAffected = companyDataAccessobj.CompanySqlConnection(companyDetailobj); if (RowsAffected > 0) { string display = "Successful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } else { string display = "UnSuccessful!"; ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true); } }
public int SaveEmployeeData(EmployeeModel model) { EmployeeDataAccessLayer EmployeeDAL = new EmployeeDataAccessLayer(); int result = EmployeeDAL.SaveEmployeeData(model); return(result); }
protected void btnSearch_Click(object sender, EventArgs e) { EmployeeDataAccessLayer emp = new EmployeeDataAccessLayer(); DataTable dt = new DataTable(); dt = emp.GetSearchEmployee2(txtId.Text, txtFname.Text, txtLname.Text, txtGender.Text, txtCountry.Text, txtState.Text, txtCity.Text, txtLanguge.Text, txtEmail.Text); gvEmployee4.DataSource = dt; gvEmployee4.DataBind(); }
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e) { var employeeDataAccessLayer = new EmployeeDataAccessLayer(); var result = employeeDataAccessLayer.GetCompanyCode(Convert.ToInt32(DropDownList3.Text)); EmployerNameTextBox.Text = result.EmployerName; EmployerContactNumberTextBox.Text = result.ContactNumber; EmployerLocationTextBox.Text = result.Place; EmployerWebsiteTextBox.Text = result.Website; }
public int TakeProjectDetail(ProjectModel myProject) { EmployeeDataAccessLayer employee = new EmployeeDataAccessLayer(); //return employee.TakeEmployeeName(myEmployee); var result = employee.TakeProjectDetail(myProject); return(result); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int totalRows = 0; gvEmployee4.DataSource = EmployeeDataAccessLayer.GetEmployees(0, gvEmployee4.PageSize, gvEmployee4.Attributes["CurrentSortField"], gvEmployee4.Attributes["CurrentSortDirection"], out totalRows); gvEmployee4.DataBind(); Databind_DDLPageNumbers(0, 3, totalRows); lblPageCount.Text = "<i><b>" + "Displaying Page " + 1 + " of " + gvEmployee4.PageSize + "<b><i>"; } }
public ActionResult Put(int id, [FromBody] Employee employee) { if (id != employee.ID) { return(BadRequest()); } EmployeeDataAccessLayer employeeDataAccessLayers = new EmployeeDataAccessLayer(); employeeDataAccessLayers.UpdateEmployee(employee); return(Ok()); }
//private List<Employee> EmployeeData; //private List<Company> CompanyData; //private List<Project> ProjectData; //private List<Technical> TechnicalData; //private List<Educational> EducationData; protected void Page_Load(object sender, EventArgs e) { employeeDataAccessLayerObject = new EmployeeDataAccessLayer(); if (!IsPostBack) { EmployeeIDDropDownList.DataTextField = "EmployeeID"; EmployeeIDDropDownList.DataValueField = "EmployeeID"; EmployeeIDDropDownList.DataSource = employeeDataAccessLayerObject.GetEmployeeID(); EmployeeIDDropDownList.DataBind(); EmployeeIDDropDownList.Items.Insert(0, new ListItem("Select EmployeeID", "0")); } }
protected void ddlPageSize_SelectedIndexChanged(object sender, EventArgs e) { int totalRows = 0; int pageSize = int.Parse(ddlPageSize.SelectedValue); int pageIndex = 0; gvEmployee4.PageSize = pageSize; gvEmployee4.DataSource = EmployeeDataAccessLayer.GetEmployees(pageIndex, pageSize, gvEmployee4.Attributes["CurrentSortField"], gvEmployee4.Attributes["CurrentSortDirection"], out totalRows); gvEmployee4.DataBind(); Databind_DDLPageNumbers(pageIndex, pageSize, totalRows); }
protected void AcademicDetailsEditButton_Click(object sender, EventArgs e) { AcademicQualificationModel acad_qualification = new AcademicQualificationModel() { CourseType = CourseSpecializationTextBox.Text, Specialization = CourseSpecializationTextBox.Text, GraduationDate = GraduationDateTextBox.Text }; EmployeeDataAccessLayer employeeDataAccessLayer = new EmployeeDataAccessLayer(); employeeDataAccessLayer.UpdateAcademicQualification(acad_qualification); }
private void SearchButton_Click(object sender, EventArgs e) { EmployeeID = SearchIDTextBox.Text.ToString(); try { EmployeeDataAccessLayer EmployeeDataAccessLayerObj = new EmployeeDataAccessLayer(); PersonalDetailsGridView.DataSource = EmployeeDataAccessLayerObj.ViewEmployeeData(EmployeeID); PersonalDetailsGridView.Columns.RemoveAt(0); for (int i = 0; i < PersonalDetailsGridView.ColumnCount; i++) { var cellValue = PersonalDetailsGridView.Rows[0].Cells[i].Value; if (cellValue == null) { PersonalDetailsGridView.Columns.RemoveAt(i); i = 0; } } CompanyDetailsGridView.DataSource = EmployeeDataAccessLayerObj.ViewCompanyData(EmployeeID); CompanyDetailsGridView.Columns.RemoveAt(0); for (int i = 0; i < CompanyDetailsGridView.ColumnCount; i++) { var cellValue = CompanyDetailsGridView.Rows[0].Cells[i].Value; if (cellValue == null) { CompanyDetailsGridView.Columns.RemoveAt(i); i = 0; } } ProjectDetailsGridView.DataSource = EmployeeDataAccessLayerObj.ViewProjectData(EmployeeID); ProjectDetailsGridView.Columns.RemoveAt(0); ProjectDetailsGridView.Columns.RemoveAt(0); for (int i = 0; i < ProjectDetailsGridView.ColumnCount; i++) { var cellValue = ProjectDetailsGridView.Rows[0].Cells[i].Value; if (cellValue == null) { ProjectDetailsGridView.Columns.RemoveAt(i); i = 0; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }