public DataSet.DsPSMS.ST_STAFF_DATADataTable getAllStaffData(out string msg)
{
DataSet.DsPSMS.ST_STAFF_DATADataTable result = new DataSet.DsPSMS.ST_STAFF_DATADataTable();
try
{
salaryDB.Open();
result = salaryDB.selectAllStaffData();
if (result != null && result.Rows.Count > 0)
{
msg = result.Rows.Count + " user found";
}
else
{
result = null;
msg = "user not found";
}
}
catch
{
msg = "error has occure when insert data";
return(null);
}
finally
{
salaryDB.Close();
}
return(result);
}
public DataSet.DsPSMS.ST_STAFF_DATADataTable selectAllStaffData()
{
string query = "SELECT * FROM ST_STAFF_DATA ORDER BY STAFF_ID";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet.DsPSMS.ST_STAFF_DATADataTable dt = new DataSet.DsPSMS.ST_STAFF_DATADataTable();
da.Fill(dt);
return(dt);
}
public DataSet.DsPSMS.ST_STAFF_DATARow selectStaffByid(int id)
{
//conn.Open();
string query = "SELECT * FROM ST_STAFF_DATA WHERE STAFF_ID=" + id;
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet.DsPSMS.ST_STAFF_DATADataTable dt = new DataSet.DsPSMS.ST_STAFF_DATADataTable();
da.Fill(dt);
//return single row
return(dt[0]);
}
private void displayStaffData()
{
DataSet.DsPSMS.ST_STAFF_DATADataTable staffs = salarySerivce.getAllStaffData(out msg);
if (gvsalarylist.Columns.Count == 9)
{
gvsalarylist.Columns.Remove(gvsalarylist.Columns[8]);
}
if (staffs != null)
{
gvsalarylist.DataSource = staffs;
((BoundField)gvsalarylist.Columns[0]).DataField = "STAFF_ID";
((BoundField)gvsalarylist.Columns[1]).DataField = "STAFF_NAME";
((BoundField)gvsalarylist.Columns[2]).DataField = "SALARY";
gvsalarylist.DataBind();
}
}
public DataSet.DsPSMS.ST_STAFF_DATARow getStaffIdByid(int id)
{
DataSet.DsPSMS.ST_STAFF_DATARow resultData = new DataSet.DsPSMS.ST_STAFF_DATADataTable().NewST_STAFF_DATARow();
try
{
salaryDB.Open();
resultData = salaryDB.selectStaffByid(id);
}
catch
{
return(null);
}
finally
{
salaryDB.Close();
}
return(resultData);
}
