public JsonResult ReturnClassStatus()
{
var isGenesisDetails = _studentServices.CheckIfGenesis();
if (!isGenesisDetails.Success)
{
var classStatus = _context.ClassStatus.ToList();
var institutionInitial = _systemServices.GetSystemSetup()?.Data?.SubTitle ?? "";
var status = new
{
classStatus,
institutionInitial
};
return(Json(new ReturnData <dynamic>
{
Success = classStatus.Count > 0,
Data = status
}));
}
return(Json(new ReturnData <dynamic>
{
Success = true
}));
}
public JsonResult GetMemoResources(string usercode)
{
try
{
var user = _unitOfWork.Users.GetUsersByCode(usercode);
if (user == null)
{
return(Json(new ReturnData <string>
{
Success = false,
Message = "You are not allowed to create a memo. Kindly contact admin"
}));
}
if (!_studentServices.CheckIfGenesis().Data)
{
return(Json(new ReturnData <string>
{
Success = false,
Message = "Sorry, memos not supported at the moment."
}));
}
var departments = _unitOfWork.Department.GetStaffDepartments();
var staffDetails = _staffServices.GetEmployees(usercode)?.Data;
var participants = _unitOfWork.HrpEmployee.GetWhere(e => e.Terminated == false);
return(Json(new ReturnData <dynamic>
{
Success = true,
Data = new
{
staffDetails,
departments,
participants
}
}));
}
catch (Exception ex)
{
return(Json(new ReturnData <string>
{
Success = false,
Message = "An error occurred"
}));
}
}
public ReturnData <List <RecipientViewModel> > GetMessageRecepients(string userName)
{
var users = new List <RecipientViewModel>();
var isGenesis = _studentServices.CheckIfGenesis().Success;
string connetionString = DbSetting.ConnectionString(_configuration, "Unisol");
SqlConnection connection = new SqlConnection(connetionString);
connection.Open();
string sql = "SELECT AdmnNo as username,[names] as fullname FROM Register" +
" UNION" +
" SELECT EmpNo as username,[Names] as fullname FROM hrpEmployee order by fullname asc";
if (isGenesis)
{
sql = "SELECT EmpNo as username,[Names] as fullname FROM hrpEmployee order by fullname asc";
}
SqlCommand command = new SqlCommand(sql, connection);
var listActiveColumns = new List <string>();
using (var rdr = command.ExecuteReader())
{
while (rdr.Read())
{
var newUser = new RecipientViewModel
{
UserName = rdr.GetValue(0).ToString(),
RecipientName = rdr.GetValue(1).ToString()
};
users.Add(newUser);
}
}
var distinctUsers = users.GroupBy(u => u.UserName).Select(u => u.First()).ToList();
command.Dispose();
connection.Close();
return(new ReturnData <List <RecipientViewModel> >
{
Data = distinctUsers,
Success = true,
Message = "Recipients found",
});
}
public JsonResult CheckIfGenesis()
{
return(Json(_studentServices.CheckIfGenesis()));
}
public JsonResult SaveEmployeeImprest(ImprestReq imprestReq)
{
try
{
imprestReq.Rdate = DateTime.Today;
imprestReq.Usercode = imprestReq.EmpNo;
var user = _context.HrpEmployee.FirstOrDefault(u => u.EmpNo == imprestReq.EmpNo);
if (_studentServices.CheckIfGenesis().Data)
{
var memo = _context.ImprestMemo.Any(m => m.Ref.ToUpper().Equals(imprestReq.MemoRef.ToUpper()) &&
m.Status.ToUpper().Equals("APPROVED"));
if (!memo)
{
return(Json(new ReturnData <string>
{
Success = false,
Message = "Sorry, Only approved memos can be used to request for an imprest. Kindly contact admin"
}));
}
var memoDetails = _context.ImprestMemoDetail.Any(d => d.EmpNo.ToUpper().Equals(imprestReq.EmpNo.ToUpper()) &&
d.Ref.ToUpper().Equals(imprestReq.MemoRef.ToUpper()));
if (!memoDetails)
{
return(Json(new ReturnData <string>
{
Success = false,
Message = $"{user.Names} is not one of the participants on the Memo reference number entered."
}));
}
}
var message = "";
if (imprestReq.Amount < 0)
{
message = "Amount must be greater than 0";
}
if (Convert.ToDateTime(imprestReq.Edate).Date < DateTime.Now.Date)
{
message = "Expected date should be greater than today";
}
var imprestNumber = getImprestNumber();
var procOnlineReq = new ProcOnlineReq
{
ReqRef = imprestNumber,
DocType = "IMPREST WARRANT",
Rdate = DateTime.Today,
Rtime = DateTime.UtcNow.AddHours(3),
Usercode = user.EmpNo,
Status = "Pending",
};
//var wfRouting = _staffServices.GetWfRouting(procOnlineReq.DocType);
//if (!wfRouting.Success)
// return Json(wfRouting);
//if (string.IsNullOrEmpty(wfRouting.Data.Id.ToString()))
// return Json(wfRouting);
//var workFlowStatus = utils.SaveToWorkFlowCenter(procOnlineReq, user, wfRouting.Data.Id.ToString());
//if (!workFlowStatus.Success)
// return Json(workFlowStatus);
_context.ImprestReq.Add(imprestReq);
_context.SaveChanges();
message = "Your imprest has been successfully saved";
return(Json(new ReturnData <string>
{
Success = true,
Message = message
}));
}
catch (Exception ex)
{
return(Json(new ReturnData <bool>
{
Success = false,
Message = "Oops,seems like an error occurred while processing your request",
Error = new Error(ex)
}));
}
}
