//public job_sample_logs SelectDate(int _sample_Id, int _status)
//{
// return _repository.Find(x => x.job_sample_id == _sample_Id && x.job_status == _status).OrderBy(x=>x.date).FirstOrDefault();
//}
public List <job_sample_logs> SelectNotification(users_login userLogin)
{
/*
* 1 Root
* 2 Login
* 3 Chemist
* 4 SrChemist
* 5 Admin
* 6 LabManager
* 7 Account
*/
List <job_sample_logs> logs = new List <job_sample_logs>();
using (var ctx = new ALSIEntities())
{
job_sample_logs jsl = new job_sample_logs();
var result = from l in ctx.job_sample_logs
join j in ctx.job_sample on l.job_sample_id equals j.ID
where l.is_active == "0"
orderby l.date descending
select new
{
l.ID,
j.step1owner,
j.step2owner,
j.step3owner,
j.step4owner,
j.step5owner,
j.step6owner,
j.step7owner,
l.log_title,
l.job_remark,
l.date,
j.job_status,
j.job_number
};
RoleEnum roleEnum = (RoleEnum)Enum.Parse(typeof(RoleEnum), userLogin.role_id.ToString());
switch (roleEnum)
{
case RoleEnum.LOGIN:
result = result.Where(x => x.step1owner == userLogin.id || x.step2owner == userLogin.id);
result = result.Where(x => x.job_status == 11); // Convert.ToInt16(StatusEnum.LOGIN_SELECT_SPEC));
break;
case RoleEnum.CHEMIST:
result = result.Where(x => x.step3owner == userLogin.id);
result = result.Where(x => x.job_status == 12); // Convert.ToInt16(StatusEnum.CHEMIST_TESTING));
break;
case RoleEnum.SR_CHEMIST:
result = result.Where(x => x.step4owner == userLogin.id);
result = result.Where(x => x.job_status == 4); // Convert.ToInt16(StatusEnum.SR_CHEMIST_CHECKING));
break;
case RoleEnum.ADMIN:
result = result.Where(x => x.step6owner == userLogin.id || x.step7owner == userLogin.id);
//result = result.Where(x => x.job_status == Convert.ToInt16(StatusEnum.ADMIN_CONVERT_PDF)||x.job_status == Convert.ToInt16(StatusEnum.ADMIN_CONVERT_WORD));
break;
case RoleEnum.LABMANAGER:
result = result.Where(x => x.step5owner == userLogin.id);
result = result.Where(x => x.job_status == 9); // Convert.ToInt16(StatusEnum.LABMANAGER_CHECKING));
break;
}
DataTable dt = result.ToDataTable();
foreach (DataRow dr in dt.Rows)
{
int jobStatus = Convert.ToInt16(dr["job_status"]);
string logTitle = dr["log_title"].ToString();
string jobRemark = dr["job_remark"].ToString();
string jobNumber = dr["job_number"].ToString();
DateTime date = Convert.ToDateTime(dr["date"].ToString());
job_sample_logs jobSampleLog = new job_sample_logs
{
log_title = logTitle,
job_number = jobNumber,
job_remark = jobRemark,
date = date
};
logs.Add(jobSampleLog);
}
//var result = from l in ctx.job_sample_logs
// join j in ctx.job_sample on l.job_sample_id equals j.ID
// where l.is_active == "0"
// select new
// {
// j.step1owner,
// j.step2owner,
// j.step3owner,
// j.step4owner,
// j.step5owner,
// j.step6owner,
// j.step7owner,
// l.log_title,
// l.job_remark,
// l.date,
// j.job_status,
// j.job_number
// };
//DataTable dt = result.ToDataTable();
//foreach (DataRow dr in dt.Rows)
//{
// bool con1 = (dr["step1owner"] == DBNull.Value) ? false : Convert.ToInt16(dr["step1owner"]) == userLogin.id;
// bool con2 = (dr["step2owner"] == DBNull.Value) ? false : Convert.ToInt16(dr["step2owner"]) == userLogin.id;
// bool con3 = (dr["step3owner"] == DBNull.Value) ? false : Convert.ToInt16(dr["step3owner"]) == userLogin.id;
// bool con4 = (dr["step4owner"] == DBNull.Value) ? false : Convert.ToInt16(dr["step4owner"]) == userLogin.id;
// bool con5 = (dr["step5owner"] == DBNull.Value) ? false : Convert.ToInt16(dr["step5owner"]) == userLogin.id;
// bool con6 = (dr["step6owner"] == DBNull.Value) ? false : Convert.ToInt16(dr["step6owner"]) == userLogin.id;
// bool con7 = (dr["step7owner"] == DBNull.Value) ? false : Convert.ToInt16(dr["step7owner"]) == userLogin.id;
// Boolean isOk = con1 || con2 || con3 || con4 || con5 || con6 || con7;
// int jobStatus = Convert.ToInt16(dr["job_status"]);
// string logTitle = dr["log_title"].ToString();
// string jobRemark = dr["job_remark"].ToString();
// string jobNumber = dr["job_number"].ToString();
// DateTime date = Convert.ToDateTime(dr["date"].ToString());
// StatusEnum status = (StatusEnum)Enum.Parse(typeof(StatusEnum), dr["job_status"].ToString(), true);
// switch (status)
// {
// case StatusEnum.LOGIN_CONVERT_TEMPLATE:
// break;
// case StatusEnum.LOGIN_SELECT_SPEC:
// if (isOk && userLogin.role_id == 2)
// {
// job_sample_logs jobSampleLog = new job_sample_logs
// {
// log_title = String.Format("{0}->{1}", job_number, logTitle),
// job_number = jobNumber,
// job_remark = jobRemark,
// date = date
// };
// logs.Add(jobSampleLog);
// }
// break;
// case StatusEnum.CHEMIST_TESTING:
// if (isOk && userLogin.role_id == 3)
// {
// job_sample_logs jobSampleLog = new job_sample_logs
// {
// log_title = logTitle,
// job_number = jobNumber,
// job_remark = jobRemark,
// date = date
// };
// logs.Add(jobSampleLog);
// }
// break;
// case StatusEnum.SR_CHEMIST_CHECKING:
// if (isOk && userLogin.role_id == 4)
// {
// job_sample_logs jobSampleLog = new job_sample_logs
// {
// log_title = String.Format("{0}->{1}", job_number, logTitle),
// job_number = jobNumber,
// job_remark = jobRemark,
// date = date
// };
// logs.Add(jobSampleLog);
// }
// break;
// case StatusEnum.ADMIN_CONVERT_WORD:
// if (isOk && userLogin.role_id == 5)
// {
// job_sample_logs jobSampleLog = new job_sample_logs
// {
// log_title = String.Format("{0}->{1}", job_number, logTitle),
// job_number = jobNumber,
// job_remark = jobRemark,
// date = date
// };
// logs.Add(jobSampleLog);
// }
// break;
// case StatusEnum.LABMANAGER_CHECKING:
// if (isOk && userLogin.role_id == 5)
// {
// job_sample_logs jobSampleLog = new job_sample_logs
// {
// log_title = String.Format("{0}->{1}", job_number, logTitle),
// job_number = jobNumber,
// job_remark = jobRemark,
// date = date
// };
// logs.Add(jobSampleLog);
// }
// break;
// case StatusEnum.ADMIN_CONVERT_PDF:
// if (isOk && userLogin.role_id == 5)
// {
// job_sample_logs jobSampleLog = new job_sample_logs
// {
// log_title = String.Format("{0}->{1}", job_number, logTitle),
// job_number = jobNumber,
// job_remark = jobRemark,
// date = date
// };
// logs.Add(jobSampleLog);
// }
// break;
// }
//}
return(logs);
}
}
public void Update()
{
job_sample_logs existing = _repository.Find(x => x.ID == this.ID).FirstOrDefault();
_repository.Edit(existing, this);
}
