public void BindData(string sortDate, string sortType)
{
string strSeclctEmp = "";
if (txtSearchId.Text != "")
{
strSeclctEmp += "emp_id LIKE '%" + txtSearchId.Text.Trim() + "%' ";
}
if (txtSearchName.Text != "")
{
if (strSeclctEmp != "")
{
strSeclctEmp += " AND ";
}
strSeclctEmp += "(profix_name LIKE '%" + txtSearchName.Text.Trim() + "%' OR emp_name LIKE '%" + txtSearchName.Text.Trim() + "%' OR emp_lname LIKE '%" + txtSearchName.Text.Trim() + "%')";
}
if (txtSearchCpoint.SelectedValue != "")
{
if (strSeclctEmp != "")
{
strSeclctEmp += " AND ";
}
strSeclctEmp += "cpoint_name LIKE '%" + txtSearchCpoint.SelectedItem + "%' ";
}
if (txtSearchPos.SelectedValue != "")
{
if (strSeclctEmp != "")
{
strSeclctEmp += " AND ";
}
strSeclctEmp += "pos_name LIKE '%" + txtSearchPos.SelectedItem + "%' ";
}
if (txtSearchAffi.SelectedValue != "")
{
if (strSeclctEmp != "")
{
strSeclctEmp += " AND ";
}
strSeclctEmp += "affi_name LIKE '%" + txtSearchAffi.SelectedItem + "%' ";
}
if (strSeclctEmp != "")
{
strSeclctEmp = "(" + strSeclctEmp + ") AND ";
}
string sql = "SELECT * FROM tbl_emp_profile JOIN tbl_profix ON emp_profix_id = profix_id JOIN tbl_cpoint ON emp_cpoint_id = cpoint_id JOIN tbl_pos ON emp_pos_id = pos_id JOIN tbl_affiliation ON affi_id = emp_affi_id JOIN tbl_type_emp ON type_emp_id = emp_type_emp_id JOIN tbl_type_add ON type_add_id = emp_add_type WHERE " + strSeclctEmp + " emp_staus_working = '1' ORDER BY " + sortDate + " " + sortType + " LIMIT 0,20";
Session["sqlEmp"] = sql;
MySqlDataAdapter da = dbScript.getDataSelect(sql);
DataTable ds = new DataTable();
da.Fill(ds);
GridViewEmp.DataSource = ds;
GridViewEmp.DataBind();
LaGridViewData.Text = "พบข้อมูลจำนวน " + ds.Rows.Count + " แถว";
resultCard.Visible = true;
dbScript.CloseConnection();
}
private void ShowByID(int id)
{
try
{
clearFields();
//Se solicita desde capa negocio mediante la función ShowByID, los datos completos del empelado solicitado.
_empleado = _empleadoVerif.ShowByID(id);
if (_empleado != null)
{
GridViewEmp.DataSource = new Empleado[1] {
_empleado
};
GridViewEmp.DataBind();
GridViewEmp.Visible = true;
}
else
{
errorLabel.Text = "El empleado solicitado no existe";
}
}
catch (Exception ex)
{
errorLabel.Text = string.Format("Error: {0}", ex.Message);
}
}
protected void GV_Bind()
{
String ID_Emp_Login = (from p in db.AccountEmps
where p.Username == Request.Cookies["Username"].Value
select p.ID_Emp).Single();
GridViewEmp.DataSource = db.Employees.Select(p => p).Where(p => p.ID_Emp != ID_Emp_Login);
GridViewEmp.DataBind();
FormatSex();
}
protected void btnSearchClear_Click(object sender, EventArgs e)
{
txtSearchId.Text = "";
txtSearchName.Text = "";
txtSearchCpoint.SelectedIndex = 0;
txtSearchPos.SelectedIndex = 0;
txtSearchAffi.SelectedIndex = 0;
GridViewEmp.DataSource = null;
GridViewEmp.DataBind();
resultCard.Visible = false;
}
//Execute two select queries, and returns employees and country tables
protected void btnReturnDS_Click(object sender, EventArgs e)
{
// You can also use a stored procedure instead of two queries in one string variable
string sql = "SELECT * FROM Employees; SELECT * FROM Country";
DataSet ds = SqlHelper.ExecuteQueryDS(sql, CommandType.Text, null);
GridViewEmp.DataSource = ds.Tables[0];
GridViewEmp.DataBind();
GridViewCountry.DataSource = ds.Tables[1];
GridViewCountry.DataBind();
}
public void PopulateData()
{
try
{
DataSet ds = emp.ShowReportEmployee();
if (ds.Tables[0].Rows.Count != 0)
{
GridViewEmp.DataSource = ds.Tables[0];
GridViewEmp.DataBind();
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
private void SortGridView(string sortExpression, string direction)
{
MySqlDataAdapter da = dbScript.getDataSelect(Session["sqlEmp"].ToString());
ds = new DataTable();
da.Fill(ds);
DataTable dt = ds;
DataView dv = new DataView(dt);
//dv.Sort = "age asc";
dv.Sort = sortExpression + " " + direction;
this.GridViewEmp.DataSource = dv;
GridViewEmp.DataBind();
dbScript.CloseConnection();
}
// Execute two select queries, and returns employees and country tables
protected void btnReturnDS_Click(object sender, EventArgs e)
{
// make sure parameter name of Cursor (CurEmp and CurCountry ) same as the name in the oracle PACKAGE
string PKG_SP_Name = "GET_MULTIPLE_TABLES.GET_TABLES";
OracleParameter[] parametersList = new OracleParameter[] {
new OracleParameter("CurEmp", OracleDbType.RefCursor, ParameterDirection.Output),
new OracleParameter("CurCountry", OracleDbType.RefCursor, ParameterDirection.Output),
};
DataSet ds = OracleHelper.ExecuteQueryDS(PKG_SP_Name, CommandType.StoredProcedure, parametersList);
GridViewEmp.DataSource = ds.Tables[0];
GridViewEmp.DataBind();
GridViewCountry.DataSource = ds.Tables[1];
GridViewCountry.DataBind();
}
public void BindData()
{
string sql = "SELECT * FROM tbl_emp_profile JOIN tbl_history ON id = history_emp_id JOIN tbl_profix ON profix_id=emp_profix_id JOIN tbl_status_working ON status_working_id = history_status_id WHERE emp_id_card = '" + txtSearchIDCard.Text.Trim() + "' ORDER BY history_id DESC";
MySqlDataAdapter da = dbScript.getDataSelect(sql);
DataSet ds = new DataSet();
da.Fill(ds);
GridViewEmp.DataSource = ds.Tables[0];
GridViewEmp.DataBind();
if (ds.Tables[0].Rows.Count != 0)
{
LaGridViewData.Text = "พบข้อมูลจำนวน " + ds.Tables[0].Rows.Count + " แถว";
}
else
{
LaGridViewData.Text = "ไม่พบข้อมูล";
}
resultCard.Visible = true;
}
//
//Metodos//
private void ShowAll()
{
errorLabel.Text = DefaultError;
clearFields();
List <Empleado> listaEmpleados = _empleadoVerif.returnAll();
if (listaEmpleados.Count > 0)
{
//Luego de obtener la lista actualizada de empleados, se carga la misma en GridView de interfaz
GridViewEmp.DataSource = listaEmpleados;
GridViewEmp.DataBind();
GridViewEmp.Visible = true;
}
else
{
//Se utiliza en este caso y durante toda interacción con usuario, un Label para comunicar errores y notificaciones pertinentes.
errorLabel.Text = "No existe ningun empleado cargado";
errorLabel.Visible = true;
}
}
protected void DropDownSelectionChangedEvnt(object sender, EventArgs e)
{
litHeader.Text = "Display Dept :" + DropDownListDeptName.SelectedItem.ToString() + " " + "DeptNO :" + DropDownListDeptName.SelectedItem.Value;
GridViewEmp.DataSource = deptrepo.GetEmployees(Convert.ToInt32(DropDownListDeptName.SelectedItem.Value));
GridViewEmp.DataBind();
}
public void getSeclctEmp(string sortDate, string sortType)
{
//System.Threading.Thread.Sleep(5000);
//DivLoad.Visible = true;
string strSeclctEmp = "";
if (txtSearchId.Text != "")
{
strSeclctEmp += "emp_id LIKE '%" + txtSearchId.Text.Trim() + "%' ";
}
if (txtSearchName.Text != "")
{
if (strSeclctEmp != "")
{
strSeclctEmp += " AND ";
}
strSeclctEmp += "(profix_name LIKE '%" + txtSearchName.Text.Trim() + "%' OR emp_name LIKE '%" + txtSearchName.Text.Trim() + "%' OR emp_lname LIKE '%" + txtSearchName.Text.Trim() + "%')";
}
if (txtSearchCpoint.SelectedValue != "")
{
if (strSeclctEmp != "")
{
strSeclctEmp += " AND ";
}
strSeclctEmp += "cpoint_id LIKE '" + txtSearchCpoint.SelectedValue + "%' ";
}
if (txtSearchPos.SelectedValue != "")
{
if (strSeclctEmp != "")
{
strSeclctEmp += " AND ";
}
strSeclctEmp += "pos_id = '" + txtSearchPos.SelectedValue + "' ";
}
if (txtSearchAffi.SelectedValue != "")
{
if (strSeclctEmp != "")
{
strSeclctEmp += " AND ";
}
strSeclctEmp += "affi_id = '" + txtSearchAffi.SelectedValue + "' ";
}
if (txtSearchType.SelectedValue != "")
{
if (strSeclctEmp != "")
{
strSeclctEmp += " AND ";
}
strSeclctEmp += "emp_type_emp_id = '" + txtSearchType.SelectedValue + "'";
}
if (strSeclctEmp != "")
{
strSeclctEmp = "(" + strSeclctEmp + ") AND ";
}
string sql = "SELECT * FROM tbl_emp_profile JOIN tbl_profix ON emp_profix_id = profix_id JOIN tbl_cpoint ON emp_cpoint_id = cpoint_id JOIN tbl_pos ON emp_pos_id = pos_id JOIN tbl_affiliation ON affi_id = emp_affi_id JOIN tbl_type_emp ON type_emp_id = emp_type_emp_id LEFT JOIN tbl_type_add ON type_add_id = emp_add_type WHERE " + strSeclctEmp + " emp_staus_working = '1' ORDER BY " + sortDate + " " + sortType;
Session["sqlEmp"] = sql;
MySqlDataAdapter da = dbScript.getDataSelect(sql);
ds = new DataTable();
da.Fill(ds);
GridViewEmp.DataSource = ds;
GridViewEmp.DataBind();
LaGridViewData.Text = "พบข้อมูลจำนวน " + ds.Rows.Count + " แถว";
if (GridViewEmp.DataSource != null)
{
DivEmp.Visible = true;
}
dbScript.CloseConnection();
//DivLoad.Visible = false;
}
protected void btnDisplayEmp_Click(object sender, EventArgs e)
{
GridViewEmp.DataSource = emprepo.GetEmployees();
GridViewEmp.DataBind();
}
