public ActionResult TransportOrder_Read([DataSourceRequest] DataSourceRequest request, int id = 0, int programId = 0, int regionId = 0)
{
var transportRequistions = programId == 0 ?_transportRequisitionService.GetTransportRequsitionDetails(): _transportRequisitionService.GetTransportRequsitionDetails(programId);
List <TransportOrder> transportRequisitionRegion;
//var filteredTransportOrder=_transportOrderDetailService.FindBy(m=>m.RequisitionID=)
var transportOrders = id == 0 ? _transportOrderService.GetFilteredTransportOrder(transportRequistions, (int)TransportOrderStatus.Draft).OrderByDescending(m => m.TransportOrderID).ToList()
: _transportOrderService.GetFilteredTransportOrder(transportRequistions, id).ToList();
transportRequisitionRegion = regionId == 0
? transportOrders
: (from detail in transportOrders
let orDefault = detail.TransportOrderDetails.FirstOrDefault()
where
orDefault != null &&
orDefault.FDP.AdminUnit.AdminUnit2.AdminUnit2.AdminUnitID ==
regionId
select detail).ToList();
var datePref = UserAccountHelper.GetUser(User.Identity.Name).DatePreference;
var statuses = _workflowStatusService.GetStatus(WORKFLOW.TRANSPORT_ORDER);
var transportOrderViewModels = TransportOrderViewModelBinder.BindListTransportOrderViewModel(
transportRequisitionRegion, datePref, statuses);
return(Json(transportOrderViewModels.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
public static IEnumerable <NeedAssessmentPlanViewModel> GetNeedAssessmentPlanInfo(IEnumerable <Plan> plans, List <WorkflowStatus> statuses)
{
return(plans.Select(viewModel =>
{
var firstOrDefault = viewModel.NeedAssessments.FirstOrDefault();
return firstOrDefault != null ? new NeedAssessmentPlanViewModel
{
AssessmentName = viewModel.PlanName,
PlanID = viewModel.PlanID,
NeedAssessmentID = firstOrDefault.NeedAID,
//NeedAssessmentID = viewModel.NeedAssessments.First().NeedAID,
StartDate = viewModel.StartDate.ToCTSPreferedDateFormat(UserAccountHelper.UserCalendarPreference()),
EndDate = viewModel.EndDate.ToCTSPreferedDateFormat(UserAccountHelper.UserCalendarPreference()),
StatuID = viewModel.Status,
Status = statuses.Find(t => t.WorkflowID == (int)WORKFLOW.Plan && t.StatusID == viewModel.Status).Description
//Year = (int) viewModel.NeedAssessments.First().Year
}: new NeedAssessmentPlanViewModel
{
AssessmentName = viewModel.PlanName,
PlanID = viewModel.PlanID,
//NeedAssessmentID = viewModel.NeedAssessments.First().NeedAID,
StartDate = viewModel.StartDate.ToCTSPreferedDateFormat(UserAccountHelper.UserCalendarPreference()),
EndDate = viewModel.EndDate.ToCTSPreferedDateFormat(UserAccountHelper.UserCalendarPreference()),
StatuID = viewModel.Status,
//Status = statuses.Find(t => t.WorkflowID == (int)WORKFLOW.Plan && t.StatusID == viewModel.Status).Description
//Year = (int) viewModel.NeedAssessments.First().Year
};
}));
}
//[HttpPost]
//public ActionResult Requisitions(IList<SelectFromGrid> input)
//{
// var requisionIds = (from item in input where (item.IsSelected !=null ?((string[])item.IsSelected)[0]: "off")=="on" select item.Number).ToList();
// var req = new List<List<int>>();
// req.Add(requisionIds);
// return CreateTransportRequisition(req);
//}
public ActionResult CreateTransportRequisition(int regionId)
{
try
{
var requisitions = _reliefRequisitionService.FindBy(t => t.RegionID == regionId && t.Status == (int)ReliefRequisitionStatus.SiPcAllocationApproved);
var programs = (from item in requisitions select item.ProgramID).Distinct().ToList();
var requisitionToDispatches = new List <List <int> >();
var currentUser = UserAccountHelper.GetUser(User.Identity.Name).UserProfileID;
foreach (var program in programs)
{
var requisitionToDispatche =
(from itm in requisitions where itm.ProgramID == program select itm.RequisitionID).ToList();
requisitionToDispatches.Add(requisitionToDispatche);
}
_transportRequisitionService.CreateTransportRequisition(requisitionToDispatches, currentUser);
return(RedirectToAction("Index", "TransportRequisition"));//,new {id=(int)TransportRequisitionStatus.Draft});
}
catch (Exception exception)
{
var log = new Logger();
log.LogAllErrorsMesseges(exception, _log);
ModelState.AddModelError("", exception.Message);
return(RedirectToAction("Main", "DispatchAllocation"));
throw;
}
}
public virtual IActionResult UserDistrictsIdSwitchPost([FromRoute] int id)
{
bool exists = _context.HetUserDistrict.Any(a => a.UserDistrictId == id);
// not found
if (!exists)
{
return(new NotFoundObjectResult(new HetsResponse("HETS-01", ErrorViewModel.GetDescription("HETS-01", _configuration))));
}
// get record
HetUserDistrict userDistrict = _context.HetUserDistrict.First(a => a.UserDistrictId == id);
string userId = UserAccountHelper.GetUserId(_httpContext);
HetUser user = _context.HetUser.First(a => a.SmUserId == userId);
user.DistrictId = userDistrict.DistrictId;
_context.SaveChanges();
// create new district switch cookie
_httpContext.Response.Cookies.Append(
"HETSDistrict",
userDistrict.DistrictId.ToString(),
new CookieOptions
{
Path = "/",
SameSite = SameSiteMode.None
}
);
return(new ObjectResult(new HetsResponse(user)));
}
private TransportContractReportViewModel GetTransportOrderReport(TransportOrder transportOrder)
{
var datePref = UserAccountHelper.GetUser(User.Identity.Name).DatePreference;
var transportOrderReport = new TransportContractReportViewModel()
{
TransportOrderID = transportOrder.TransportOrderID,
TransportOrderNo = transportOrder.TransportOrderNo,
TransporterID = transportOrder.TransporterID,
RequisitionNo = transportOrder.TransportOrderDetails.First().ReliefRequisition.RequisitionNo,
TransporterName = transportOrder.Transporter.Name,
BidDocumentNo = transportOrder.BidDocumentNo,
ConsignerName = transportOrder.ConsignerName,
ContractNumber = transportOrder.ContractNumber,
OrderDate = transportOrder.OrderDate.ToCTSPreferedDateFormat(datePref),
OrderExpiryDate = transportOrder.OrderExpiryDate.ToCTSPreferedDateFormat(datePref),
RequestedDispatchDate = transportOrder.RequestedDispatchDate.ToCTSPreferedDateFormat(datePref),
ConsignerDate = transportOrder.ConsignerDate.ToCTSPreferedDateFormat(datePref),
PerformanceBondReceiptNo = transportOrder.PerformanceBondReceiptNo,
TransporterSignedDate = transportOrder.TransporterSignedDate.ToCTSPreferedDateFormat(datePref),
TransporterSignedName = transportOrder.TransporterSignedName,
ZoneName = transportOrder.TransportOrderDetails.First().FDP.AdminUnit.AdminUnit2.Name,
ZoneID = transportOrder.TransportOrderDetails.First().FDP.AdminUnit.AdminUnit2.AdminUnitID,
RegionName = transportOrder.TransportOrderDetails.First().FDP.AdminUnit.AdminUnit2.AdminUnit2.Name,
CommodityID = transportOrder.TransportOrderDetails.First().CommodityID,
CommodityName = transportOrder.TransportOrderDetails.First().Commodity.Name,
RequisitionID = transportOrder.TransportOrderDetails.First().FDP.AdminUnit.AdminUnit2.AdminUnit2.AdminUnitID
};
return(transportOrderReport);
}
public JsonResult ReadCheques()
{
var cheques = _transporterChequeService.GetAllTransporterCheque().Where(t => t.Status < 4).Select(c =>
{
var transporterChequeDetail = c.TransporterChequeDetails.FirstOrDefault();
return(transporterChequeDetail != null ? new
{
chequeNo = c.CheckNo,
Transporter = transporterChequeDetail.TransporterPaymentRequest.TransportOrder.Transporter.Name,
c.Amount,
PreparedBy = c.UserProfile.FirstName + " " + c.UserProfile.LastName,
ApprovedBy = c.AppovedBy != null ? _userProfileService.FindById((int)c.AppovedBy).FirstName + " " +
_userProfileService.FindById((int)c.AppovedBy).LastName : "",
DateApproved = c.AppovedDate.Date.ToCTSPreferedDateFormat(UserAccountHelper.UserCalendarPreference()),
transporterChequeId = c.TransporterChequeId,
State = c.Status,
Status = c.BusinessProcess.CurrentState.BaseStateTemplate.Name,
ButtonStatus = c.BusinessProcess.CurrentState.BaseStateTemplate.Name,
c.BankName
} : null);
});
return(Json(cheques, JsonRequestBehavior.AllowGet));
}
public virtual IActionResult BceidOwnersGet()
{
// get business
string businessGuid = UserAccountHelper.GetBusinessGuid(_httpContext, _env);
HetBusiness business = _context.HetBusiness.AsNoTracking()
.FirstOrDefault(x => x.BceidBusinessGuid.ToLower().Trim() == businessGuid.ToLower().Trim());
if (business == null)
{
return(StatusCode(StatusCodes.Status401Unauthorized));
}
// check access
if (!CanAccessBusiness(business.BusinessId))
{
return(StatusCode(StatusCodes.Status401Unauthorized));
}
// get business
HetBusiness businessDetail = _context.HetBusiness.AsNoTracking()
.Include(x => x.HetOwner)
.ThenInclude(y => y.PrimaryContact)
.Include(x => x.HetOwner)
.ThenInclude(y => y.Business)
.Include(x => x.HetOwner)
.ThenInclude(y => y.LocalArea.ServiceArea.District)
.FirstOrDefault(a => a.BusinessId == business.BusinessId);
return(new ObjectResult(new HetsResponse(businessDetail)));
}
private bool CanAccessOwner(int businessId, int ownerId)
{
// validate that the current user can access this record
string userId = UserAccountHelper.GetUserId(_httpContext);
bool isBusiness = UserAccountHelper.IsBusiness(_httpContext);
// not a business user
if (string.IsNullOrEmpty(userId) || !isBusiness)
{
return(false);
}
// get business & owner record
HetOwner owner = _context.HetOwner.AsNoTracking()
.Include(x => x.Business)
.ThenInclude(x => x.HetBusinessUser)
.FirstOrDefault(x => x.BusinessId == businessId &&
x.OwnerId == ownerId);
// get user
HetBusinessUser user = owner?.Business?.HetBusinessUser
.FirstOrDefault(x => x.BceidUserId.Equals(userId, StringComparison.InvariantCultureIgnoreCase));
// no access to business or business doesn't exist
return(user != null);
}
/// <summary>
/// Validates the inputs on this page
/// </summary>
/// <returns></returns>
public override bool ValidatePage()
{
bool isPageValid = true;
try
{
if (this.checkBoxNewUserId.IsChecked.GetValueOrDefault(false))
{
String userName = SetupInputs.Instance.FindItem(SetupInputTags.WapSqlDBAdminNameTag);
String domainName = SetupInputs.Instance.FindItem(SetupInputTags.WapSqlDBAdminDomainTag);
if (!UserAccountHelper.ValidateCredentials(userName, domainName, this.passwordBoxPassword.SecurePassword))
{
throw new Exception("Either the domain account or the password you entered are not valid.");
}
}
}
catch (Exception backEndErrorException)
{
SetupLogger.LogException(backEndErrorException);
SetupHelpers.ShowError(backEndErrorException.Message);
isPageValid = false;
}
return(isPageValid);
}
public ActionResult Preference()
{
if (TempData["PreferenceUpdateSuccessMsg"] != null)
{
ModelState.AddModelError("Success", TempData["PreferenceUpdateSuccessMsg"].ToString());
}
if (TempData["PreferenceUpdateErrorMsg"] != null)
{
ModelState.AddModelError("Errors", TempData["PreferenceUpdateErrorMsg"].ToString());
}
var userID = UserAccountHelper.GetUser(HttpContext.User.Identity.Name).UserProfileID;
var userDashboardPreferences = _userDashboardPreferenceService.Get(t => t.UserID == userID).OrderBy(m => m.OrderNo);
var selectedDashboardWidgets = userDashboardPreferences.Select(userDashboardPreference =>
_dashboardWidgetService.FindById(userDashboardPreference.DashboardWidgetID)).ToList();
ViewBag.SelectedDashboards = selectedDashboardWidgets;
var allDashboardWidgets = _dashboardWidgetService.GetAllDashboardWidget();
var unselectedDashbaords = allDashboardWidgets.Where(dashboardWidget => !selectedDashboardWidgets.Contains(dashboardWidget)).ToList();
ViewBag.UnselectedDashbaords = unselectedDashbaords;
var user = userService.GetUserDetail(HttpContext.User.Identity.Name);
var userPreferenceViewModel = new UserPreferenceViewModel(user);
ViewBag.Languages = new SelectList(userPreferenceViewModel.Languages, "StringID", "Name", userPreferenceViewModel.Language);
ViewBag.DateFormatPreference = new SelectList(userPreferenceViewModel.DateFormatPreferences, "StringID", "Name", userPreferenceViewModel.DateFormatPreference);
ViewBag.WeightPrefernce = new SelectList(userPreferenceViewModel.WeightPerferences, "StringID", "Name", userPreferenceViewModel.WeightPrefernce.Trim());
ViewBag.KeyboardLanguage = new SelectList(userPreferenceViewModel.KeyboardLanguages, "StringID", "Name", userPreferenceViewModel.KeyboardLanguage);
ViewBag.ThemePreference = new SelectList(userPreferenceViewModel.ThemePreferences, "StringID", "Name", userPreferenceViewModel.ThemePreference);
return(View(userPreferenceViewModel));
}
public virtual IActionResult DistrictEquipmentTypesGet()
{
// get current users district id
int?districtId = UserAccountHelper.GetUsersDistrictId(_context, HttpContext);
// not found
if (districtId == null)
{
return(new ObjectResult(new List <HetDistrictEquipmentType>()));
}
List <HetDistrictEquipmentType> equipmentTypes = _context.HetDistrictEquipmentType.AsNoTracking()
.Include(x => x.District)
.Include(x => x.EquipmentType)
.Include(x => x.HetEquipment)
.ThenInclude(y => y.LocalArea)
.Include(x => x.HetEquipment)
.ThenInclude(x => x.EquipmentStatusType)
.Where(x => x.District.DistrictId == districtId &&
!x.Deleted)
.OrderBy(x => x.DistrictEquipmentName)
.ToList();
foreach (HetDistrictEquipmentType equipmentType in equipmentTypes)
{
IEnumerable <HetEquipment> approvedEquipment = equipmentType.HetEquipment
.Where(x => x.EquipmentStatusType.EquipmentStatusTypeCode == HetEquipment.StatusApproved);
List <HetEquipment> hetEquipments = approvedEquipment.ToList();
equipmentType.EquipmentCount = hetEquipments.Count;
foreach (HetEquipment equipment in hetEquipments)
{
LocalAreaEquipment localAreaEquipment = equipmentType.LocalAreas
.FirstOrDefault(x => x.Id == equipment.LocalAreaId);
if (localAreaEquipment == null)
{
localAreaEquipment = new LocalAreaEquipment
{
Id = equipment.LocalArea.LocalAreaId,
Name = equipment.LocalArea.Name,
EquipmentCount = 1
};
equipmentType.LocalAreas.Add(localAreaEquipment);
}
else
{
localAreaEquipment.EquipmentCount = localAreaEquipment.EquipmentCount + 1;
}
}
// remove unnecessary data
equipmentType.HetEquipment = null;
}
return(new ObjectResult(new HetsResponse(equipmentTypes)));
}
public ActionResult ApproveConfirmed(int TransportRequisitionID)
{
var currentUser = UserAccountHelper.GetUser(User.Identity.Name).UserProfileID;
_transportRequisitionService.ApproveTransportRequisition(TransportRequisitionID, currentUser);
return(RedirectToAction("Index", "TransportRequisition"));
}
public PersonController(ApplicationDbContext dbContext,
UserManager <IdentityUser> userManager,
UserAccountHelper userAccountHelper)
{
this.context = dbContext;
this.userManager = userManager;
this.userAccountHelper = userAccountHelper;
}
public static List <RequisitionViewModel> ReturnRequisitionGroupByReuisitionNo(List <ReliefRequisition> requisition)
{
if (requisition == null)
{
return(new List <RequisitionViewModel>());
}
var result = (from req in requisition
select new RequisitionViewModel()
{
RequisitionNo = req.RequisitionNo,
RequisitionId = req.RequisitionID,
RequisitionDate = DateTime.Parse(req.RequestedDate.ToString()),
Commodity = req.Commodity.Name,
BenficiaryNo = req.ReliefRequisitionDetails.Sum(a => a.BenficiaryNo),
Amount = req.ReliefRequisitionDetails.Sum(a => a.Amount).ToPreferedWeightUnit(),
Status = int.Parse(req.Status.ToString()),
Region = req.AdminUnit.Name,
RegionId = (int)req.RegionID,
Zone = req.AdminUnit1.Name,
Program = req.Program.Name,
ProgramId = req.ProgramID,
Round = req.Round,
Month = req.Month,
MonthName = RequestHelper.GetMonthList().Find(t => t.Id == req.Month).Name,
AmountAllocated = req.ReliefRequisitionDetails.Sum(a => a.Amount),
StrRequisitionDate = req.RequestedDate.Value.ToCTSPreferedDateFormat(UserAccountHelper.UserCalendarPreference())
});
var r = new List <RequisitionViewModel>();
foreach (var req in requisition)
{
var n = new RequisitionViewModel();
n.RequisitionNo = req.RequisitionNo;
n.RequisitionId = req.RequisitionID;
n.RequisitionDate = DateTime.Parse(req.RequestedDate.ToString());
n.Commodity = req.Commodity.Name;
n.BenficiaryNo = req.ReliefRequisitionDetails.Sum(a => a.BenficiaryNo);
var m = req.ReliefRequisitionDetails.Sum(a => a.Amount);
n.Amount = m.ToPreferedWeightUnit();
n.Status = int.Parse(req.Status.ToString());
n.Region = req.AdminUnit.Name;
n.RegionId = (int)req.RegionID;
n.Zone = req.AdminUnit1.Name;
n.Program = req.Program.Name;
n.Round = req.Round;
n.Month = req.Month;
n.MonthName = RequestHelper.GetMonthList().Find(t => t.Id == req.Month).Name;
n.AmountAllocated = req.ReliefRequisitionDetails.Sum(a => a.Amount);
n.StrRequisitionDate = req.RequestedDate.Value.ToCTSPreferedDateFormat(UserAccountHelper.UserCalendarPreference());
r.Add(n);
}
return(r.ToList());
}
public virtual IActionResult RentalRequestsSearchGet([FromQuery] string localAreas, [FromQuery] string project, [FromQuery] string status, [FromQuery] DateTime?startDate, [FromQuery] DateTime?endDate)
{
int?[] localAreasArray = ArrayHelper.ParseIntArray(localAreas);
// get initial results - must be limited to user's district
int?districtId = UserAccountHelper.GetUsersDistrictId(_context, _httpContext);
IQueryable <HetRentalRequest> data = _context.HetRentalRequest.AsNoTracking()
.Include(x => x.LocalArea.ServiceArea.District.Region)
.Include(x => x.DistrictEquipmentType)
.ThenInclude(y => y.EquipmentType)
.Include(x => x.Project.PrimaryContact)
.Include(x => x.RentalRequestStatusType)
.Include(x => x.HetRentalRequestRotationList)
.OrderByDescending(x => x.AppCreateTimestamp)
.Where(x => x.LocalArea.ServiceArea.DistrictId.Equals(districtId));
if (localAreasArray != null && localAreasArray.Length > 0)
{
data = data.Where(x => localAreasArray.Contains(x.LocalArea.LocalAreaId));
}
if (project != null)
{
data = data.Where(x => x.Project.Name.ToLower().Contains(project.ToLower()));
}
if (startDate != null)
{
data = data.Where(x => x.ExpectedStartDate >= startDate);
}
if (endDate != null)
{
data = data.Where(x => x.ExpectedStartDate <= endDate);
}
if (status != null)
{
int?statusId = StatusHelper.GetStatusId(status, "rentalRequestStatus", _context);
if (statusId != null)
{
data = data.Where(x => x.RentalRequestStatusTypeId == statusId);
}
}
// convert Rental Request Model to the "RentalRequestLite" Model
List <RentalRequestLite> result = new List <RentalRequestLite>();
foreach (HetRentalRequest item in data)
{
result.Add(RentalRequestHelper.ToLiteModel(item));
}
// return to the client
return(new ObjectResult(new HetsResponse(result)));
}
public DatabaseHelperProvider(VoteMystContext context, AvatarHelper avatarHelper)
{
Context = context;
Authorization = new AuthorizationHelper(context);
Users = new UserAccountHelper(context, avatarHelper);
Entries = new EntryHelper(context);
Events = new EventHelper(context);
Votes = new VoteHelper(context);
}
/// <summary>
/// Tests the credential.
/// </summary>
/// <returns>true if valid credentials, false otherwise</returns>
private bool TestCredential()
{
bool isValidUserAccount = true;
if (this.radioDomainAccount.IsChecked.GetValueOrDefault(false))
{
isValidUserAccount = UserAccountHelper.ValidateServiceAccount();
}
return(isValidUserAccount);
}
private List <DispatchViewModel> SetDatePreference(List <DispatchViewModel> dispatches)
{
foreach (var dispatchViewModel in dispatches)
{
dispatchViewModel.CreatedDatePref =
dispatchViewModel.CreatedDate.ToCTSPreferedDateFormat(UserAccountHelper.UserCalendarPreference());
dispatchViewModel.DispatchDatePref =
dispatchViewModel.DispatchDate.ToCTSPreferedDateFormat(UserAccountHelper.UserCalendarPreference());
}
return(dispatches);
}
//public ActionResult Promote(BusinessProcessState st, int PaymentRequestID, int transporterID)
//{
// _businessProcessService.PromotWorkflow(st);
// var transporterChequeObj =
// _transporterChequeService.Get(t => t.TransporterPaymentRequestID == PaymentRequestID).FirstOrDefault();
// if (transporterChequeObj != null)
// {
// if (st.StateID == (int) Cats.Models.Constant.StateTemplate.ChequeApproved)
// {
// transporterChequeObj.AppovedBy = UserAccountHelper.GetUser(User.Identity.Name).UserProfileID;
// transporterChequeObj.AppovedDate = DateTime.Now;
// transporterChequeObj.Status = (int)Cats.Models.Constant.ChequeStatus.ChequeApproved;
// _transporterChequeService.EditTransporterCheque(transporterChequeObj);
// }
// if (st.StateID == (int)Cats.Models.Constant.StateTemplate.ChequeCollected)
// {
// transporterChequeObj.Status = (int)Cats.Models.Constant.ChequeStatus.ChequeCollected;
// _transporterChequeService.EditTransporterCheque(transporterChequeObj);
// }
// }
// return RedirectToAction("PaymentRequests", "ValidatedPaymentRequest", new {Area = "Finance", transporterID});
//}
public ActionResult TransportOrderDetail(int transportOrderID)
{
var transportOrder = _transportOrderService.Get(t => t.TransportOrderID == transportOrderID, null, "TransportOrderDetails.FDP,TransportOrderDetails.FDP.AdminUnit,TransportOrderDetails.Commodity,TransportOrderDetails.Hub,TransportOrderDetails.ReliefRequisition").FirstOrDefault();
var datePref = UserAccountHelper.GetUser(User.Identity.Name).DatePreference;
var statuses = _workflowStatusService.GetStatus(WORKFLOW.TRANSPORT_ORDER);
var transportOrderViewModel = TransportOrderViewModelBinder.BindTransportOrderViewModel(transportOrder, datePref, statuses);
ViewData["Transport.order.detail.ViewModel"] = transportOrder == null ? null :
GetDetail(transportOrder.TransportOrderDetails);
return(View(transportOrderViewModel));
}
public MyTaskList()
{
isHaveMoreItems = true;
if (roamingSettings.Values.ContainsKey(Constants.SettingName.LoadPageSize))
{
pageSize = Convert.ToInt32(roamingSettings.Values[Constants.SettingName.LoadPageSize]);
}
UserAccountHelper userAccount = new UserAccountHelper();
userName = userAccount.GetUserNameFromLocker();
}
public ActionResult LoadCheque(int transporterId, string refNo)
{
var user = UserAccountHelper.GetUser(User.Identity.Name);
var approvedPaymentRequests = _transporterPaymentRequestService.Get(t => t.BusinessProcess.CurrentState.BaseStateTemplate.StateNo == 3 && t.TransportOrder.TransporterID == transporterId);
if (refNo != "")
{
approvedPaymentRequests = _transporterPaymentRequestService.Get(t => t.BusinessProcess.CurrentState.BaseStateTemplate.StateNo == 3 && t.TransportOrder.TransporterID == transporterId && t.ReferenceNo == refNo);
}
//var transporterChequeObj = _transporterChequeService.Get(t => t.TransporterPaymentRequestID == paymentRequestID, null, "UserProfile").FirstOrDefault();
var transporterChequeViewModel = new Models.TransporterChequeViewModel();
foreach (var approvedPaymentRequest in approvedPaymentRequests)
{
var request = approvedPaymentRequest;
var dispatch = _dispatchService.Get(t => t.DispatchID == request.Delivery.DispatchID, null, "Hub, FDP").FirstOrDefault();
var bidId = _bidWinnerService.FindBy(b => b.Bid.BidNumber == dispatch.BidNumber).Select(d => d.BidID).FirstOrDefault();
var firstOrDefault = _transportOrderDetailService.Get(t => t.SourceWarehouseID == dispatch.HubID && t.FdpID == dispatch.FDPID &&
t.TransportOrder.TransporterID == request.TransportOrder.TransporterID && t.BidID == bidId).FirstOrDefault();
//var firstOrDefault = _bidWinnerService.Get(t => t.SourceID == dispatch.HubID && t.DestinationID == dispatch.FDPID
// && t.TransporterID == request.TransportOrder.TransporterID && t.Bid.BidNumber == dispatch.BidNumber).FirstOrDefault();
var tarrif = (decimal)0.00;
var deliveryDetail = request.Delivery.DeliveryDetails.FirstOrDefault() ?? new DeliveryDetail();
if (request.LabourCost == null)
{
request.LabourCost = (decimal)0.00;
}
if (request.RejectedAmount == null)
{
request.RejectedAmount = (decimal)0.00;
}
if (firstOrDefault != null)
{
tarrif = (decimal)firstOrDefault.TariffPerQtl;
}
transporterChequeViewModel.Transporter = request.TransportOrder.Transporter.Name;
transporterChequeViewModel.PaymentRequestsList = transporterChequeViewModel.PaymentRequestsList + " [" + approvedPaymentRequest.ReferenceNo + "] ";
transporterChequeViewModel.Amount = transporterChequeViewModel.Amount +
(decimal)
(approvedPaymentRequest.ShortageBirr != null
? (deliveryDetail.ReceivedQuantity.ToQuintal() * tarrif)
- approvedPaymentRequest.ShortageBirr + approvedPaymentRequest.LabourCost -
approvedPaymentRequest.RejectedAmount
: (deliveryDetail.ReceivedQuantity.ToQuintal() * tarrif) +
approvedPaymentRequest.LabourCost - approvedPaymentRequest.RejectedAmount);
}
transporterChequeViewModel.PreparedByID = user.UserProfileID;
transporterChequeViewModel.PreparedBy = user.FullName;
return(Json(transporterChequeViewModel, JsonRequestBehavior.AllowGet));
}
public ActionResult ApproveChequeInfo(int transporterChequeID)
{
var user = UserAccountHelper.GetUser(User.Identity.Name);
var transporterChequeObj = _transporterChequeService.FindById(transporterChequeID);
transporterChequeObj.AppovedBy = user.UserProfileID;
transporterChequeObj.AppovedDate = DateTime.Now;
transporterChequeObj.Status = 2;
_transporterChequeService.EditTransporterCheque(transporterChequeObj);
//var transporterChequeViewModel = BindTransporterChequeViewModel(transporterChequeObj);
return(Json(transporterChequeID, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Reset the registry values
/// </summary>
private static void ResetRegistry()
{
// sql
string sqlInstanceName = GetSQLServerInstanceNameStr(false);
string wapSqlInstanceName = GetSQLServerInstanceNameStr(true);
WriteSqlRegistryValue(SetupConstants.InstanceNameRegistryValueName, sqlInstanceName);
WriteWapSqlRegistryValue(SetupConstants.WapInstanceNameRegistryValueName, wapSqlInstanceName);
string dbName = (String)SetupInputs.Instance.FindItem(SetupInputTags.SqlDatabaseNameTag);
WriteSqlRegistryValue(SetupConstants.DBNameRegistryValueName, dbName);
string wapDBName = (String)SetupInputs.Instance.FindItem(SetupInputTags.WapSqlDatabaseNameTag);
WriteWapSqlRegistryValue(SetupConstants.WapDbNameRegistryValueName, wapDBName);
string partialConnectionString = SetupDatabaseHelper.ConstructConnectionString(sqlInstanceName);
string wapPartialConnectionString = SetupDatabaseHelper.ConstructConnectionString(wapSqlInstanceName);
string connectionString = String.Format("{0}database={1}", partialConnectionString, dbName);
string wapConnectionString = String.Format("{0}database={1}", partialConnectionString, wapDBName);
WriteSqlRegistryValue(SetupConstants.ConnectionStringRegistryValueName, connectionString);
WriteWapSqlRegistryValue(SetupConstants.ConnectionStringRegistryValueName, wapConnectionString);
string sqlMachineName = DnsHelper.GetComputerNameFromFqdnOrNetBios((String)SetupInputs.Instance.FindItem(SetupInputTags.GetSqlMachineNameTag(false)));
bool onRemoteMachine = String.Compare(sqlMachineName, Environment.MachineName, true) != 0;
WriteSqlRegistryValue(SetupConstants.OnRemoteRegistryValueName, onRemoteMachine ? 1 : 0);
WriteSqlRegistryValue(SetupConstants.MachineNameRegistryValueName, sqlMachineName);
String sqlMachineFqdn = DnsHelper.GetFullyQualifiedName(sqlMachineName);
WriteSqlRegistryValue(SetupConstants.FqdnRegistryValueName, sqlMachineFqdn);
sqlMachineName = DnsHelper.GetComputerNameFromFqdnOrNetBios((String)SetupInputs.Instance.FindItem(SetupInputTags.GetSqlMachineNameTag(true)));
onRemoteMachine = String.Compare(sqlMachineName, Environment.MachineName, true) != 0;
WriteWapSqlRegistryValue(SetupConstants.OnRemoteRegistryValueName, onRemoteMachine ? 1 : 0);
WriteWapSqlRegistryValue(SetupConstants.MachineNameRegistryValueName, sqlMachineName);
sqlMachineFqdn = DnsHelper.GetFullyQualifiedName(sqlMachineName);
WriteWapSqlRegistryValue(SetupConstants.FqdnRegistryValueName, sqlMachineFqdn);
// user name, company name under server
String userName = SetupInputs.Instance.FindItem(SetupInputTags.UserNameTag);
WriteServerRegistrationRegistryValue(SetupConstants.UserNameRegistryValueName, userName);
// VmmServiceAccount
String serviceAccount = UserAccountHelper.GetServiceAccount();
if (SetupInputs.Instance.FindItem(SetupInputTags.CmpServiceLocalAccountTag))
{
serviceAccount = SetupConstants.LocalSystem;
}
WriteConfigSettingsRegistryValue(SetupConstants.ServerSetupInfoRegKey, SetupConstants.VmmServiceAccountValueName, serviceAccount);
}
protected void Application_AuthenticateRequest(object sender, EventArgs e)
{
HttpCookie authCookie = Request.Cookies[FormsAuthentication.FormsCookieName];
if (authCookie != null && authCookie.Value != "")
{
FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value);
var identity = new UserIdentity(UserAccountHelper.GetUser(ticket.Name));
var principal = new UserPrincipal(identity);
HttpContext.Current.User = principal;
}
}
public EquipmentTypeController(DbAppContext context, IHttpContextAccessor httpContextAccessor)
{
_context = context;
// set context data
User user = UserAccountHelper.GetUser(context, httpContextAccessor.HttpContext);
_context.SmUserId = user.SmUserId;
_context.DirectoryName = user.SmAuthorizationDirectory;
_context.SmUserGuid = user.UserGuid;
_context.SmBusinessGuid = user.BusinessGuid;
}
public ActionResult Edit(HRD hrd)
{
var userid = UserAccountHelper.GetUser(HttpContext.User.Identity.Name).UserProfileID;
hrd.CreatedBY = userid;
if (ModelState.IsValid)
{
_hrdService.EditHRD(hrd);
return(RedirectToAction("Index"));
}
return(View(hrd));
}
public FileResult Print(int id)
{
var reportPath = Server.MapPath("~/Report/Procurment/TransportOrder.rdlc");
var Data = _transportOrderService.GeTransportOrderRpt(id);
var datePref = UserAccountHelper.GetUser(User.Identity.Name).DatePreference;
var reportData = vwTransportOrderViewModelBinder.BindListvwTransportOrderViewModel(Data, datePref);
var dataSourceName = "TransportOrders";
var result = ReportHelper.PrintReport(reportPath, reportData, dataSourceName);
return(File(result.RenderBytes, result.MimeType));
}
public ProvincialRateTypeController(DbAppContext context, IConfiguration configuration, IHttpContextAccessor httpContextAccessor)
{
_context = context;
_configuration = configuration;
// set context data
User user = UserAccountHelper.GetUser(context, httpContextAccessor.HttpContext);
_context.SmUserId = user.SmUserId;
_context.DirectoryName = user.SmAuthorizationDirectory;
_context.SmUserGuid = user.UserGuid;
_context.SmBusinessGuid = user.BusinessGuid;
}
public virtual IActionResult UserDistrictsGet()
{
// return for the current user only
string userId = UserAccountHelper.GetUserId(_httpContext);
List <HetUserDistrict> result = _context.HetUserDistrict.AsNoTracking()
.Include(x => x.User)
.Include(x => x.District)
.Where(x => x.User.SmUserId == userId)
.ToList();
return(new ObjectResult(new HetsResponse(result)));
}
public VersionController(DbAppContext context, IConfiguration configuration, IHttpContextAccessor httpContextAccessor, IHostingEnvironment env)
{
_context = context;
_configuration = configuration;
_env = env;
// set context data
User user = UserAccountHelper.GetUser(context, httpContextAccessor.HttpContext);
_context.SmUserId = user.SmUserId;
_context.DirectoryName = user.SmAuthorizationDirectory;
_context.SmUserGuid = user.UserGuid;
_context.SmBusinessGuid = user.BusinessGuid;
}
