/// <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();
}
}
public ActionResult Edit(int ID)
{
EmployeeGrid emp = new EmployeeGrid();
try
{
string con = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
SqlConnection connection = new SqlConnection(con);
string query = "SELECT [ID],[Username],[EmailID],[Fname],[Mname],[Lname],[Phone],[City] FROM [dbo].[EmployeeDetails] where ID=" + ID + "";
SqlDataAdapter da = new SqlDataAdapter(query, connection);
DataTable dt = new DataTable();
da.Fill(dt);
ViewBag.EditDetails = dt;
//List<EmployeeGrid> list = new List<EmployeeGrid>();
//foreach (DataRow dr in dt.Rows)
//{
emp.ID = Convert.ToInt32(dt.Rows[0]["ID"]);
emp.Username = dt.Rows[0]["Username"].ToString();
emp.EmailID = dt.Rows[0]["EmailID"].ToString();
emp.Fname = dt.Rows[0]["Fname"].ToString();
emp.Mname = dt.Rows[0]["Mname"].ToString();
emp.Lname = dt.Rows[0]["Lname"].ToString();
emp.Phone = dt.Rows[0]["Phone"].ToString();
emp.City = dt.Rows[0]["City"].ToString();
// list.Add(emp);
//}
}
catch (Exception ex)
{
}
return(View("Edit", emp));
}
// GET: EmployeeGrid
public ActionResult Index()
{
try
{
string con = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
SqlConnection connection = new SqlConnection(con);
string query = "SELECT [ID],[Username],[EmailID],[Fname],[Mname],[Lname],[Phone],[City] FROM [dbo].[EmployeeDetails]";
SqlDataAdapter da = new SqlDataAdapter(query, connection);
DataTable dt = new DataTable();
da.Fill(dt);
List <EmployeeGrid> list = new List <EmployeeGrid>();
EmployeeGrid emp;
foreach (DataRow dr in dt.Rows)
{
emp = new EmployeeGrid();
emp.ID = Convert.ToInt32(dr["ID"]);
emp.Username = dr["Username"].ToString();
emp.EmailID = dr["EmailID"].ToString();
emp.Fname = dr["Fname"].ToString();
emp.Mname = dr["Mname"].ToString();
emp.Lname = dr["Lname"].ToString();
emp.Phone = dr["Phone"].ToString();
emp.City = dr["City"].ToString();
list.Add(emp);
}
return(View("Index", list));
}
catch (Exception ex)
{
throw;
}
}
private void addNew_Click(object sender, RoutedEventArgs e)
{
add_ButtonVisib();
ComEmplyeeID.ItemsSource = null;
EmployeeGrid.setIsEnabled(true, isEnabledExclusions);
EmployeeUC_State = State.createNew;
}
} //Chứa danh sách các họ tên được chọn, ngăn cách nhau bởi dấu phẩy
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
if (ChiChonMotCanBo)
{
EmployeeGrid.GetSelectionModel().Attributes.Add("SingleSelect", "true");
}
}
}
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();
}
} //Chứa danh sách các họ tên được chọn, ngăn cách nhau bởi dấu phẩy
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
// Set resource
wdChooseUser.Title = Resource.Get("WindowsChooseEmployeeTitle");
if (OnlyChooseOnePerson)
{
EmployeeGrid.GetSelectionModel().Attributes.Add("SingleSelect", "true");
}
}
}
private void makeChangesButton_Click(object sender, RoutedEventArgs e)
{
addFirstButton.Visibility = Visibility.Collapsed;
saveButton.Visibility = Visibility.Visible;
updateButton.Visibility = Visibility.Collapsed;
cancelButton.Visibility = Visibility.Visible;
deleteButton.Visibility = Visibility.Collapsed;
EmployeeGrid.setIsEnabled(true, isEnabledExclusions);
ComEmplyeeID.IsEnabled = false;
EmployeeUC_State = State.modify;
}
public Employee_UserControl()
{
InitializeComponent();
DataContext = UIEmployee;
ComEmplyeeCity.ItemsSource = from name in BE.CivicAddress.Cities
orderby name
select name;
ComEmplyeeEduc.ItemsSource = Enum.GetValues(typeof(BE.Education));
refreshComboBoxes();
EmployeeGrid.setIsEnabled(false, isEnabledExclusions); // set isEnabled to false on all controls except for ComEmplyeeID
}
private void restoreRegButtonVisib()
{
addFirstButton.Visibility = Visibility.Visible;
saveButton.Visibility = Visibility.Collapsed;
cancelButton.Visibility = Visibility.Collapsed;
deleteButton.Visibility = Visibility.Visible;
updateButton.Visibility = Visibility.Visible;
// set isEnabled to false on all controls
EmployeeGrid.setIsEnabled(false, isEnabledExclusions);
ComEmplyeeID.IsEnabled = true;
// refresh
refreshComboBoxes();
}
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();
}
}
} //Chứa danh sách các họ tên được chọn, ngăn cách nhau bởi dấu phẩy
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
if (ChiChonMotCanBo != null && ChiChonMotCanBo != false)
{
EmployeeGrid.GetSelectionModel().Attributes.Add("SingleSelect", "true");
}
if (DisplayWorkingStatus == WorkingStatus.DangLamViec)
{
cbLoaiNhanVien.Items.Add(new Ext.Net.ListItem()
{
Text = "Nhân viên đang làm việc",
Value = "False"
});
}
else if (DisplayWorkingStatus == WorkingStatus.DaNghiViec)
{
cbLoaiNhanVien.Items.Add(new Ext.Net.ListItem()
{
Text = "Nhân viên đã nghỉ việc",
Value = "True"
});
}
else
{
cbLoaiNhanVien.Items.Add(new Ext.Net.ListItem()
{
Text = "Nhân viên đã nghỉ việc",
Value = "True"
});
cbLoaiNhanVien.Items.Add(new Ext.Net.ListItem()
{
Text = "Nhân viên đang làm việc",
Value = "False"
});
}
// LoadDonVi();
}
}
/// <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(); }
}
private void repositoryItemButtonDEL_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (MessageBox.Show("Do you want to delete this?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
try
{
if (EmployeeGrid.GetFocusedRow() is Employees item)
{
using (UnitOfWork unitOfWork = new UnitOfWork())
{
unitOfWork.EmployeesRepo.Delete(item);
unitOfWork.Save();
}
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, exception.Message, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Remove row (incomplete and not MVVM)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ButtonCurrentRemove_OnClick(object sender, RoutedEventArgs e)
{
var selectedItem = EmployeeGrid.SelectedItem;
if (selectedItem != null)
{
var employee = EmployeeGrid.SelectedItem as Employees;
if (Question($"Remove {employee.TitleOfCourtesy} {employee.LastName} employee?"))
{
var employeeList = (List <Employees>)EmployeeGrid.ItemsSource;
EmployeeGrid.Items.Refresh();
employeeList.Remove(employee);
EmployeeGrid.Focus();
}
}
else
{
MessageBox.Show("No current employee");
}
}
protected void Page_Load(object sender, EventArgs e)
{
TestOne_SQLDataClass.getAllEmployees();
EmployeeGrid.DataSource = TestOne_SQLDataClass.tblEmployee;
EmployeeGrid.DataBind();
}
/// <summary>
/// Focus DataGrid, highlight first row
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void EmployeeGrid_OnLoaded(object sender, RoutedEventArgs e)
{
EmployeeGrid.MoveFocus(new TraversalRequest(FocusNavigationDirection.Next));
EmployeeGrid.Focus();
}
public void BindGrid()
{
EmployeeGrid.DataSource = objWebService.DispalyTable();
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();
}
}
