public void TestBusinessLocationDecrementStock(int id, string address, string city, string zipcode, string state,
int productId, string productName, decimal productPrice, int productStock)
{
BusinessLocation location = new BusinessLocation();
location.Id = id;
location.Address = address;
location.City = city;
location.Zipcode = zipcode;
location.State = state;
BusinessProduct product = new BusinessProduct()
{
Id = productId,
Name = productName,
Price = productPrice
};
location.AddProduct(product, productStock);
int quantity = 1;
location.DecrementStock(product, quantity);
Assert.Equal(location.inventory[product], productStock - 1);
}
protected void OnBusinessLocationSelect(BusinessLocation location)
{
if (location.BusinessOrg == null)
{
SessionManager.EffLocation = location;
// uclSearchBar.TitleItem.Text = "- " + location.Company.COMPANY_NAME;
uclSearchBar.SetButtonsEnabled(false, false, false, false, false, false);
}
else if (location.Plant == null)
{
SessionManager.EffLocation = location;
pnlSearchList.Visible = uclBusLoc.LocationSelectPanel.Visible = false;
divPageBody.Visible = uclAdminTabs.BusOrgPanel.Visible = true;
uclSearchBar.SetButtonsNotClicked();
uclSearchBar.SetButtonsEnabled(false, false, false, false, false, true);
SetupPage();
tab_Click("lbBusOrgDetail_tab", "");
}
else
{
SessionManager.EffLocation = location;
SetLocalOrg(null);
uclSearchBar.SetButtonsNotClicked();
uclSearchBar.SetButtonsEnabled(false, false, false, false, false, true);
Response.Redirect("/Admin/Administrate_ViewPlant.aspx");
}
}
public void TestBusinessLocationDecrementStockWhenProductNotInStock(int id, string address, string city, string zipcode, string state,
int productId, string productName, decimal productPrice, int productStock)
{
BusinessLocation location = new BusinessLocation();
location.Id = id;
location.Address = address;
location.City = city;
location.Zipcode = zipcode;
location.State = state;
BusinessProduct product = new BusinessProduct()
{
Id = productId,
Name = productName,
Price = productPrice
};
location.AddProduct(product, productStock);
BusinessProduct productNotInStock = new BusinessProduct()
{
Id = productId + 1,
Name = productName + "a",
Price = productPrice + 1
};
int quantity = 10;
Assert.Throws <BusinessLocationException>(() => location.DecrementStock(productNotInStock, quantity));
}
// GET api/rosterapi?businessId=1231232&startDate=12312&endDate=1232132
public IEnumerable <RosterDTO> GetRostersForBusiness(Guid businessLocationId, string startDate, string endDate)
{
DateTime sDate = DateTime.Parse(startDate);
DateTime eDate = DateTime.Parse(endDate);
BusinessLocation businessLocation = db.BusinessLocations.Find(businessLocationId);
if (businessLocation == null)
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
if (ClaimsAuthorization.CheckAccess("Get", "BusinessId", businessLocation.Business.Id.ToString()))
{
var rosterList = db.Rosters.Where(r => r.BusinessLocation.Id == businessLocationId && r.WeekStartDate >= sDate && r.WeekStartDate <= eDate);
if (rosterList == null)
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(MapperFacade.MapperConfiguration.Map <IEnumerable <Roster>, IEnumerable <RosterDTO> >(rosterList.AsEnumerable()));
}
else
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
}
public HttpResponseMessage PostinternalLocation(Guid businesslocationId, Guid internalLocationId, InternalLocationDTO internalLocationDTO)
{
BusinessLocation businessLocation = db.BusinessLocations.Find(businesslocationId);
if (businessLocation == null)
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
if (ClaimsAuthorization.CheckAccess("Put", "BusinessLocationId", businessLocation.Id.ToString()))
{
if (ModelState.IsValid)
{
var location = MapperFacade.MapperConfiguration.Map <InternalLocationDTO, InternalLocation>(internalLocationDTO);
location.Id = Guid.NewGuid(); //Assign new ID on save.
location.Enabled = true;
//Lookup Business and attach, so that no updates or inserts are performed on BusinessType lookup table
location.BusinessLocation = db.BusinessLocations.SingleOrDefault(b => b.Id == businesslocationId);
db.InternalLocations.Add(location);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
else
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
}
public BusinessLocation ProblemBusinessLocation()
{
BusinessLocation problemLocation = new BusinessLocation();
if (this.IncidentList != null && this.IncidentList.Count > 0)
{
INCIDENT incident = this.IncidentList[0];
if (incident.INCIDENT_TYPE == "QI")
{
problemLocation.Company = SQMModelMgr.LookupCompany((decimal)incident.RESP_COMPANY_ID);
problemLocation.BusinessOrg = SQMModelMgr.LookupBusOrg((decimal)incident.RESP_BUS_ORG_ID);
problemLocation.Plant = SQMModelMgr.LookupPlant((decimal)incident.RESP_PLANT_ID);
}
else
{
problemLocation.Company = SQMModelMgr.LookupCompany((decimal)incident.DETECT_COMPANY_ID);
problemLocation.BusinessOrg = SQMModelMgr.LookupBusOrg((decimal)incident.DETECT_BUS_ORG_ID);
problemLocation.Plant = SQMModelMgr.LookupPlant((decimal)incident.DETECT_PLANT_ID);
}
}
else
{
problemLocation.Company = this.ProbCase.COMPANY;
}
return(problemLocation);
}
public static object Map(this BusinessLocation location, long eventId)
{
return(new
{
EventId = eventId,
BusinessLocationId = location.Id,
location.CustomFields
});
}
public ActionResult LocationTemplate(int id, BusinessLocation u, HttpPostedFileBase ImageURL = null)
{
string fullPath = null;
if (ImageURL != null)
{
var path = System.IO.Path.GetFileName(ImageURL.FileName);
fullPath = "/Content/images/" + MD5Hasher.Hash(DateTime.Now.ToShortTimeString() + DateTime.Now.ToShortDateString()) + path;
fullPath = fullPath.Replace(" ", "_");
ImageURL.SaveAs(Server.MapPath(fullPath));
}
int uid;
string utoken;
HttpCookie cookie = Request.Cookies["User"];
if (cookie != null)
{
uid = int.Parse(cookie["id"]);
utoken = cookie["token"];
}
else
{
uid = 0;
utoken = null;
}
if (auth.CheckAuthStatus(uid, utoken) && auth.GetCurrentUser(cookie)["Role"] == "1")
{
ViewBag.RoleNum = auth.GetCurrentUser(cookie)["Role"];
ViewBag.User = auth.GetCurrentUser(cookie)["User"];
ViewBag.Role = db.Roles.Find(int.Parse(auth.GetCurrentUser(cookie)["Role"])).Name;
if (id == 0)
{
u.ImageURL = fullPath;
db.BusinessLocation.Add(u);
}
else
{
db.BusinessLocation.Find(id).Name = u.Name;
db.BusinessLocation.Find(id).Email = u.Email;
db.BusinessLocation.Find(id).Description = u.Description;
db.BusinessLocation.Find(id).ImageURL = fullPath;
db.BusinessLocation.Find(id).IsPartner = u.IsPartner;
db.BusinessLocation.Find(id).Latitude = u.Latitude;
db.BusinessLocation.Find(id).Longtitude = u.Longtitude;
db.BusinessLocation.Find(id).PhoneNumber = u.PhoneNumber;
}
db.SaveChanges();
return(Redirect("~/Locations"));
}
else
{
return(Redirect("~/Login"));
}
}
public void BindBusinessLocation(BusinessLocation businessLocation, bool bindAll, bool allowChange, bool showLocationInputs, bool showHeader)
{
newLocation = currentLocation = businessLocation;
staticShowHeader = showHeader;
if (allowChange)
{
pnlBusinessLocEdit.Visible = true;
if (newLocation.Company != null)
{
lblSelCompany.Text = newLocation.Company.COMPANY_NAME;
}
if (bindAll)
{
if (newLocation.BusinessOrg != null)
{
lblSelBusOrg.Text = newLocation.BusinessOrg.ORG_NAME;
}
if (newLocation.Plant != null)
{
lblSelPlant.Text = newLocation.Plant.PLANT_NAME;
}
}
else
{
lblSelBusOrg.Visible = lblSelPlant.Visible = false;
}
}
else
{
pnlBusinessLoc.Visible = true;
if (newLocation.Company != null)
{
lblUserCompany.Text = newLocation.Company.COMPANY_NAME;
}
if (bindAll)
{
if (newLocation.BusinessOrg != null)
{
lblUserBusOrg.Text = newLocation.BusinessOrg.ORG_NAME;
}
if (newLocation.Plant != null)
{
lblUserPlant.Text = newLocation.Plant.PLANT_NAME;
}
}
}
if (showLocationInputs)
{
lblSelCompany.Visible = pnlLocationText.Visible = btnCancel.Visible = true;
//btnReset.Visible = true;
}
}
protected void OnBusinessLocationAdd(BusinessLocation location)
{
if (location.BusinessOrg != null)
{
SessionManager.EffLocation = location;
SetLocalOrg(null);
uclSearchBar.SetButtonsNotClicked();
uclSearchBar.SetButtonsEnabled(false, false, false, false, false, true);
Response.Redirect("/Admin/Administrate_ViewPlant.aspx");
}
}
public void BindApproverListR(List <INCFORMAPPROVERLIST> ApproverItemList, BusinessLocation businessLocation, string context)
{
hfApproverActionContext.Value = context;
if (context != "company")
{
hfApproverActionBusLoc.Value = context == "plant" ? businessLocation.Plant.PLANT_ID.ToString() : businessLocation.BusinessOrg.BUS_ORG_ID.ToString();
}
pnlApproverAction.Visible = true;
rgRegionalApproverAction.DataSource = ApproverItemList;
rgRegionalApproverAction.DataBind();
}
private void ApplyWorkingLocation(BusinessLocation newLocation)
{
if (newLocation == null)
{
SessionManager.UserContext.WorkingLocation = SessionManager.UserContext.HRLocation;
}
else
{
SessionManager.UserContext.WorkingLocation = newLocation;
uclPrefsEdit.BindUser(null, SessionManager.UserContext.HRLocation, SessionManager.UserContext.WorkingLocation);
}
Server.Transfer(Request.Path);
}
private Roster CreateRosterForWeekStarting(RosterCreateDTO rosterCreateDTO, BusinessLocation businessLocation, int weeksToAdd = 0)
{
var roster = MapperFacade.MapperConfiguration.Map <RosterCreateDTO, Roster>(rosterCreateDTO);
roster.Id = Guid.NewGuid(); //Assign new ID on save.
roster.BusinessLocation = businessLocation;
roster.WeekStartDate = roster.WeekStartDate.AddDays(7 * weeksToAdd);
roster.Timesheet = new Timesheet {
Id = Guid.NewGuid()
};
//Add template shifts to roster
if (rosterCreateDTO.UseShiftTemplates)
{
//First set up all recurring weekly shifs
var weeklyShiftTemplates = new List <ShiftTemplate>();
weeklyShiftTemplates.AddRange(businessLocation.ShiftTemplates.Where(st => st.Frequency == ShiftFrequency.Weekly && st.Enabled));
CreateShiftsFromTemplates(roster, weeklyShiftTemplates);
//Then set up any once off shifts for this week
var oneOffShiftTemplates = new List <ShiftTemplate>();
oneOffShiftTemplates.AddRange(businessLocation.ShiftTemplates.Where(st => st.Frequency == ShiftFrequency.OneOff && st.WeekStarting == roster.WeekStartDate && st.Enabled));
CreateShiftsFromTemplates(roster, oneOffShiftTemplates);
var weekOfYear = WebUI.Common.Common.GetWeekOfYear(roster.WeekStartDate);
//If this is an odd week in the year then apply fortnight1 (this is due to 1st week of year being off, so start year on fortnight1)
if (weekOfYear % 2 == 1)
{
var firstWeekShiftTemplates = businessLocation.ShiftTemplates.Where(st => st.Frequency == ShiftFrequency.Fortnight1 && st.Enabled).ToList();
CreateShiftsFromTemplates(roster, firstWeekShiftTemplates);
}
else //Every other week apply Fortnight2
{
var secondWeekShiftTemplates = businessLocation.ShiftTemplates.Where(st => st.Frequency == ShiftFrequency.Fortnight2 && st.Enabled);
CreateShiftsFromTemplates(roster, secondWeekShiftTemplates);
}
if (weeksToAdd == 3) //If we have added at least 4 weeks (ie one month) then insert monthly template
{
var monthShiftTemplates = businessLocation.ShiftTemplates.Where(st => st.Frequency == ShiftFrequency.Monthly && st.Enabled);
CreateShiftsFromTemplates(roster, monthShiftTemplates);
}
}
return(roster);
}
private void SetupPage()
{
if (langList == null || langList.Count == 0)
{
langList = SQMModelMgr.SelectLanguageList(new PSsqmEntities(), true);
uclPrefsEdit.SetLanguageList(langList);
}
BusinessLocation businessLocation = new BusinessLocation(); businessLocation = SessionManager.UserContext.HRLocation;
List <decimal> respForList = new List <decimal>();
respForList.Add(SessionManager.UserContext.Person.PERSON_ID);
respForList.AddRange(SessionManager.UserContext.DelegateList);
SessionManager.UserContext.TaskList.Clear();
SessionManager.UserContext.TaskList = new List <TaskItem>();
AccessMode accessmode;
DateTime fromDate = DateTime.Now.AddMonths(-6);
if ((accessmode = UserContext.RoleAccess()) > AccessMode.Limited)
{
SessionManager.UserContext.TaskList.AddRange(TaskMgr.ProfileInputStatus(new DateTime(fromDate.Year, fromDate.Month, 1), new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day), respForList, SessionManager.UserContext.EscalationAssignments));
SessionManager.UserContext.TaskList.AddRange(TaskMgr.IncidentTaskStatus(SessionManager.UserContext.HRLocation.Company.COMPANY_ID, respForList, SessionManager.UserContext.EscalationAssignments, true));
if (accessmode == AccessMode.Admin && SessionManager.UserContext.EscalationAssignments.Count > 0)
{
SessionManager.UserContext.TaskList.AddRange(TaskMgr.ProfileFinalizeStatus(new DateTime(fromDate.Year, fromDate.Month, 1), new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day), respForList, SessionManager.UserContext.EscalationAssignments, SessionManager.UserContext.Person));
}
}
lblTaskCount0.Text = SessionManager.UserContext.TaskList.Where(l => l.NotifyType == TaskNotification.Owner).Count().ToString();
uclTaskList0.BindTaskList(SessionManager.UserContext.TaskList.Where(l => l.NotifyType == TaskNotification.Owner).OrderBy(l => l.RecordType).ThenByDescending(l => l.Task.DUE_DT).ToList());
lblTaskCount1.Text = SessionManager.UserContext.TaskList.Where(l => l.NotifyType == TaskNotification.Delegate).Count().ToString();
if (lblTaskCount1.Text != "0")
{
divTaskList1.Visible = pnlTaskList1.Visible = true;
uclTaskList1.BindTaskList(SessionManager.UserContext.TaskList.Where(l => l.NotifyType == TaskNotification.Delegate).OrderBy(l => l.RecordType).ThenByDescending(l => l.Task.DUE_DT).ToList());
}
lblTaskCount2.Text = SessionManager.UserContext.TaskList.Where(l => l.NotifyType == TaskNotification.Escalation).Count().ToString();
if (lblTaskCount2.Text != "0")
{
divTaskList2.Visible = pnlTaskList2.Visible = true;
uclTaskList2.BindTaskList(SessionManager.UserContext.TaskList.Where(l => l.NotifyType == TaskNotification.Escalation).OrderBy(l => l.RecordType).ThenByDescending(l => l.Task.DUE_DT).ToList());
}
++SessionManager.UserContext.InboxReviews;
}
/// <summary>
/// Retrieves all of the locations in the database.
/// </summary>
/// <returns>All BusinessLocation objects in the database</returns>
public static ICollection <BusinessLocation> GetLocations()
{
Log.Information($"Called the Data Access method to get the all locations");
using var context = new TThreeTeasContext(SQLOptions.options);
List <BusinessLocation> bLocations = new List <BusinessLocation>();
foreach (Location location in context.Location)
{
BusinessLocation bLocation = GetLocationWithId(location.Id);
bLocations.Add(bLocation);
}
return(bLocations);
}
public void BindPrivGroups(List <PRIVGROUP> privGroupList, BusinessLocation businessLocation, string context)
{
hfPrivGroupContext.Value = context;
if (ddlPrivGroupStatus.Items.Count == 0)
{
XLATList = SQMBasePage.SelectXLATList(new string[3] {
"ACTIVE_STATUS", "PRIV_PRIV", "PRIV_SCOPE"
});
ddlPrivGroupStatus.DataSource = XLATList.Where(x => x.XLAT_GROUP == "ACTIVE_STATUS").ToList();
ddlPrivGroupStatus.DataValueField = "XLAT_CODE";
ddlPrivGroupStatus.DataTextField = "DESCRIPTION";
ddlPrivGroupStatus.DataBind();
}
if (ddlScope.Items.Count == 0)
{
ddlScope.DataSource = XLATList.Where(x => x.XLAT_GROUP == "PRIV_SCOPE").ToList();
ddlScope.DataValueField = "XLAT_CODE";
ddlScope.DataTextField = "DESCRIPTION";
ddlScope.DataBind();
}
if (ddlPriviledge.Items.Count == 0)
{
ddlPriviledge.DataSource = XLATList.Where(x => x.XLAT_GROUP == "PRIV_PRIV").ToList();
ddlPriviledge.DataValueField = "XLAT_CODE";
ddlPriviledge.DataTextField = "DESCRIPTION";
ddlPriviledge.DataBind();
RadComboBoxItem item = new RadComboBoxItem("", "select a priviledge level");
ddlPriviledge.Items.Insert(0, item);
try
{
item = ddlPriviledge.FindItemByValue("100");
item.Enabled = false;
}
catch { }
}
defaultPrivs = SQMSettings.SelectSettingsGroup("DEFAULT_PRIVS", "");
pnlPrivGroups.Visible = true;
rgPrivGroup.DataSource = privGroupList;
rgPrivGroup.DataBind();
}
public void TestBusinessLocationSettersAndGetters(int id, string address, string city, string zipcode, string state,
int expectedId, string expectedAddress, string expectedCity, string expectedZipcode, string expectedState)
{
BusinessLocation location = new BusinessLocation();
location.Id = id;
location.Address = address;
location.City = city;
location.Zipcode = zipcode;
location.State = state;
Assert.Equal(expectedId, id);
Assert.Equal(expectedAddress, address);
Assert.Equal(expectedCity, city);
Assert.Equal(expectedZipcode, zipcode);
Assert.Equal(expectedState, state);
}
public void BindUser(PERSON person, BusinessLocation HRLocation, BusinessLocation workingLocation)
{
ToggleVisible(pnlUserPrefEdit);
PERSON user = person;
if (user == null)
{
user = SessionManager.UserContext.Person;
}
tbUserPhone.Text = user.PHONE;
if (HRLocation != null)
{
uclHRLoc.BindBusinessLocation(HRLocation, true, false, true, false);
}
}
private void SetupPage()
{
if (langList == null || langList.Count == 0)
{
langList = SQMModelMgr.SelectLanguageList(new PSsqmEntities(), true);
uclPrefsEdit.SetLanguageList(langList);
}
BusinessLocation businessLocation = new BusinessLocation(); businessLocation = SessionManager.UserContext.HRLocation;
uclPrefsEdit.BindUser(null, SessionManager.UserContext.HRLocation, SessionManager.UserContext.WorkingLocation);
if (UserContext.CheckAccess("CQM", "home", "92") == AccessMode.None)
{
uclPrefsEdit.DelegateList.Attributes.Add("disabled", "true");
}
// quality tasks
if (uclTaskList.TaskListRepeater.Items.Count < 1)
{
bool hasDelegates;
List <TaskItem> taskList = new List <TaskItem>();
// taskList = QualityIssue.IncidentTaskList(SessionManager.UserContext.HRLocation.Company.COMPANY_ID, SessionManager.UserContext.Person.PERSON_ID, false, out hasDelegates);
// EHS inputs
if (UserContext.CheckAccess("EHS", "input", "301") > AccessMode.View)
{
if (respForList == null || respForList.Count == 0)
{
respForList = SQMModelMgr.SelectDelegateList(SessionManager.UserContext.Person.PERSON_ID);
respForList.Insert(0, SessionManager.UserContext.Person);
}
decimal[] pids = respForList.Select(l => l.PERSON_ID).ToArray();
taskList.AddRange(EHSModel.ProfileTaskList(EHSModel.GetIncompleteInputs(pids, DateTime.Now.AddMonths(-12))));
}
// Problem cases
if (UserContext.CheckAccess("CQM", "prob", "151") > AccessMode.View)
{
taskList.AddRange(ProblemCase.CaseTaskList(SessionManager.UserContext.HRLocation.Company.COMPANY_ID, SessionManager.UserContext.Person.PERSON_ID, false, out hasDelegates));
}
// taskList = taskList.OrderBy(l => l.RecordType).ThenBy(l => l.RecordID).ToList();
uclTaskList.BindTaskList(taskList);
}
}
public BusinessLocationDTO GetBusinessLocation(Guid businesslocationid)
{
BusinessLocation businessLocation = db.BusinessLocations.Find(businesslocationid);
if (businessLocation == null)
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
if (ClaimsAuthorization.CheckAccess("Get", "BusinessId", businessLocation.Business.Id.ToString()))
{
return(MapperFacade.MapperConfiguration.Map <BusinessLocation, BusinessLocationDTO>(businessLocation));
}
else
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
}
public void BindNotfyPlan(List <NOTIFYACTION> notifyItemList, BusinessLocation businessLocation, string context)
{
XLATList = SQMBasePage.SelectXLATList(new string[4] {
"NOTIFY_SCOPE", "NOTIFY_SCOPE_TASK", "NOTIFY_TASK_STATUS", "NOTIFY_TIMING"
});
hfNotifyActionContext.Value = context;
hfNotifyActionBusLoc.Value = context == "plant" ? businessLocation.Plant.PLANT_ID.ToString() : businessLocation.BusinessOrg.BUS_ORG_ID.ToString();
ddlNotifyScope.DataSource = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_SCOPE").ToList();
ddlNotifyScope.DataValueField = "XLAT_CODE";
ddlNotifyScope.DataTextField = "DESCRIPTION";
ddlNotifyScope.DataBind();
ddlScopeTask.DataSource = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_SCOPE_TASK").ToList();
ddlScopeTask.DataValueField = "XLAT_CODE";
ddlScopeTask.DataTextField = "DESCRIPTION";
ddlScopeTask.DataBind();
ddlScopeStatus.DataSource = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_TASK_STATUS").ToList();
ddlScopeStatus.DataValueField = "XLAT_CODE";
ddlScopeStatus.DataTextField = "DESCRIPTION";
ddlScopeStatus.DataBind();
ddlScopeTiming.DataSource = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_TIMING").ToList();
ddlScopeTiming.DataValueField = "XLAT_CODE";
ddlScopeTiming.DataTextField = "DESCRIPTION";
ddlScopeTiming.DataBind();
foreach (PRIVGROUP pg in SQMModelMgr.SelectPrivGroupList(new SysPriv[2] {
SysPriv.admin, SysPriv.notify
}, SysScope.incident, "A").ToList())
{
ddlNotifyPrivGroup.Items.Add(new RadComboBoxItem(SQMModelMgr.FormatPrivGroup(pg), pg.PRIV_GROUP));
}
pnlNotifyAction.Visible = true;
hfNotifyActionContext.Value = context;
rgNotifyAction.DataSource = notifyItemList;
rgNotifyAction.DataBind();
}
public ActionResult LocationTemplate(int id)
{
int uid;
string utoken;
HttpCookie cookie = Request.Cookies["User"];
if (cookie != null)
{
uid = int.Parse(cookie["id"]);
utoken = cookie["token"];
}
else
{
uid = 0;
utoken = null;
}
if (auth.CheckAuthStatus(uid, utoken) && auth.GetCurrentUser(cookie)["Role"] == "1")
{
ViewBag.RoleNum = auth.GetCurrentUser(cookie)["Role"];
ViewBag.User = auth.GetCurrentUser(cookie)["User"];
ViewBag.Role = db.Roles.Find(int.Parse(auth.GetCurrentUser(cookie)["Role"])).Name;
ViewBag.UID = id;
ViewBag.Roles = db.Roles;
ViewBag.Companies = db.Company.OrderBy(a => a.Name);
ViewBag.Part = "Locations";
if (id == 0)
{
return(View(new BusinessLocation {
}));
}
else
{
BusinessLocation a = db.BusinessLocation.Find(id);
return(View(a));
}
}
else
{
return(Redirect("~/Login"));
}
}
protected void btnListCompanies_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
pnlSelectCompany.Visible = true;
switch (btn.CommandArgument)
{
case "prime":
SelectCompany(SessionManager.UserContext.HRLocation.Company.COMPANY_ID);
return;
break;
case "cust":
uclCompanyList.BindCompanyList(SQMModelMgr.SelectCompanyList(new PSsqmEntities(), true, false, false));
btnCancel.Enabled = true;
break;
case "supp":
uclCompanyList.BindCompanyList(SQMModelMgr.SelectCompanyList(new PSsqmEntities(), false, true, false));
btnCancel.Enabled = true;
break;
case "reset":
pnlSelectCompany.Visible = btnCancel.Enabled = false;
newLocation = null;
lblSelCompany.Text = lblSelBusOrg.Text = lblSelPlant.Text = "";
break;
default: // cancel
pnlSelectCompany.Visible = btnCancel.Enabled = false;
BindBusinessLocation(currentLocation, true, true, true, false);
if (OnBusinessLocationChange != null)
{
OnBusinessLocationChange(currentLocation);
}
break;
}
uclCompanyList.CloseCompanyListButton.Visible = false;
btn.Focus();
}
protected void SelectCompany(decimal companyID)
{
if (companyID > 0)
{
newLocation = new BusinessLocation();
newLocation.Company = (COMPANY)SQMModelMgr.LookupCompany(companyID);
lblSelBusOrg.Text = lblSelPlant.Text = "";
if (staticShowHeader)
{
uclItemHdr.DisplayCompanyData(newLocation.Company, SQMModelMgr.PersonCount(companyID));
}
uclCompanyList.BindOrgListRepeater(SQMModelMgr.SearchBusOrgList(new PSsqmEntities(), companyID, "", false).OrderBy(l => l.BUS_ORG_ID).ToList());
if (OnCompanyChange != null)
{
OnCompanyChange(newLocation);
}
}
else
{
pnlSelectCompany.Visible = false;
}
}
public ActionResult SearchByLocation(float latitude, float longitude, int tipo_comercio)
{
List <UserInformation> BusinessLocation;
try
{
using (var db = _context)
{
BusinessLocation = db.UserInformation.FromSql("SELECT * FROM UserInformation WHERE dbo.DistanceBetween({0}, {1}, Latitude, Longitude) < 5", latitude, longitude).ToList();
// return BusinessLocation.AsQueryable();
}
}
catch (Exception ex)
{
throw;
}
var jsonBusiness = from business in BusinessLocation.AsEnumerable()
select JsonComercioFromComercio(business);
return(Json(jsonBusiness.ToList()));
//return View();
}
/// <summary>
/// Retrieves the BusinessOrder with the given order id
/// </summary>
/// <param name="orderId">The id of the order</param>
/// <returns>The BusinessOrder object with the given order id</returns>
public static BusinessOrder GetOrderWithId(int orderId)
{
Log.Information($"Called the Data Access method to get the order with order id {orderId}");
using var context = new TThreeTeasContext(SQLOptions.options);
Orders order = context.Orders.FirstOrDefault(o => o.Id == orderId);
if (order is null)
{
return(null);
}
BusinessLocation bLocation = LocationData.GetLocationWithId(order.LocationId);
BusinessCustomer bCustomer = CustomerData.GetCustomerWithId(order.CustomerId);
BusinessOrder bOrder = new BusinessOrder
{
Id = order.Id,
StoreLocation = bLocation,
Customer = bCustomer,
OrderTime = order.OrderTime
};
Dictionary <BusinessProduct, int> lineItems = new Dictionary <BusinessProduct, int>();
foreach (LineItem item in context.LineItem.Where(l => l.OrdersId == order.Id).ToList())
{
Product product = context.Product.Where(p => p.Id == item.ProductId).FirstOrDefault();
BusinessProduct bProduct = new BusinessProduct()
{
Id = product.Id,
Name = product.Name,
Price = product.Price
};
lineItems.Add(bProduct, item.Quantity);
}
bOrder.AddLineItems(lineItems);
return(bOrder);
}
public void TestBusinessLocationAddProduct(int id, string address, string city, string zipcode, string state,
int productId, string productName, decimal productPrice, int productStock)
{
BusinessLocation location = new BusinessLocation();
location.Id = id;
location.Address = address;
location.City = city;
location.Zipcode = zipcode;
location.State = state;
BusinessProduct product = new BusinessProduct()
{
Id = productId,
Name = productName,
Price = productPrice
};
location.AddProduct(product, productStock);
Assert.True(location.inventory.ContainsKey(product));
Assert.Equal(location.inventory[product], productStock);
}
/// <summary>
/// Retrieves the location with the given location id.
/// </summary>
/// <param name="locationId">The id of the location</param>
/// <returns>
/// The BusinessLocation object that maps to the location with the given location id
/// </returns>
public static BusinessLocation GetLocationWithId(int locationId)
{
Log.Information($"Called the Data Access method to get the location with location id {locationId}");
using var context = new TThreeTeasContext(SQLOptions.options);
Location location = context.Location.Where(l => l.Id == locationId).FirstOrDefault();
if (location is null)
{
return(null);
}
BusinessLocation bLocation = new BusinessLocation()
{
Id = location.Id,
Address = location.Address,
City = location.City,
Zipcode = location.Zipcode,
State = location.State
};
List <Inventory> inventories = context.Inventory.Where(i => i.LocationId == location.Id).ToList();
foreach (Inventory inventory in inventories)
{
Product product = context.Product.Where(p => p.Id == inventory.ProductId).FirstOrDefault();
BusinessProduct bProduct = new BusinessProduct()
{
Id = product.Id,
Name = product.Name,
Price = product.Price
};
bLocation.AddProduct(bProduct, inventory.Stock);
}
return(bLocation);
}
public static RadComboBoxItem SetLocationItem(BusinessLocation loc, bool formal)
{
RadComboBoxItem item = null;
if (loc != null)
{
if (formal)
{
item = new RadComboBoxItem(loc.Company.COMPANY_NAME + ", " + loc.Plant.PLANT_NAME, loc.Plant.PLANT_ID.ToString());
}
else
{
item = new RadComboBoxItem(loc.Plant.PLANT_NAME, loc.Plant.PLANT_ID.ToString());
}
ADDRESS address = loc.Plant.ADDRESS.FirstOrDefault();
if (address != null)
{
item.ToolTip = address.STREET1 + " " + address.CITY;
}
}
return(item);
}
public void RefreshOrgList(BusinessLocation location)
{
pnlSelectCompany.Visible = true;
SelectCompany(location.Company.COMPANY_ID);
}
/// <summary>
/// Adds a new location to a player
/// </summary>
/// <param name="player"></param>
public void AddNewLocation(GamePlayer player)
{
BusinessLocation location = new BusinessLocation();
LocationStorage storage = new LocationStorage();
storage.Items = new Dictionary<BuildableItemEnum, ItemQuantity>();
location.Storage = storage;
player.Locations.Add(location);
AddItem(player,
0, new ItemQuantity
{
ItemCode = BuildableItemEnum.Dry_Goods_Delivery_Truck,
UnStoredQuantity = 1,
StoredQuantity = 0,
Level = 0
});
AddItem(player,
0, new ItemQuantity
{
ItemCode = BuildableItemEnum.Vegetable_Farm_Delivery_Truck,
UnStoredQuantity = 1,
StoredQuantity = 0,
Level = 0
});
AddItem(player,
0, new ItemQuantity
{
ItemCode = BuildableItemEnum.Restaurant_Storage,
UnStoredQuantity = 1,
StoredQuantity = 0,
Level = 0
});
AddItem(player,
0, new ItemQuantity
{
ItemCode = BuildableItemEnum.Dirty_Table,
UnStoredQuantity = 1,
StoredQuantity = 0,
Level = 0
});
AddItem(player,
0, new ItemQuantity
{
ItemCode = BuildableItemEnum.Dirty_Dishes,
UnStoredQuantity = 1,
StoredQuantity = 0,
Level = 0
});
AddItem(player,
0, new ItemQuantity
{
ItemCode = BuildableItemEnum.Dirty_Floor,
UnStoredQuantity = 1,
StoredQuantity = 0,
Level = 0
});
}
