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