protected void btnSave_Click(object sender, EventArgs e)
{
DataTable dt = empf.CheckUser(txtUsername.Text);
if (txtPassword.Text == txtRePassword.Text)
{
if (dt.Rows.Count == 0)
{
int i = empf.CreateUser(ddlTitle.Text, Convert.ToInt32(txtEmployeeNo.Text), txtFirstName.Text, txtLastName.Text, radGender.Text, ddlCountry.Text, ddlCity.Text, txtPost.Text, txtTemporary.Text, txtPermanent.Text, Convert.ToDateTime(txtDateOfJoining.Text), Convert.ToDateTime(txtDateOfBirth.Text), txtTelephone.Text, txtMobile.Text, txtEmail.Text, Convert.ToDecimal(txtBasicSalary.Text), ddlContractPeriod.Text, ddlContractType.Text, chkAllpwBonus.Checked ? true : false, chkOt.Checked ? true : false, FileUpload1.FileName, chkIsActive.Checked ? true : false, txtUsername.Text, txtPassword.Text, txtRePassword.Text, ddlUsertype.Text);
if (i > 0)
{
FileUpload1.SaveAs(Server.MapPath("../Gallery/" + FileUpload1.FileName));
al.callAlert("success", "User", "Employee Created");
ClearGrid();
}
}
else if (dt.Rows.Count > 0)
{
al.callAlert("error", "FAIL", "User already exists");
}
}
else if (txtPassword.Text != txtRePassword.Text)
{
al.callAlert("warning", "FAIL", "Password Donot Match");
}
}
protected void ibtnSave_Click(object sender, ImageClickEventArgs e)
{
string empName = (txtFirstName.Text.Replace("'", "").Replace("\"", "").Trim() + " " + txtLastName.Text.Replace("'", "").Replace("\"", "").Trim());
string email = ((txtEmail.Text != "") ? (txtEmail.Text.Replace("'", "").Replace("\"", "")) + lblEmail.Text : "");
DateTime stDate = (txtBegin.Text != "") ? Convert.ToDateTime(txtBegin.Text) : DateTime.Now;
DateTime endDate = (txtEnd.Text != "") ? Convert.ToDateTime(txtEnd.Text) : DateTime.Now;
txtPhone.Text = RemovePhoneNumberFormat(txtPhone.Text.Replace("'", "").Trim());
txtFax.Text = RemovePhoneNumberFormat(txtFax.Text.Replace("'", "").Trim());
if (endDate >= stDate)
{
if (ViewState["Mode"].ToString() == "Add")
{
columnValue = "'" + empName + "'," +
"'" + ddlHireLocation.SelectedItem.Value.ToString() + "'," +
"'" + txtEmpNo.Text.Replace("'", "").Replace("\"", "") + "'," +
((ddlStatus.SelectedItem.Value.ToString() != "") ? ("'" + ddlStatus.SelectedItem.Value.ToString() + "'") : "NULL") + "," +
"'" + dtpHireDate.SelectedDate + "'," +
((ddlDepartment.SelectedItem.Value.ToString() != "") ? ddlDepartment.SelectedItem.Value.ToString() : "NULL") + "," +
"'" + ((ddlPosition.SelectedItem.Value.ToString() != "") ? ddlPosition.SelectedItem.Value.ToString() : "NULL") + "'," +
((ddlShift.SelectedItem.Value.ToString() != "") ? ("'" + ddlShift.SelectedItem.Value.ToString() + "'") : "NULL") + "," +
((ddlSupervisior.SelectedItem.Value.ToString() != "") ? ("'" + ddlSupervisior.SelectedItem.Value.ToString() + "'") : "NULL") + "," +
"'" + txtFirstName.Text.Replace("'", "").Replace("\"", "") + "'," +
"'" + txtMiddleName.Text.Replace("'", "").Replace("\"", "").Trim() + "'," +
"'" + txtLastName.Text.Replace("'", "").Replace("\"", "") + "'," +
((ddlSalutation.SelectedItem.Value.ToString() != "") ? ("'" + ddlSalutation.SelectedItem.Value.ToString().Trim() + "'") : "NULL") + "," +
"'" + email + "'," +
"'" + txtPhone.Text + "'," +
"'" + txtFax.Text + "'," +
"'" + ddlPayCode.SelectedItem.Value.ToString() + "'," +
"'" + txtPayrollEmpNo.Text.Replace("'", "").Replace("\"", "") + "'," +
"'" + ddlPayrollLoc.SelectedItem.Value.ToString() + "'," +
((txtHoliday.Text != "") ? txtHoliday.Text : "NULL") + "," +
((txtSick.Text != "") ? txtSick.Text : "NULL") + "," +
((txtVacation.Text != "") ? txtVacation.Text : "NULL") + "," +
"'" + txtBegin.Text + "'," +
"'" + txtEnd.Text + "'," +
"'" + txtAbsenceBal.Text + "'," +
"" + ((txtBalance.Text != "") ? txtBalance.Text : "NULL") + "," +
"'" + Session["UserName"].ToString() + "'," +
"'" + DateTime.Now.ToShortDateString() + "'," +
((ddlPosition.SelectedItem.Value.ToString().Trim().ToLower() == "supervisior") ? "'Y'" : "NULL"); // +"'";
string whereClause = "EmployeeName='" + empName + "' and DeleteDt is null";
bool checkUser = employee.CheckUser(whereClause);
bool checkUserID = employee.CheckUserID(txtEmpNo.Text.Trim());
Label lbl = Page.FindControl("lblMessage") as Label;
if (checkUser)
{
employee.DisplayMessage(MessageType.Failure, "Employee Name already exists", lbl);
UpdatePanel pnl = Page.FindControl("upnlMessage") as UpdatePanel;
pnl.Update();
status = "Failure";
}
else if (checkUserID)
{
employee.DisplayMessage(MessageType.Failure, "Employee No. already exists", lbl);
UpdatePanel pnl = Page.FindControl("upnlMessage") as UpdatePanel;
pnl.Update();
status = "Failure";
}
else
{
string _empID = employee.InsertEmployeeData(columnValue);
ViewState["EmpID"] = _empID;
status = "NewEmployeeSuccess";
string userSettingcolumnValue = "'" + ddlHireLocation.SelectedItem.Text.ToString().Split('-')[1].ToString().Trim() + "'," +
"'" + ddlHireLocation.SelectedItem.Value.ToString() + "'," +
"'" + _empID + "'," +
"'" + Session["UserName"].ToString() + "'," +
"'" + DateTime.Now.ToShortDateString() + "'";
UserID = employee.InsertUserData(userSettingcolumnValue);
ViewState["UserID"] = UserID.ToString();
EmployeeName = empName;
ViewState["Mode"] = "Save";
}
}
else
{
string empID = ViewState["EmpID"].ToString();
string updateValue = "EmployeeName='" + empName.Trim() + "'," +
"Location='" + ddlHireLocation.SelectedItem.Value.ToString() + "'," +
"EmployeeNo='" + txtEmpNo.Text.Replace("'", "").Replace("\"", "") + "'," +
"EmploymentStatus=" + ((ddlStatus.SelectedItem.Value.ToString() != "") ? ("'" + ddlStatus.SelectedItem.Value.ToString() + "'"): "NULL") + "," +
"HireDt='" + dtpHireDate.SelectedDate + "'," +
"DepartmentNo=" + ((ddlDepartment.SelectedItem.Value.ToString() != "") ? ddlDepartment.SelectedItem.Value.ToString() : "NULL") + "," +
"DefaultJobCd=" + ((ddlPosition.SelectedItem.Value.ToString() != "") ? ("'" + ddlPosition.SelectedItem.Value.ToString() + "'") : "NULL") + "," +
"Shift='" + ddlShift.SelectedItem.Value.ToString() + "'," +
"SupervisorEmpID=" + ((ddlSupervisior.SelectedItem.Value.ToString() != "") ? ddlSupervisior.SelectedItem.Value.ToString() : "NULL") + "," +
"SupervisorInd='" + ((ddlPosition.SelectedItem.Value.ToString().Trim().ToLower() == "supervisior") ? "Y" : "") + "'," +
"FirstName='" + txtFirstName.Text.Replace("'", "").Replace("\"", "") + "'," +
"MiddleInitial='" + txtMiddleName.Text.Replace("'", "").Replace("\"", "") + "'," +
"LastName='" + txtLastName.Text.Replace("'", "").Replace("\"", "") + "'," +
"Salutation=" + ((ddlSalutation.SelectedItem.Value.ToString() != "")?("'" + ddlSalutation.SelectedItem.Value.ToString() + "'"):"NULL") + "," +
"EmailAddress='" + email + "'," +
"PhoneNo='" + txtPhone.Text + "'," +
"FaxNo='" + txtFax.Text + "'," +
"PayCd='" + ddlPayCode.SelectedItem.Value.ToString() + "'," +
"PayRollEmployeeNo='" + txtPayrollEmpNo.Text.Replace("'", "").Replace("\"", "") + "'," +
"PayRollLocation=" + ((ddlPayrollLoc.SelectedItem.Value.ToString() != "")?("'" + ddlPayrollLoc.SelectedItem.Value.ToString() + "'"):"NULL") + "," +
"HolidayHours=" + ((txtHoliday.Text != "") ? txtHoliday.Text : "NULL") + "," +
"SickHours=" + ((txtSick.Text != "") ? txtSick.Text : "NULL") + "," +
"VacationHours=" + ((txtVacation.Text != "") ? txtVacation.Text : "NULL") + "," +
"LeaveBeginDt='" + txtBegin.Text + "'," +
"LeaveEndDt='" + txtEnd.Text + "'," +
"LeaveBalanceDt='" + txtAbsenceBal.Text + "'," +
"BenefitBalance=" + ((txtBalance.Text != "") ? txtBalance.Text : "NULL") + "," +
"ChangeID='" + Session["UserName"].ToString() + "'," +
"ChangeDt='" + DateTime.Now.ToShortDateString() + "'";
employee.UpdateEmployeeData(updateValue, empID);
int userID = Convert.ToInt32((employee.GetUserIDByEmployeeID(empID)));
ViewState["UserID"] = userID.ToString();
string userSettingColumnValue = " Location='" + ddlHireLocation.SelectedItem.Text.ToString() + "'," +
"IMLoc='" + ddlHireLocation.SelectedItem.Value.ToString() + "'";
employee.UpdateUserData(userSettingColumnValue, userID.ToString());
status = "Success";
EmpLocation = (ddlHireLocation.SelectedItem.Value.ToString()) + "-" + (ddlHireLocation.SelectedItem.Text.ToString());
EmployeeName = empName;
ViewState["Mode"] = "Save";
}
}
else
{
Label lbl = Page.FindControl("lblMessage") as Label;
employee.DisplayMessage(MessageType.Failure, "End Date must be greater than Start Date", lbl);
UpdatePanel pnl = Page.FindControl("upnlMessage") as UpdatePanel;
pnl.Update();
txtEnd.Text = "";
// ClearControl();
status = "Failure";
}
}