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; }