public string ApprovedClaim(Guid claimId, Guid userId, string type)
{
using (var context = new VnrHrmDataContext())
{
var message = string.Empty;
var status = string.Empty;
var UserLogin = string.Empty;
var objApprovedClaim = new List<object>();
objApprovedClaim.AddRange(new object[6]);
objApprovedClaim[4] = 1;
objApprovedClaim[5] = int.MaxValue - 1;
var lstApprovedClaim = GetData<FIN_ApproverECLAIMEntity>(objApprovedClaim, ConstantSql.hrm_fin_sp_get_ApproverECLAIM, UserLogin, ref status).ToList();
var approvedType1 = FinApproverType.FIN_Claim_Profile.ToString();
var approvedType2 = FinApproverType.FIN_Claim_Manufacture.ToString();
var approvedEntity = lstApprovedClaim.Where(s => s.ApprovedID != null && s.ApprovedID.Value == userId && (s.ApprovedType == approvedType1 || s.ApprovedType == approvedType2)).FirstOrDefault();
var claimEntity = GetData<FIN_ClaimEntity>(claimId, ConstantSql.hrm_hr_sp_get_ClaimById, UserLogin, ref status).FirstOrDefault();
var objHistory = new List<object>();
objHistory.AddRange(new object[10]);
objHistory[8] = 1;
objHistory[9] = int.MaxValue - 1;
var lstHistory = GetData<FIN_HistoryApproveECLAIMEntity>(objHistory, ConstantSql.hrm_hr_sp_get_HistoryApprovedClaim, UserLogin, ref status).ToList();
//var obTravelRequestItem = new List<object>();
//obTravelRequestItem.Add(claimId);
//var lstTravelRequestItem = GetData<FIN_TravelRequestItemEntity>(obTravelRequestItem, ConstantSql.hrm_hr_sp_get_TravelRequestItemByTravelRequestID, ref status).Where(s => s.Description2 != null && s.Description2 == "E_REJECTED").ToList();
if (approvedEntity != null)
{
if (claimEntity != null)
{
if (claimEntity.CashAdvanceID != null)
{
var cashAdvanceEntity = GetData<Fin_CashAdvanceEntity>(claimEntity.CashAdvanceID.Value, ConstantSql.hrm_hr_sp_get_CashAdvanceById, UserLogin, ref status).FirstOrDefault();
var lstHistoryCash = lstHistory.Where(s => s.CashAdvanceID != null && s.CashAdvanceID.Value == claimEntity.CashAdvanceID.Value && s.Status == "E_APPROVED" && s.UserApproveClaimID != null && s.UserApproveClaimID.Value == userId).ToList();
if (cashAdvanceEntity != null)
{
if (cashAdvanceEntity.TravelRequestID != null)
{
var travelRequestEntity = GetData<FIN_TravelRequestEntity>(cashAdvanceEntity.TravelRequestID.Value, ConstantSql.hrm_hr_sp_get_TravelRequestById, UserLogin, ref status).FirstOrDefault();
var lstHistoryTravel = lstHistory.Where(s => s.TravelRequestID != null && s.TravelRequestID.Value == cashAdvanceEntity.TravelRequestID.Value && s.Status == "E_APPROVED" && s.UserApproveClaimID != null && s.UserApproveClaimID.Value == userId).ToList();
if (travelRequestEntity != null)
{
if (lstHistoryTravel.Count == 0)
{
var travelAddentity = new FIN_HistoryApproveECLAIMEntity();
travelAddentity.TravelRequestID = cashAdvanceEntity.TravelRequestID;
travelAddentity.UserApproveClaimID = (Guid?)approvedEntity.ID;
travelAddentity.DateApproved = DateTime.Now;
travelAddentity.Status = type;
message = Add(travelAddentity);
}
}
}
if (lstHistoryCash.Count == 0)
{
var cashAddEntity = new FIN_HistoryApproveECLAIMEntity();
cashAddEntity.TravelRequestID = cashAdvanceEntity.TravelRequestID;
cashAddEntity.CashAdvanceID = claimEntity.CashAdvanceID;
cashAddEntity.UserApproveClaimID = (Guid?)approvedEntity.ID;
cashAddEntity.DateApproved = DateTime.Now;
cashAddEntity.Status = type;
message = Add(cashAddEntity);
}
}
}
var entity = new FIN_HistoryApproveECLAIMEntity();
entity.ClaimID = (Guid?)claimId;
entity.TravelRequestID = claimEntity.TravelRequestID;
entity.CashAdvanceID = claimEntity.CashAdvanceID;
entity.UserApproveClaimID = (Guid?)approvedEntity.ID;
entity.DateApproved = DateTime.Now;
entity.Status = type;
message = Add(entity);
}
}
else
{
message = "Bạn Không Có Quyền Duyệt!";
}
return message;
}
}
public string ApprovedCashAdvance(Guid cashAdvanceId, Guid userId, string type)
{
using (var context = new VnrHrmDataContext())
{
var message = string.Empty;
var status = string.Empty;
var UserLogin = string.Empty;
var services = new BaseService();
var objApprovedClaim = new List<object>();
objApprovedClaim.AddRange(new object[6]);
objApprovedClaim[4] = 1;
objApprovedClaim[5] = int.MaxValue - 1;
var lstApprovedClaim = GetData<FIN_ApproverECLAIMEntity>(objApprovedClaim, ConstantSql.hrm_fin_sp_get_ApproverECLAIM, UserLogin, ref status).ToList();
var approvedType = FinApproverType.Fin_CashAdvance.ToString();
var approvedEntity = lstApprovedClaim.Where(s => s.ApprovedID != null && s.ApprovedID.Value == userId && s.ApprovedType == approvedType).FirstOrDefault();
var cashAdvanceEntity = GetData<Fin_CashAdvanceEntity>(cashAdvanceId, ConstantSql.hrm_hr_sp_get_CashAdvanceById, UserLogin, ref status).FirstOrDefault();
var objHistory = new List<object>();
objHistory.AddRange(new object[10]);
objHistory[8] = 1;
objHistory[9] = int.MaxValue - 1;
var lstHistory = GetData<FIN_HistoryApproveECLAIMEntity>(objHistory, ConstantSql.hrm_hr_sp_get_HistoryApprovedClaim, UserLogin, ref status).ToList();
if (approvedEntity != null)
{
if (cashAdvanceEntity.TravelRequestID != null)
{
var travelEntity = GetData<FIN_TravelRequestEntity>(cashAdvanceEntity.TravelRequestID.Value, ConstantSql.hrm_hr_sp_get_TravelRequestById, UserLogin, ref status).FirstOrDefault();
var lstHistoryTravel = lstHistory.Where(s => s.TravelRequestID != null && s.TravelRequestID.Value == cashAdvanceEntity.TravelRequestID.Value && s.Status == "E_APPROVED" && s.UserApproveClaimID != null && s.UserApproveClaimID.Value == userId).ToList();
if (travelEntity != null)
{
if (lstHistoryTravel.Count == 0)
{
var entityAdd = new FIN_HistoryApproveECLAIMEntity();
entityAdd.TravelRequestID = cashAdvanceEntity.TravelRequestID;
entityAdd.UserApproveClaimID = (Guid?)approvedEntity.ID;
entityAdd.DateApproved = DateTime.Now;
entityAdd.Status = type;
message = Add(entityAdd);
}
}
}
var entity = new FIN_HistoryApproveECLAIMEntity();
entity.CashAdvanceID = (Guid?)cashAdvanceId;
if (cashAdvanceEntity != null)
{
entity.TravelRequestID = cashAdvanceEntity.TravelRequestID;
}
entity.UserApproveClaimID = (Guid?)approvedEntity.ID;
entity.DateApproved = DateTime.Now;
entity.Status = type;
message = Add(entity);
}
else
{
message = "Bạn Không Có Quyền Duyệt!";
}
return message;
}
}
public string ApprovedTravelRequest(Guid travelRequestId, Guid userId, string type) {
using (var context = new VnrHrmDataContext())
{
var message = string.Empty;
var status = string.Empty;
var UserLogin = string.Empty;
var objApprovedClaim = new List<object>();
objApprovedClaim.AddRange(new object[6]);
objApprovedClaim[4] = 1;
objApprovedClaim[5] = int.MaxValue - 1;
var lstApprovedClaim = GetData<FIN_ApproverECLAIMEntity>(objApprovedClaim, ConstantSql.hrm_fin_sp_get_ApproverECLAIM, UserLogin, ref status).ToList();
var approvedType1 = FinApproverType.FIN_TravelRequest_Domestic.ToString();
var approvedType2 = FinApproverType.FIN_TravelRequest_External.ToString();
var approvedEntity = lstApprovedClaim.Where(s => s.ApprovedID != null && s.ApprovedID.Value == userId && (s.ApprovedType == approvedType1 || s.ApprovedType == approvedType2)).FirstOrDefault();
//var obTravelRequestItem = new List<object>();
//obTravelRequestItem.Add(travelRequestId);
//var lstTravelRequestItem = GetData<FIN_TravelRequestItemEntity>(obTravelRequestItem, ConstantSql.hrm_hr_sp_get_TravelRequestItemByTravelRequestID, ref status).Where(s => s.Description2 != null && s.Description2 == "E_REJECTED").ToList();
if (approvedEntity != null)
{
var entity = new FIN_HistoryApproveECLAIMEntity();
entity.TravelRequestID = (Guid?)travelRequestId;
entity.UserApproveClaimID = (Guid?)approvedEntity.ID;
entity.DateApproved = DateTime.Now;
entity.Status = type;
message = Add(entity);
}
else
{
message = "Bạn Không Có Quyền Duyệt!";
}
return message;
}
}