public void OTRequest_Service_GetByIdUT2()
{
//call action
otRequest = objServices.GetById(20);
//compare
Assert.IsNull(otRequest);
}
public bool CheckCreateDay(OTRequest oTRequest)
{
DateTime dateNow = DateTime.Now;
if ((TimeSpan.ParseExact(oTRequest.StartTime, @"hh\:mm", CultureInfo.InvariantCulture)) < (TimeSpan.ParseExact(dateNow.ToString("HH:mm"), @"hh\:mm", CultureInfo.InvariantCulture)))
{
return(false);
}
else
{
return(true);
}
}
public void OTRequest_Service_AddUT2()
{
OTRequest OTRequest = new OTRequest();
OTRequest.Title = null;
OTRequest.StatusRequestID = 1;
OTRequest.OTTimeTypeID = 1;
OTRequest.OTDateTypeID = 1;
OTRequest.CreatedBy = UserID2;
OTRequest.CreatedDate = DateTime.Now;
OTRequest.OTDate = DateTime.Now.AddDays(1);
//call action
otRequest = objServices.Add(OTRequest, UserID2);
//compare
Assert.IsNull(otRequest);
}
public static void UpdateOTRequest(this OTRequest otRequest, OTRequestViewModel otRequestVm)
{
otRequest.ID = otRequestVm.ID;
otRequest.Title = otRequestVm.Title;
otRequest.CreatedBy = otRequestVm.CreatedBy;
otRequest.OTDate = otRequestVm.OTDate;
otRequest.OTDateTypeID = otRequestVm.OTDateTypeID;
otRequest.OTTimeTypeID = otRequestVm.OTTimeTypeID;
otRequest.StatusRequestID = otRequestVm.StatusRequestID;
otRequest.UserAssignedID = otRequestVm.UserAssignedID;
otRequest.CreatedDate = otRequestVm.CreatedDate;
otRequest.UpdatedDate = otRequestVm.UpdatedDate;
otRequest.UpdatedBy = otRequestVm.UpdatedBy;
otRequest.StartTime = otRequestVm.StartTime;
otRequest.EndTime = otRequestVm.EndTime;
}
public bool CheckOtRequestUser(OTRequest otRequest, List <string> otRequestUser)
{
var lstOTRequestUser = _oTRequestUserRepository.GetMulti(x => x.OTRequest.OTDate == otRequest.OTDate && x.OTRequest.StatusRequest.Name != CommonConstants.StatusCancelled).Select(x => x.UserID).ToList();
var lstOTRequest = _otrequestRepository.GetMulti(x => x.OTDate == otRequest.OTDate && x.StatusRequest.Name != CommonConstants.StatusCancelled);
lstOTRequestUser.AddRange(lstOTRequest.Select(x => x.CreatedBy));
lstOTRequestUser = lstOTRequestUser.Distinct().ToList();
otRequestUser = otRequestUser.Distinct().ToList();
if (otRequestUser.Any(x => lstOTRequestUser.Contains(x)))
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// Add OT request into database
/// </summary>
/// <param name="otRequest"></param>
/// <param name="userID"></param>
/// <returns>OTReuqest</returns>
public OTRequest Add(OTRequest otRequest, string userID)
{
try {
otRequest.StatusRequestID = _statusRequestRepository.GetAll().FirstOrDefault(x => x.Name.Equals(CommonConstants.StatusPending)).ID;
otRequest.CreatedDate = DateTime.Now;
otRequest.CreatedBy = userID;
var OTRequest = _otrequestRepository.Add(otRequest);
Save();
return(OTRequest);
}
catch (DbUpdateException e)
{
return(null);
}
catch (InvalidOperationException ex)
{
return(null);
}
}
public OTRequest GetOTRequest(int ReqID, int?FY, string Username)
{
try
{
this.persister.CorrelationId = this.CorrelationId;
DataSet ds = persister.GetOTRequest(ReqID, FY, Username);
OTRequest obj = new OTRequest();
obj.ReqID = ReqID;
obj.Header = (from DataRow row in ds.Tables[0].AsEnumerable()
select new Header()
{
OTCode = row["OTCode"].ToString(),
Status = new IDDescription()
{
ID = Convert.ToInt32(row["StatusID"]),
Description = row["StatusName"].ToString(),
},
RequestType = new IDDescription()
{
ID = Convert.ToInt32(row["RequestTypeID"]),
Description = Enum.GetName(typeof(RequestType), Convert.ToInt32(row["RequestTypeID"])),
},
BriefDescription = row["BriefDescription"].ToString(),
DetailDescription = row["DetailDescription"].ToString(),
CashOrComp = row["CashOrComp"].ToString(),
BureauOwner = row["BureauOwner"].ToString(),
StartDate = Convert.ToDateTime(row["StartDate"]),
EndDate = Convert.ToDateTime(row["EndDate"]),
IFY = Convert.ToInt32(row["IFY"]),
AuthorizedOTAmount = Convert.ToDecimal(row["AuthorizedOTAmount"]),
EstimatedOTHours = Convert.ToDecimal(row["EstimatedOTHours"]),
AuthorizedOTHours = Convert.ToDecimal(row["AuthorizedOTHours"]),
ActiveOTCode = Convert.ToBoolean(row["ActiveOTCode"])
// Neha TBD copy all the variables
}).FirstOrDefault();
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public HttpResponseMessage GetOTRequest(int?reqid = null, int?fy = null)
{
HttpStatusCode ReturnCode = HttpStatusCode.OK;
TranInfo <OTRequest> transaction = new TranInfo <OTRequest>();
try
{
ExtractClaimDetails();
OTRequest obj;
if (reqid.HasValue)
{
obj = service.GetOTRequest((int)reqid, fy, Username);
}
else
{
obj = new OTRequest();
}
transaction.data = obj;
transaction.status = true;
}
catch (Exception ex)
{
transaction.AddException(ex.Message);
ReturnCode = HttpStatusCode.InternalServerError;
if (ex.InnerException != null)
{
InnerExceptionMessage = ex.InnerException.Message;
}
LogHelper.Instance.Error(service.CorrelationId, Username, Request.GetRequestContext().VirtualPathRoot, ex.Message, InnerExceptionMessage, 0, ex);
}
return(Request.CreateResponse <TranInfo <OTRequest> >(ReturnCode, transaction));
}
public void UpdateOTRequest(OTRequest oTRequest)
{
_otrequestRepository.Update(oTRequest);
Save();
}
public async Task <HttpResponseMessage> Create(HttpRequestMessage request, string userID, string groupId, OTRequestViewModel otRequestVm)
{
return(await CreateHttpResponse(request, () =>
{
HttpResponseMessage response = null;
if (!ModelState.IsValid)
{
response = request.CreateResponse(HttpStatusCode.BadRequest, ModelState);
}
var tmp = otRequestVm.OTRequestUserID.ToList();
tmp.Add(otRequestVm.UserID);
otRequestVm.OTRequestUserID = tmp.Distinct().ToArray();
var newOTRequest = new OTRequest();
newOTRequest.UpdateOTRequest(otRequestVm);
var dateNow = DateTime.Now.Date;
if (otRequestVm.OTDate == dateNow && _otrequestService.CheckCreateDay(newOTRequest) == false)
{
return request.CreateResponse(HttpStatusCode.BadRequest, MessageSystem.ERROR_CREATE_OTREQUEST_IN_PAST_NOT_MSG);
}
if (_otrequestService.CheckOtRequestUser(newOTRequest, otRequestVm.OTRequestUserID.ToList()) == false)
{
return request.CreateResponse(HttpStatusCode.BadRequest, MessageSystem.ERROR_CANNOT_CREATE_OT_EXIST);
}
if (otRequestVm.OTDate < dateNow)
{
return request.CreateResponse(HttpStatusCode.BadRequest, MessageSystem.ERROR_CREATE_OTREQUEST_IN_PAST_NOT_MSG);
}
// nomal
if (otRequestVm.OTDate != null && _commonService.isWorkingDay(otRequestVm.OTDate.Value) && otRequestVm.OTDateTypeID != CommonConstants.OTDateTypeNormal)
{
return request.CreateResponse(HttpStatusCode.BadRequest, otRequestVm.OTDate.Value.Date.ToString("dd/MM/yyyy",
CultureInfo.InvariantCulture) + " is " + otRequestVm.OTDate.Value.DayOfWeek + ", " + MessageSystem.ERROR_MUST_SELECT_NOMAL);
}
// weekend
if (otRequestVm.OTDate != null && _commonService.isWeekend(otRequestVm.OTDate.Value) && otRequestVm.OTDateTypeID != CommonConstants.OTDateTypeWeekend)
{
return request.CreateResponse(HttpStatusCode.BadRequest, otRequestVm.OTDate.Value.Date.ToString("dd/MM/yyyy",
CultureInfo.InvariantCulture) + " is " + otRequestVm.OTDate.Value.DayOfWeek + ", " + MessageSystem.ERROR_MUST_SELECT_WEEKEND);
}
//holiday
if (otRequestVm.OTDate != null && _commonService.isHoliday(otRequestVm.OTDate.Value) && otRequestVm.OTDateTypeID != CommonConstants.OTDateTypeHoliDay)
{
return request.CreateResponse(HttpStatusCode.BadRequest, otRequestVm.OTDate.Value.Date.ToString("dd/MM/yyyy",
CultureInfo.InvariantCulture) + " is " + otRequestVm.OTDate.Value.DayOfWeek + ", " + MessageSystem.ERROR_MUST_SELECT_HOLIDAY);
}
else
{
if (TimeSpan.ParseExact(otRequestVm.StartTime, @"hh\:mm", CultureInfo.InvariantCulture) > TimeSpan.ParseExact(otRequestVm.EndTime, @"hh\:mm", CultureInfo.InvariantCulture))
{
return request.CreateErrorResponse(HttpStatusCode.BadRequest, MessageSystem.StartTimeCompareEndTime);
}
var checkCondition = _otrequestService.CheckConditionCreate(otRequestVm.OTDateTypeID, otRequestVm.OTTimeTypeID, otRequestVm.StartTime, otRequestVm.EndTime);
if (!string.IsNullOrEmpty(checkCondition))
{
return request.CreateErrorResponse(HttpStatusCode.BadRequest, checkCondition);
}
if (_otrequestService.CheckOtRequestUser(newOTRequest, otRequestVm.OTRequestUserID.ToList()) == true)
{
_otrequestService.Add(newOTRequest, userID);
var responseData = Mapper.Map <OTRequest, OTRequestViewModel>(newOTRequest);
_otRequestUserService.Add(otRequestVm.OTRequestUserID, newOTRequest.ID);
response = request.CreateResponse(HttpStatusCode.Created, responseData);
}
else
{
response = request.CreateResponse(HttpStatusCode.BadRequest, MessageSystem.ERROR_CANNOT_CREATE_OT_EXIST);
}
}
return response;
}));
}
