public string[] createStaffMeritDataBase(List<string> MeritData, int Grade, string sID, int sUnit)
{
StaffDataBase sDB = new StaffDataBase();
sDB.personnelFunction();
if (int.Parse(sDB._StaffhaveRoles[2]) == 1)
{
return sDB.createStaffMeritDataBase(MeritData, Grade, sID, sUnit);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] createStaffWorkData(staffWorkData WorkData)
{
StaffDataBase sDB = new StaffDataBase();
sDB.personnelFunction();
if (int.Parse(sDB._StaffhaveRoles[2]) == 1)
{
return sDB.createStaffWorkData(WorkData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] setStaffMeritDataBase(Int64 TrID, int Grade, List<string> MeritData)
{
StaffDataBase sDB = new StaffDataBase();
sDB.personnelFunction();
if (int.Parse(sDB._StaffhaveRoles[1]) == 1)
{
return sDB.setStaffMeritDataBase(TrID, Grade, MeritData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] createStaffCreditDataBase(CreateStaffUpgrade StaffUpgradeData)
{
StaffDataBase sDB = new StaffDataBase();
sDB.personnelFunction();
//return new string[2] { "", "" };
if (int.Parse(sDB._StaffhaveRoles[2]) == 1)
{
return sDB.createStaffCreditData(StaffUpgradeData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] setNewTeacherDataBase(CreateNewTeacher NewTeacherData)
{
StaffDataBase sDB = new StaffDataBase();
sDB.personnelFunction();
if (int.Parse(sDB._StaffhaveRoles[1]) == 1)
{
return sDB.setNewTeacherDataBase(NewTeacherData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] setStaffCreditParticipantDataBase(string cID, List<string> DelParticipantsID, List<string> NewParticipantsValue)
{
StaffDataBase sDB = new StaffDataBase();
sDB.personnelFunction();
if (int.Parse(sDB._StaffhaveRoles[1]) == 1)
{
return sDB.setStaffCreditParticipantDataBase(cID, DelParticipantsID, NewParticipantsValue);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] SearchTeacherRstimateDataBaseCount(SearchTeacherRstimate SearchTeacher)
{
StaffDataBase sDB = new StaffDataBase();
sDB.personnelFunction();
if (int.Parse(sDB._StaffhaveRoles[3]) == 1)
{
return sDB.SearchTeacherRstimateDataBaseCount(SearchTeacher);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public string[] SearchStaffMeritDataBaseCount(SearchStaff SearchStaffMeritCondition)
{
StaffDataBase sDB = new StaffDataBase();
sDB.personnelFunction();
if (int.Parse(sDB._StaffhaveRoles[3]) == 1)
{
return sDB.SearchStaffMeritDataBaseCount(SearchStaffMeritCondition);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public StaffResult getOneStaffDataBase(string sID)
{
StaffDataBase sDB = new StaffDataBase();
sDB.personnelFunction();
StaffResult returnValue = new StaffResult();
if (int.Parse(sDB._StaffhaveRoles[3]) == 1)
{
returnValue=sDB.getOneStaffDataBase(sID);
}
else
{
returnValue.checkNo = _noRole;
returnValue.errorMsg = _errorMsg;
}
List<string> UserFile = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
if (returnValue.StaffBaseData.unit != UserFile[2] && int.Parse(sDB._StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0)
{
returnValue.checkNo = _getcheckNo;
returnValue.errorMsg = _errorMsg;
}
return returnValue;
}
public CreateNewTeacher getNewTeacherDataBase(string tID)
{
StaffDataBase sDB = new StaffDataBase();
CreateNewTeacher returnValue = new CreateNewTeacher();
sDB.personnelFunction();
if (int.Parse(sDB._StaffhaveRoles[3]) == 1)
{
returnValue=sDB.getNewTeacherDataBase(tID);
}
else
{
returnValue.checkNo = _noRole;
returnValue.errorMsg = _errorMsg;
}
List<string> UserFile = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
if (returnValue.Unit != UserFile[2] && int.Parse(sDB._StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0)
{
returnValue.checkNo = _getcheckNo;
returnValue.errorMsg = _errorMsg;
}
return returnValue;
}
public List<StaffDataList> getAllStaffDataList(List<int> WorkItem)
{
List<StaffDataList> returnValue = new List<StaffDataList>();
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
Sqlconn.Open();
string itemStr = "";
if (WorkItem.Count > 0)
{
foreach (int item in WorkItem)
{
if (item != 0)
{
if (itemStr.Length > 0)
{
itemStr += " OR ";
}
itemStr += " WorkItem= " + item;
}
}
if (itemStr.Length > 0) {
itemStr = " AND ( " + itemStr + " ) ";
}
}
StaffDataBase sDB = new StaffDataBase();
sDB.personnelFunction();
List<string> UserFile = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
if (int.Parse(sDB._StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0)
{
itemStr += " AND Unit =" + UserFile[2] + " ";
}
List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
string sql = "SELECT * FROM StaffDatabase WHERE isDeleted=0 and ResignationDate = '1900-01-01' " + itemStr + "order by StaffID ASC";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@Unit", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[2].ToString());
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
StaffDataList addValue = new StaffDataList();
addValue.sID = dr["StaffID"].ToString();
addValue.sName = dr["StaffName"].ToString();
addValue.sEmail = dr["Email"].ToString();
addValue.sUnit = dr["Unit"].ToString();
returnValue.Add(addValue);
}
dr.Close();
Sqlconn.Close();
}
catch (Exception e)
{
StaffDataList addValue = new StaffDataList();
addValue.checkNo = "-1";
addValue.errorMsg = e.Message;
returnValue.Add(addValue);
}
}
return returnValue;
}