public List <clsEmpInfo> GetEmployee(string empname)
{
EmpInfoManager objEmpInfoMgr = new EmpInfoManager();
DataRow[] emprows = objEmpInfoMgr.SelectEmpNameWithID("").Select("EMPNAME like '%" + empname + "%'");
List <clsEmpInfo> emplist = new List <clsEmpInfo>();
int i = 0;
foreach (var item in emprows)
{
i++;
clsEmpInfo emp = new clsEmpInfo(item["EMPID"].ToString(), item["DesigName"].ToString(), item["EMPNAME"].ToString(), "", "", "", "", "",
"", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
"", "", "", "", "", "", "", "", "", "", "", "", "", "");
emp.DeptName = item["DeptName"].ToString();
emplist.Add(emp);
if (i > 100)
{
break;
}
}
return(emplist);
}
private void SaveData(string IsDelete)
{
try
{
MasterTablesManager MasMgr = new MasterTablesManager();
clsEmpInfo objEmpInfo = new clsEmpInfo(
txtEmpID.Text.ToString(),
ddlTitle.SelectedValue.ToString(),
txtFullName.Text.Trim(),
txtFirstName.Text.Trim(),
txtMiddleName.Text.Trim(),
txtLastName.Text.Trim(),
txtFatherName.Text.Trim(),
txtMotherName.Text.Trim(),
txtPreAddress.Text.Trim(),
txtPrePhone.Text.Trim(),
txtPreFax.Text.Trim(),
txtPerAddress.Text.Trim(),
txtPerPhone.Text.Trim(),
txtPerFax.Text.Trim(),
ddlPerDistrict.SelectedValue.ToString(),
ddlPerCountry.SelectedValue.ToString(),
ddlGender.SelectedValue.ToString(),
txtDob.Text.Trim(),
ddlReligion.SelectedValue.ToString(),
ddlBloodGroup.SelectedValue.ToString(),
ddlMaritalStatus.SelectedValue.ToString(),
txtMarriageDate.Text.Trim(),
txtNationality.Text.Trim(),
txtNationalId.Text.Trim(),
txtDOBId.Text.Trim(),
txtTINNo.Text.Trim(),
txtCircle.Text.Trim(),
txtZone.Text.Trim(),
txtPassportNo.Text.Trim(),
txtPassExpDate.Text.Trim(),
txtPasportIssOff.Text.Trim(),
txtSkypeID.Text.Trim(),
txtOffPhExt.Text.Trim(),
txtOfficeEmail.Text.Trim(),
txtCellPhone.Text.Trim(),
txtLandPhone.Text.Trim(),
txtPersonalEmail.Text.Trim(),
ddlHighestEdu.SelectedValue.ToString(),
ddlProffDegree.SelectedValue.ToString(),
ddlSpecialSkill.SelectedValue.ToString(),
chkIsRelativeSC.Checked == true ? "Y" : "N",
ddlRelation.SelectedValue.ToString(),
//chkIsSpectacled.Checked == true ? "Y" : "N",
txtLicenseNo.Text.Trim(),
txtLicenseExpDate.Text.Trim(),
hfEmpImage.Value.ToString(),
txtRelativeInfo.Text.Trim(),
ddlNature.SelectedValue.ToString(),
ddlPerDivision.SelectedValue.Trim(),
ddlPerUpazila.SelectedValue.Trim(),
ddlPerPS.SelectedValue.Trim(),
ddlPreDivision.SelectedValue.Trim(),
ddlPreDistrict.SelectedValue.Trim(),
ddlPreUpzilla.SelectedValue.Trim(),
ddlPrePS.SelectedValue.Trim(),
ddlSubject.SelectedValue.ToString(),
txtSSMMrNo.Text.Trim(),
txtSpouseName.Text.Trim(),
txtOldEmpID.Text.Trim()
);
// Upload Employee Image
if (hfIsUpadate.Value == "N")
{
this.UploadImage();
}
else
{
if (FileUpload1.HasFile && FileUpload1.PostedFile != null)
{
this.UploadImage();
}
else if (!string.IsNullOrEmpty(Session["imgByte"].ToString()))
{
imgByte = (byte[])Session["imgByte"];
}
}
// Upload Employee Signature Image
if (hfIsUpadate.Value == "N")
{
this.UploadSignImage();
}
else
{
if (FileUpload2.HasFile && FileUpload2.PostedFile != null)
{
this.UploadSignImage();
}
else if (!string.IsNullOrEmpty(Session["imgSignByte"].ToString()))
{
imgSignByte = (byte[])Session["imgSignByte"];
}
}
objEmpInfoMgr.InsertEmpInfo(objEmpInfo, hfIsUpadate.Value, IsDelete, imgByte, imgSignByte);
if (hfIsUpadate.Value == "N")
{
lblMsg.Text = "Record Saved Successfully";
}
else
{
lblMsg.Text = "Record Updated Successfully";
}
Common.EmptyTextBoxValues(this);
this.EntryMode(false);
}
catch (Exception ex)
{
lblMsg.Text = "";
throw (ex);
}
}
