/// <summary>
/// Name:Bindgrid
/// Description:Bind the grid if datatable is blank then it displays message in label
/// Author:Monal Shah
/// created Date:2010/11/26
/// </summary>
public void BindGrid()
{
try
{
objcl.GetSqlStmt = objcl.SelectQuery("Employees");
objDt = objcl.DataTables();
if (objDt.Rows.Count > 0)
{
EmployeeGrid.DataSource = objDt;
EmployeeGrid.DataBind();
}
else
{
LblMsg.Visible = true;
LblMsg.Text = ConstantMessage.NoRecord;
EmployeeGrid.Visible = false;
BtnExportToExcel.Visible = false;
FileUpload.Enabled = false;
BtnFileUpload.Enabled = false;
}
}
catch (Exception)
{ Response.Redirect("Error.aspx", false); }
finally
{
objcl = null;
objDt.Dispose();
}
}
/// <summary>
/// Name:EmployeeGrid_PageIndexChanging
/// Description:here pageindex is set and data is bind the grid
/// Author:Monal Shah
/// created Date:2010/10/21
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EmployeeGrid_PageIndexChanging(object sender, System.Web.UI.WebControls.GridViewPageEventArgs e)
{
EmployeeGrid.PageIndex = e.NewPageIndex;
objDv = SortDataTable(true);
EmployeeGrid.DataSource = objDv;
EmployeeGrid.DataBind();
}
private void UpdateDataGrid()
{
using (HREntities hr = new HREntities())
{
// Membuat Data Table untuk dijadikan DataSource GridView
DataTable dataTable = new DataTable("employee");
// Menambahkan colum/field ke Data Table
dataTable.Columns.Add("EmployeeId");
dataTable.Columns.Add("FirstName");
dataTable.Columns.Add("LastName");
dataTable.Columns.Add("Email");
// Mengambil data Employee untuk dimasukan ke dalam Data Table
List <COPY_EMP> employees = (from COPY_EMP emp in hr.COPY_EMP
select emp).ToList();
foreach (COPY_EMP emp in employees)
{
dataTable.Rows.Add(emp.EMPLOYEE_ID, emp.FIRST_NAME, emp.LAST_NAME, emp.EMAIL);
}
// Set DataSource GridView
EmployeeGrid.DataSource = dataTable;
EmployeeGrid.DataBind();
}
}
private void BindDummyRow()
{
DataTable dummy = new DataTable();
dummy.Columns.Add("ID");
dummy.Columns.Add("EmployeeIdent");
dummy.Columns.Add("FirstName");
dummy.Columns.Add("LastName");
dummy.Rows.Add();
EmployeeGrid.DataSource = dummy;
EmployeeGrid.DataBind();
}
private void GetAllEmployees()
{
try
{
if (EmployeeDataAccess.GetAllUsers() == null)
{
lblEmployee.Text = "Some error occored";
}
EmployeeGrid.DataSource = EmployeeDataAccess.GetAllUsers();
EmployeeGrid.DataBind();
}
catch (Exception ex)
{
lblEmployee.Text = ex.Message;
}
}
public void FillEmployeeData()
{
try
{
int ServiceTypeID = Convert.ToInt32(drpServiceTypeFilter.SelectedValue);
String EmployeeName = txtEmployeeFilter.Text.ToString();
Resident res = new Resident();
DataSet ds = res.GetEmployee(muser.currentResident.SocietyID, ServiceTypeID, EmployeeName);
if (ds.Tables.Count > 0)
{
EmployeeGrid.DataSource = ds;
EmployeeGrid.DataBind();
// btnEmpShwall.Visible = false;
//String EmpTotalCountQuery = " select count(UserID) from dbo.ViewEmployee where SocietyID = " + muser.currentResident.SocietyID.ToString();
//lblTotalEmployees.Text = daAccess.GetSingleValue(EmpTotalCountQuery).ToString();
// lblTotalEmployees.Text = ds.Tables[0].Rows.Count.ToString();
if (ds.Tables[0].Rows.Count == 0)
{
// txtEmpNamesrch.Visible = false;
// drpEmpServtFilter.Visible = false;
}
else
{
// txtEmpNamesrch.Visible = true;
drpServiceTypeFilter.Visible = true;
}
}
else
{
}
//ClientScript.RegisterStartupScript(this.GetType(), "alert('')", "ShowEmployePopup();", true);
}
catch (Exception ex)
{
}
}
private void Search(string date, string fromDate, string toDate, string keywords)
{
EmployeeFilterBuilder employeeFilterBuilder = new EmployeeFilterBuilder();
if (!string.IsNullOrEmpty(keywords))
{
employeeFilterBuilder.Append(EmployeeDB.BLL.EmployeeColumn.FullName, $"%{keywords}%", true);
}
if (!string.IsNullOrEmpty(date))
{
DateTime.TryParse(date, out DateTime dateResult);
employeeFilterBuilder.AppendEquals(EmployeeColumn.DOB, dateResult.ToString("yyyy-MM-dd"));
}
//if (!string.IsNullOrEmpty(fromDate))
//{
// DateTime.TryParse(fromDate, out DateTime fromDateResult);
// employeeFilterBuilder.AppendGreaterThan(EmployeeColumn.DOB, fromDateResult.ToShortDateString());
//}
//if (!string.IsNullOrEmpty(toDate))
//{
// DateTime.TryParse(toDate, out DateTime toDateResult);
// employeeFilterBuilder.AppendLessThan(EmployeeColumn.DOB, toDateResult.ToShortDateString());
// employeeFilterBuilder.AppendIn(EmployeeColumn.DOB, toDateResult.ToShortDateString());
//}
//employeeFilterBuilder.Append(EmployeeColumn.DOB, "London, Berlin");
//employeeFilterBuilder.Append(EmployeeColumn.DOB, fromDate.ToString(), toDate.ToString());
int count = 0;
EmployeeService employeeService = new EmployeeService();
TList <Employee> employees = DataRepository.EmployeeProvider.GetPaged(employeeFilterBuilder.ToString(), null, 0, 100, out count);
employeeService.DeepLoad(employees);
List <EmployeeModel> addressModels = new List <EmployeeModel>();
foreach (var employee in employees)
{
var employeeModel = new EmployeeModel(employee.EmployeeId, employee.EmployeeCode, employee.FullName, employee.FirstName, employee.MiddlesName,
employee.LastName, employee.DOB, employee.Email, employee.Bio, employee.CreatedOn, employee.AddressCollection);
addressModels.Add(employeeModel);
}
//EmployeeGrid.DataSource = addressModels.OrderByDescending(e => e.CreatedOn).ToList();
EmployeeGrid.DataSource = addressModels;
EmployeeGrid.DataBind();
}
private void FillGridView()
{
EmployeeService employeeService = new EmployeeService();
var employees = employeeService.GetAll();
employeeService.DeepLoad(employees);
List <EmployeeModel> addressModels = new List <EmployeeModel>();
foreach (var employee in employees)
{
var employeeModel = new EmployeeModel(employee.EmployeeId, employee.EmployeeCode, employee.FullName, employee.FirstName, employee.MiddlesName,
employee.LastName, employee.DOB, employee.Email, employee.Bio, employee.CreatedOn, employee.AddressCollection);
addressModels.Add(employeeModel);
}
//EmployeeGrid.DataSource = addressModels.OrderByDescending(e => e.CreatedOn).ToList();
EmployeeGrid.DataSource = addressModels;
EmployeeGrid.DataBind();
}
private void UpdateDataGrid()
{
using (ChasierCRUD chasierCRUD = new ChasierCRUD())
{
DataTable data = new DataTable("employee");
data.Columns.Add("EmployeeId");
data.Columns.Add("FirstName");
data.Columns.Add("LastName");
data.Columns.Add("Email");
List <Chasier> cs = chasierCRUD.SelectEmployees();
foreach (Chasier emp in cs)
{
data.Rows.Add(emp.Id_Item, emp.Nama_Item, emp.Kode_Item, emp.Harga_Item);
}
EmployeeGrid.DataSource = data;
EmployeeGrid.DataBind();
}
}
/// <summary>
/// Name:BtnDisplay_Click
/// Decription:Display record of that employee which is selected from dropdownlist.
/// Author:Monal shah
/// Created Date:2010/11/11
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnDisplay_Click(object sender, EventArgs e)
{
try
{
if (Cache[DdlEmployee.SelectedItem.Text] == null)
{
BindGrid();
}
else
{
PanelGrid.Visible = true;
EmployeeGrid.Visible = true;
objDt = (DataTable)Cache[DdlEmployee.SelectedItem.Text];
EmployeeGrid.DataSource = objDt;
EmployeeGrid.DataBind();
}
}
catch (Exception)
{ Response.Redirect("Error.aspx", false); }
finally
{ objDt.Dispose(); }
}
public void BindGrid()
{
EmployeeGrid.DataSource = objWebService.DispalyTable();
EmployeeGrid.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
TestOne_SQLDataClass.getAllEmployees();
EmployeeGrid.DataSource = TestOne_SQLDataClass.tblEmployee;
EmployeeGrid.DataBind();
}
/// <summary>
/// Name:BtnSearch_Click
/// Description:Serching criteria set
/// Author Name:Monal shah
/// Created Date:2010/11/2
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnSearch_Click(object sender, EventArgs e)
{
PnlGrid.Visible = true;
objSb = new StringBuilder();
try
{
objSb.Append("Select ");
objSb.Append("* ");
objSb.Append("From ");
objSb.Append("EmployeeTable ");
objSb.Append("Where ");
if (TxtFirstName.Text != null && TxtFirstName.Text != "")
{
objSb.Append("FirstName ");
objSb.Append("LIKE ");
objSb.Append("'");
objSb.Append(TxtFirstName.Text);
objSb.Append("%");
objSb.Append("'");
objSb.Append(" AND ");
}
if (TxtLastName.Text != null && TxtLastName.Text != "")
{
objSb.Append("LastName ");
objSb.Append("LIKE ");
objSb.Append("'");
objSb.Append(TxtLastName.Text);
objSb.Append("%");
objSb.Append("'");
objSb.Append(" AND ");
}
if (TxtAge.Text != null && TxtAge.Text != "")
{
objSb.Append("age");
objSb.Append("=");
objSb.Append("'");
objSb.Append(TxtAge.Text);
objSb.Append("'");
objSb.Append(" AND ");
}
if (RdbtnSex.SelectedIndex > -1 && RdbtnSex.SelectedItem.Selected)
{
objSb.Append("Sex");
objSb.Append("=");
objSb.Append("'");
objSb.Append(RdbtnSex.SelectedValue);
objSb.Append("'");
objSb.Append(" AND ");
}
if (DdlEducation.SelectedIndex > -1 && DdlEducation.SelectedItem.Text != ConstantMessage.EducationSelect)
{
objSb.Append("Education");
objSb.Append("=");
objSb.Append("'");
objSb.Append(DdlEducation.SelectedItem.Value);
objSb.Append("'");
objSb.Append(" AND ");
}
if (DdlExperience.SelectedIndex > -1 && DdlExperience.SelectedItem.Text != ConstantMessage.ExperienceSelect)
{
objSb.Append("Experience");
objSb.Append("=");
objSb.Append("'");
objSb.Append(DdlExperience.SelectedItem.Value);
objSb.Append("'");
objSb.Append(" AND ");
}
if (DdlSalary.SelectedIndex > -1 && DdlSalary.SelectedItem.Text != ConstantMessage.SalarySelect)
{
splitValue = DdlSalary.SelectedItem.Value.Split('-');
objSb.Append("Salary");
objSb.Append(">=");
objSb.Append(splitValue[0].ToString());
objSb.Append(" And ");
objSb.Append("Salary");
objSb.Append("<");
objSb.Append(splitValue[1].ToString());
objSb.Append(" AND ");
}
strRemove = Convert.ToString(objSb);
strGetProperValue = strRemove.Substring(0, strRemove.Length - 4);
objCl.GetSqlStmt = strGetProperValue.ToString();
objDt = objCl.DataTables();
if (objDt.Rows.Count > 0)
{
EmployeeGrid.Visible = true;
EmployeeGrid.DataSource = objDt;
EmployeeGrid.DataBind();
LblNoRecord.Visible = false;
}
else
{
LblNoRecord.Visible = true;
LblNoRecord.Text = ConstantMessage.NoRecord;
EmployeeGrid.Visible = false;
}
}
catch (Exception)
{
Response.Redirect("Error.aspx", false);
}
finally
{
objCl = null;
objSb = null;
objDt.Dispose();
}
}
