public IEnumerable <AspNetUser> GetUsers()
{
var context2 = new DevDetective2Entities();
var context1 = new DevDetectiveEntities1();
var usersIds = context1.FacilityUsers.Where(x => x.Facility.TenantId == _tenantId).Select(x => x.UserId).ToList();
var users = context2.AspNetUsers.Where(x => !usersIds.Contains(x.Email));
return(users);
}
protected void CreateFacility(object sender, EventArgs e)
{
var dataContext = new DevDetectiveEntities1();
int parentFacilityId = -1;
int.TryParse(ParentFacilityId.Text, out parentFacilityId);
var faciliy = new Facility()
{
TenantId = _tenantId,
CreatedDate = DateTime.Now,
UpdateDate = DateTime.Now,
Name = FacilityName.Text,
};
if (parentFacilityId != -1 && parentFacilityId != 0)
{
faciliy.ParentFacilityId = parentFacilityId;
}
else
{
faciliy.ParentFacilityId = null;
}
dataContext.Facilities.Add(faciliy);
dataContext.SaveChanges();
if (InitializeDataCheckBox.Checked)
{
var inventoryItemTypes = dataContext.InventoryItemTypes.Where(x => x.IsActive).ToList();
var facilityInventoryItemTypes = inventoryItemTypes.Select(inventoryItemType =>
new FacilityInventoryItemType()
{
FacilityId = faciliy.Id,
CreatedDate = DateTime.Now,
UpdateDate = DateTime.Now,
InventoryItemTypeId = inventoryItemType.Id,
IsActive = true,
Name = inventoryItemType.Name,
SKU = inventoryItemType.SKU,
QuantityOnHand = 0,
QuantityOnOrder = 0
}).ToList();
dataContext.FacilityInventoryItemTypes.AddRange(facilityInventoryItemTypes);
dataContext.SaveChanges();
}
FacilityGridView.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
int.TryParse(Request.QueryString["id"], out _id);
var context = new DevDetectiveEntities1();
_facility = context.Facilities.FirstOrDefault(x => x.Id == _id);
if (_facility != null)
{
FacilityName.Text = _facility.Name;
}
}
protected void CreateFacilityUser(object sender, EventArgs e)
{
var context2 = new DevDetective2Entities();
var context1 = new DevDetectiveEntities1();
var userEmail = UserIdTextBox.Text;
var user = context2.AspNetUsers.FirstOrDefault(x => x.Email == userEmail);
if (user == null)
{
throw new Exception("Todo add an error message");
}
int facilityId = -100000;
int.TryParse(FacilityIdTextBox.Text, out facilityId);
var facilities = context1.Facilities.Where(x => x.TenantId == _tenantId).ToList();
var matchingFacility = facilities.FirstOrDefault(x => x.Id == facilityId);
if (matchingFacility != null)
{
var fu = new FacilityUser();
fu.UserId = userEmail;
fu.FacilityId = matchingFacility.Id;
matchingFacility.FacilityUsers.Add(fu);
var childFacilities = matchingFacility.Facilities1;
foreach (var child in childFacilities)
{
var childFu = new FacilityUser();
childFu.UserId = userEmail;
matchingFacility.ParentFacilityId = _tenantId;
childFu.FacilityId = child.Id;
child.FacilityUsers.Add(childFu);
}
}
else
{
foreach (var facility in facilities)
{
var fu = new FacilityUser();
fu.UserId = userEmail;
fu.FacilityId = facility.Id;
facility.FacilityUsers.Add(fu);
}
}
context1.SaveChanges();
}
protected void SubmitForm(object sender, EventArgs e)
{
var tenant = new Tenant {
Name = TenantName.Text, CreatedDate = DateTime.Now, UpdateDate = DateTime.Now, IsActive = true
};
var dataContext = new DevDetectiveEntities1();
dataContext.Tenants.Add(tenant);
dataContext.SaveChanges();
TenantName.Text = string.Empty;
TenantGridView.DataBind();
}
protected void SubmitForm(object sender, EventArgs e)
{
var context = new DevDetectiveEntities1();
var facilityInvItem = new FacilityInventoryItemType
{
CreatedDate = DateTime.Now,
FacilityId = _id,
IsActive = true,
Name = FacilityProductItemName.Text
};
context.FacilityInventoryItemTypes.Add(facilityInvItem);
context.SaveChanges();
}
protected void SaveFacilityItems(object sender, EventArgs e)
{
var context = new DevDetectiveEntities1();
var items = context.FacilityInventoryItemTypes.Where(x => x.FacilityId == _id).ToList();
foreach (GridViewRow gridViewRow in FacilityInventoryItemGridView.Rows)
{
var quantityOnOrderTextBox = (TextBox)gridViewRow.FindControl("QuantityOnOrder");
var quantityOnHandTextBox = (TextBox)gridViewRow.FindControl("QuantityOnHand");
var priceTextBox = (TextBox)gridViewRow.FindControl("Price");
var idLabel = (HiddenField)gridViewRow.FindControl("HiddenId");
var id = int.Parse(idLabel.Value);
var item = items.FirstOrDefault(x => x.Id == id);
if (item != null)
{
int quantityOnOder;
int quantityOnHand;
decimal price;
var qohsuccess = int.TryParse(quantityOnOrderTextBox.Text, out quantityOnHand);
var qoosuccess = int.TryParse(quantityOnHandTextBox.Text, out quantityOnOder);
var psuccess = decimal.TryParse(priceTextBox.Text, out price);
if (qoosuccess)
{
item.QuantityOnOrder = quantityOnOder;
}
if (qohsuccess)
{
item.QuantityOnHand = quantityOnHand;
}
if (psuccess)
{
item.Price = price;
}
}
}
context.SaveChanges();
}
public IEnumerable <Facility> GetFacilities()
{
var dataContext = new DevDetectiveEntities1();
return(dataContext.Facilities.Where(x => x.TenantId == _tenantId).ToList());
}
public IEnumerable <Tenant> SelectTenant()
{
var context = new DevDetectiveEntities1();
return(context.Tenants);
}
public IEnumerable <FacilityInventoryItemType> SelectFacilityInventoryItems()
{
var context = new DevDetectiveEntities1();
return(context.FacilityInventoryItemTypes.Where(x => x.FacilityId == _id).ToList());
}
