public string CheckDepartment(string EmpId)
{
ClsDb = new ClassDBInterface();
ClsDb.AddParams("@EmpId", @EmpId, SqlDbType.Int);
Ds = ClsDb.GetDataSet("Hrms_GetAllUserPermission_Kra", CommandType.StoredProcedure);
if (Ds.Tables.Count != 0)
{
if (Ds.Tables[0].Rows.Count != 0)
{
ReturnStatus = Ds.Tables[0].Rows[0][0].ToString();
}
else
{
ReturnStatus = "";
}
}
else
{
ReturnStatus = "";
}
return(ReturnStatus);
}
/// <summary>
/// this method using for get the student data.
/// </summary>
/// <returns>Return Student Datatable </returns>
public DataSet GetStudentData(int UserId, string StudentNo)
{
DataSet ds = new DataSet();
try
{
ClsDb = new ClassDBInterface();
ClsDb.AddParams("@UserId", UserId, SqlDbType.Int);
ClsDb.AddParams("@StudentId", StudentNo, SqlDbType.VarChar);
ds = ClsDb.GetDataSet("Sp_GetStudentDetails", CommandType.StoredProcedure);
}
catch (Exception)
{
}
return(ds);
}
/// <summary>
/// this method using for get the student data.
/// </summary>
/// <returns>Return Student Datatable </returns>
public DataSet GetStudentData(int UserId, string StudentNo)
{
DataSet ds = new DataSet();
try
{
ClsDb = new ClassDBInterface();
ClsDb.AddParams("@UserId", UserId, SqlDbType.Int);
ClsDb.AddParams("@StudentId", StudentNo, SqlDbType.VarChar);
ds = ClsDb.GetDataSet("Sp_GetStudentDetails", CommandType.StoredProcedure);
}
catch (Exception)
{
}
return ds;
}
public string CheckDepartment(string EmpId)
{
ClsDb = new ClassDBInterface();
ClsDb.AddParams("@EmpId", @EmpId, SqlDbType.Int);
Ds = ClsDb.GetDataSet("Hrms_GetAllUserPermission_Kra", CommandType.StoredProcedure);
if (Ds.Tables.Count != 0)
{
if (Ds.Tables[0].Rows.Count != 0)
{
ReturnStatus = Ds.Tables[0].Rows[0][0].ToString();
}
else
{ ReturnStatus = ""; }
}
else
{ ReturnStatus = ""; }
return ReturnStatus;
}