public bool deleteSignature(Int64 codeUser, int userRole, int hrID)
{
try
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
bool signatureExist = false;
DataTable dtSignature = getSignature(hrID, userRole);
if (dtSignature.Rows.Count != 1)
{
return(false);
}
signatureExist = dtSignature.Rows[0]["signature"] != DBNull.Value;
if (signatureExist)
{
return(dao.deleteSignature(codeUser, userRole));
}
}
catch (Exception ex)
{
return(false);
}
return(false);
}
public DataTable getAllAgreement_Status()
{
DataTable dt = new DataTable();
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
dt = dao.getAllAgreementsStatus();
return(dt);
}
public DataTable getSignature_Status()
{
DataTable dt = new DataTable();
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
dt = dao.getSignaturesStatus();
return(dt);
}
/// <summary>
///
/// </summary>
/// <param name="codeUser">کد کاربر یا کد استاد در سیدا</param>
/// <param name="userRole">برای استاد 1 و برای کاربر کد نقش</param>
/// <param name="signaturePath"></param>
/// <param name="hrID">برای کاربر برابر 0</param>
/// <returns></returns>
public bool UpdateOrInsertSignature(int codeUser, int userRole, string signaturePath, int hrID)
{
try
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
bool signatureExist = false;
DataTable dtSignature = getSignature(hrID, userRole);
if (dtSignature.Rows.Count != 1)
{
return(false);
}
signatureExist = dtSignature.Rows[0]["signature"] != DBNull.Value;
switch (signatureExist)
{
case true: //Update
#region
switch (userRole)
{
case 1:
return(dao.updateTeacherSignature(hrID, signaturePath));
case (int)DTO.RoleEnums.سرپرست_واحد: //سرپرست دانشگاه
case (int)DTO.RoleEnums.مدیر_امور_کارگزینی_هیئت_علمی: //پاراف سمت راست
case (int)DTO.RoleEnums.مسئول_حق_التدریس: //پاراف سمت چپ
case (int)DTO.RoleEnums.مسئول_کارگزینی_هیات_علمی: //پاراف سمت چپ
return(dao.updateUserSignature(codeUser, signaturePath, userRole));
}
#endregion
break;
case false: //Insert
#region
switch (userRole)
{
case 1:
return(dao.InsertTeacherSignature(codeUser, signaturePath, hrID));
case (int)DTO.RoleEnums.سرپرست_واحد: //سرپرست دانشگاه
case (int)DTO.RoleEnums.مدیر_امور_کارگزینی_هیئت_علمی: //پاراف سمت راست
case (int)DTO.RoleEnums.مسئول_حق_التدریس: //پاراف سمت چپ
case (int)DTO.RoleEnums.مسئول_کارگزینی_هیات_علمی: //پاراف سمت چپ
return(dao.InsertUserSignature(codeUser, signaturePath, userRole));
}
#endregion
break;
}
}
catch (Exception ex)
{
return(false);
}
return(false);
}
public bool rejectTeacherContract(int codeOstad, string descriptionOfReject, string term = "this")
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
DataTable dtContract = getContractOfTeacher(codeOstad, term);
if (dtContract.Rows.Count == 1)
{
if (dtContract.Rows[0]["contractFile"] != DBNull.Value)
{
return(dao.updateTeacherContractStatus(term, codeOstad, 4, dtContract.Rows[0]["contractFile"].ToString(), descriptionOfReject));
}
}
return(false);
}
public bool insertTeacherContract(int codeOstad, string contractFile, int hrID, string term, out int contractId)
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
DataTable dtGetContract = getContractByStatus(4, term);
DataRow[] dr = dtGetContract.Select("hrID=" + hrID);
if (dr.Length == 0)
{
return(dao.insertTeacherContract(codeOstad, contractFile, hrID, term, out contractId));
}
else
{
return(UpdateTeacherContractAfterReject(hrID, contractFile, term, out contractId));
}
}
public DataTable getAllContracts_Status(string term = "this")
{
DataTable dt = new DataTable();
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
if (term.Length > 4 || term == "this")
{
dt = dao.getAllContractStatus(term);
}
else
{
dt = dao.getAllContractStatus_HOD(term);
}
return(dt);
}
public bool rejectTeacherAgreement(Int64 codeOstad, string descriptionOfReject, out int agreementID)
{
agreementID = 0;
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
DataTable dtAgreement = getAgreementOfTeacher(codeOstad);
if (dtAgreement.Rows.Count == 1)
{
if (dtAgreement.Rows[0]["agreementFile"] != DBNull.Value)
{
return(dao.updateTeacherAgreementStatus(codeOstad, 3, dtAgreement.Rows[0]["AgreementFile"].ToString(), out agreementID, descriptionOfReject));
}
}
return(false);
}
public bool insertTeacherAgreement(int codeOstad, string agreementFile, int hrID, out int agreementID)
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
DataTable dtGetAgreement = getAgreementByStatus(3);
DataRow[] dr = dtGetAgreement.Select("hrID=" + hrID);
if (dr.Length == 0)
{
return(dao.insertTeacherAgreement(codeOstad, agreementFile, hrID, out agreementID));
}
else
{
return(UpdateTeacherAgreementAfterReject(hrID, agreementFile, out agreementID));
}
}
public bool ChangeContractStatusToLastStep(int codeOstad, int userRole, string term = "this")
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
DataTable dtContract = getContractOfTeacher(codeOstad, term);
if (dtContract.Rows.Count == 1)
{
if (dtContract.Rows[0]["contractFile"] != DBNull.Value)
{
switch (userRole)
{
case (int)DTO.RoleEnums.مدیر_امور_کارگزینی_هیئت_علمی:
return(dao.updateTeacherContractStatus(term, codeOstad, 0, dtContract.Rows[0]["contractFile"].ToString()));
}
}
}
return(true);
}
/// <summary>
///
/// </summary>
/// <param name="hrID">استاد: کد اچ آر - کاربر: هر عددی</param>
/// <param name="userLevel">استاد:1 - سرپرست دانشگاه:77 - مسئول کارگزینی:11 - کارشناس کارگزینی:12</param>
/// <returns></returns>
public DataTable getSignature(int hrID, int userRole)
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
DataTable dt = new DataTable();
switch (userRole)
{
case 1:
dt = dao.getTeacherSignature(hrID);
//get Teacher signature
break;
case (int)DTO.RoleEnums.سرپرست_واحد: //سرپرست دانشگاه
case (int)DTO.RoleEnums.مدیر_امور_کارگزینی_هیئت_علمی: //پاراف سمت راست
case (int)DTO.RoleEnums.مسئول_کارگزینی_هیات_علمی: //پاراف سمت چپ
case (int)DTO.RoleEnums.مسئول_حق_التدریس: //پاراف سمت چپ
dt = dao.getUserSignature(userRole);
//get user signature
break;
}
return(dt);
}
public DataTable getTerm_Contract(string term = "this")
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
DataTable dt = new DataTable();
dt.Columns.Add("term");
dt.Columns.Add("nimSal");
dt.Columns.Add("Sal");
DataRow dr = dt.NewRow();
dr[0] = dao.getTerm_Contract(term);
if (dr[0].ToString().Contains("-"))
{
string[] termArr = dr[0].ToString().Split('-');
if (termArr.Length == 3)
{
dr[2] = string.Format("{0}-{1}", termArr[0], termArr[1]);
dr[1] = termArr[2] == "1" ? "اول" : (termArr[2] == "2" ? "دوم" : (termArr[2] == "3" ? "تابستان" : ""));
}
}
dt.Rows.Add(dr);
return(dt);
}
public DataTable getBlacklistTeachers()
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
return(dao.getBlacklistTeachers());
}
public int updateBlacklistTeacher(string idd_meli, bool inblacklist = true)
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
return(dao.updateBlacklistTeacher(idd_meli, inblacklist));
}
public DataTable getAgreementOfTeacher(Int64 codeOstad)
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
return(dao.getTeacherAgreement(codeOstad));
}
public DataTable getContractOfTeacher(int codeOstad_Hr, string term = "this")
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
return(dao.getTeacherContract(codeOstad_Hr, term));
}
public DataTable getContractByStatus(int status, string term = "this")
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
return(dao.getContractByStatus(term, status));
}
public DataTable getAgreementByStatus(int status)
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
return(dao.getAgreementByStatus(status));
}
public bool updateTeacherAgreementStatus(int codeOstad, int userCode, string contractFile, out int AgreementID)
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
return(dao.updateTeacherAgreementStatus(codeOstad, getNewAgreementStatus(userCode), contractFile, out AgreementID));
}
public bool updateTeacherContractStatus(int codeOstad, int userCode, string contractFile, string term = "this")
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
return(dao.updateTeacherContractStatus(term, codeOstad, getNewContractStatus(userCode), contractFile));
}
private bool UpdateTeacherAgreementAfterReject(int hrID, string contractFile, out int contractId)
{
CooperationRequestDAO dao = new DAO.University.CooperationRequest.CooperationRequestDAO();
return(dao.UpdateTeacherAgreementAfterReject(contractFile, hrID, out contractId));
}
