public void CreateUoms()
{
var units = from item in xml.Descendants("UnitOfMeasure") select item;
Console.WriteLine(units.FirstOrDefault());
Console.WriteLine(units.Last());
foreach (var unit in units)
{
//no BaseUnit tag means it is a customary unit
bool isBaseUnit = unit.Descendants("BaseUnit").Any();
if (!isBaseUnit)
{
CustomaryUnit unitOfMeasure = new CustomaryUnit();
unitOfMeasure.BaseUnitId = (string)unit.Attribute("id");
CreateUofMeasure(unit, unitOfMeasure);
AddCustomaryComponent(unit, unitOfMeasure);
CustomaryUnits.Add(unitOfMeasure);
}
else
{
UnitOfMeasure unitOfMeasure = new UnitOfMeasure();
CreateUofMeasure(unit, unitOfMeasure);
UnitOfMeasures.Add(unitOfMeasure);
}
}
foreach (var unit in UnitOfMeasures)
{
unit.DimensionalClass = dimensionalClasses[unit.DimensionClassId];
}
}
public ActionResult DeleteConfirmed(int id)
{
UnitOfMeasures unitofmeasures = db.UnitOfMeasures.Find(id);
db.UnitOfMeasures.Remove(unitofmeasures);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(UnitOfMeasures unitofmeasures)
{
if (ModelState.IsValid)
{
db.Entry(unitofmeasures).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(unitofmeasures));
}
//
// GET: /UnitOfMeasure/Delete/5
public ActionResult Delete(int id = 0)
{
UnitOfMeasures unitofmeasures = db.UnitOfMeasures.Find(id);
if (unitofmeasures == null)
{
return(HttpNotFound());
}
return(View(unitofmeasures));
}
private void AddNewItem()
{
SelectedItem = new ItemDTO
{
TotalCurrentQty = 0,
SafeQuantity = 10,
};
SelectedCategory = Categories.FirstOrDefault();
SelectedUnitOfMeasure = UnitOfMeasures.FirstOrDefault();
}
public ActionResult Create(UnitOfMeasures unitofmeasures)
{
if (ModelState.IsValid)
{
db.UnitOfMeasures.Add(unitofmeasures);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(unitofmeasures));
}
public ActionResult Edit([Bind(Include = "Id,UnitOfMeasuresName")] UnitOfMeasures UM)
{
if (ModelState.IsValid)
{
_repository.Update(UM);
_repository.Save();
this.AddNotification("Unit of Measure Updated successfully.", NotificationType.SUCCESS);
return(RedirectToAction("Index"));
}
return(View(UM));
}
public ItemDetailViewModel()
{
CleanUp();
_itemService = new ItemService();
_itemQuantityService = new ItemQuantityService();
CheckRoles();
LoadItems();
LoadCategories();
SelectedCategory = Categories.FirstOrDefault();
LoadUoMs();
SelectedUnitOfMeasure = UnitOfMeasures.FirstOrDefault();
Messenger.Default.Register <ItemQuantityDTO>(this, (message) =>
{
if (message != null)
{
SelectedItemQuantityOld = _itemQuantityService.Find(message.Id.ToString()) ??
new ItemQuantityDTO()
{
QuantityOnHand = 0,
ItemId = message.ItemId,
WarehouseId = message.WarehouseId
};
}
});
Messenger.Default.Register <WarehouseDTO>(this, (message) =>
{
SelectedWarehouse = message;
});
Messenger.Default.Register <ObservableCollection <TransactionLineDTO> >(this, (message) =>
{
TransactionLines = message;
});
Messenger.Default.Register <TransactionHeaderDTO>(this, (message) =>
{
SelectedTransaction = message;
});
if (_currentItem == null)
{
_currentItem = GetNewCurrentItem();
_itemPreviousQty = 0;
}
QuantityEditVisibility = "Collapsed";
ItemsListVisibility = "Collapsed";
}
// GET: /Category/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
UnitOfMeasures UM = _repository.GetById(id);
if (UM == null)
{
return(HttpNotFound());
}
return(View(UM));
}
private void AddNewItem()
{
SelectedItem = new ItemDTO
{
ItemCode = _itemService.GetItemCode(),
TotalCurrentQty = 0,
SafeQuantity = 10,
//Category = Categories.FirstOrDefault(),
//UnitOfMeasure = UnitOfMeasures.FirstOrDefault()
};
SelectedCategory = Categories.FirstOrDefault();
SelectedUnitOfMeasure = UnitOfMeasures.FirstOrDefault();
}
public ItemDTO GetNewCurrentItem()
{
var currentItem = new ItemDTO
{
ItemCode = _itemService.GetItemCode(),
TotalCurrentQty = 0,
PurchasePrice = 0,
SellPrice = 0,
SafeQuantity = 10,
CategoryId = Categories.FirstOrDefault().Id, // SelectedCategory.Id,
UnitOfMeasureId = UnitOfMeasures.FirstOrDefault().Id //SelectedUnitOfMeasure.Id
};
return(currentItem);
}
public string insertMeasures(UnitOfMeasures cats)
{
string Message = string.Empty;
int result = 0;
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO [UnitOfMeasures]([UnitOfMeasure]) VALUES (@UnitOfMeasure)", con);
cmd.Parameters.AddWithValue("@UnitOfMeasure", cats.UnitOfMeasure);
result = cmd.ExecuteNonQuery();
con.Close();
return(Message);
}
public UnitOfMeasures isUserExisting(string sizes)
{
DataTable dt = new DataTable("Category");
dt.Clear();
string query = "SELECT * FROM UnitOfMeasures where UnitOfMeasure='" + sizes + "'";
dt = DataAccess.DBAdapter.GetRecordSet(query);
UnitOfMeasures log = null;
if (dt.Rows.Count > 0)
{
log = new UnitOfMeasures(dt.Rows[0]);
}
return(log);
}
private void ExcuteAddNewUomCommand()
{
var category = new Categories(NameTypes.UnitMeasure);
category.ShowDialog();
var dialogueResult = category.DialogResult;
if (dialogueResult != null && (bool)dialogueResult)
{
LoadUoMs();
SelectedUnitOfMeasure = UnitOfMeasures.FirstOrDefault(c => c.DisplayName == category.TxtCategoryName.Text);
if (SelectedUnitOfMeasure != null)
{
SelectedItem.UnitOfMeasureId = SelectedUnitOfMeasure.Id;
}
}
}
public ItemEntryViewModel()
{
CleanUp();
_itemService = new ItemService();
_itemQuantityService = new ItemQuantityService();
CheckRoles();
LoadCategories();
SelectedCategory = Categories.FirstOrDefault();
LoadUoMs();
SelectedUnitOfMeasure = UnitOfMeasures.FirstOrDefault();
Messenger.Default.Register <ItemQuantityDTO>(this, (message) =>
{
if (message != null)
{
SelectedItemQuantityOld = _itemQuantityService.Find(message.Id.ToString()) ??
new ItemQuantityDTO()
{
QuantityOnHand = 0,
ItemId = message.ItemId,
WarehouseId = message.WarehouseId
};
}
});
Messenger.Default.Register <WarehouseDTO>(this, (message) =>
{
SelectedWarehouse = message;
});
if (_selectedItem == null)
{
_selectedItem = GetNewSelectedItem();
_itemPreviousQty = 0;
}
QuantityEditVisibility = "Collapsed";
}
public MessageViewModel()
{
CleanUp();
_deliveryService = new DeliveryService();
CheckRoles();
LoadCategories();
if (Categories != null)
{
SelectedCategory = Categories.FirstOrDefault();
}
LoadUoMs();
if (UnitOfMeasures != null)
{
SelectedUnitOfMeasure = UnitOfMeasures.FirstOrDefault();
}
Messenger.Default.Register <MessageDTO>(this, (message) =>
{
SelectedMessageParam = message;
});
}
public bool importFromXML()
{
//try
//{
XDocument doc = XDocument.Load(Path);
XElement elemCompany = doc.Element("Settings").Element("Company");
XElement elemContractors = doc.Element("Settings").Element("Contractors");
XElement elemPaymentMethods = doc.Element("Settings").Element("PaymentMethods");
XElement elemUnitOfMeasures = doc.Element("Settings").Element("UnitOfMeasures");
XElement elemItems = doc.Element("Settings").Element("Items");
Company.Id = Int32.Parse(elemCompany.Attribute("Id").Value);
Company.FullName = elemCompany.Attribute("FullName").Value;
Company.Name = elemCompany.Attribute("Name").Value;
Company.NIP = elemCompany.Attribute("NIP").Value;
Company.REGON = elemCompany.Attribute("REGON").Value;
Company.Street = elemCompany.Attribute("Street").Value;
Company.BuldingNo = elemCompany.Attribute("BuldingNo").Value;
Company.PostalCode = elemCompany.Attribute("PostalCode").Value;
Company.City = elemCompany.Attribute("City").Value;
Company.Email = elemCompany.Attribute("Email").Value;
Company.Phone = elemCompany.Attribute("Phone").Value;
Company.Website = elemCompany.Attribute("Website").Value;
Company.BankName = elemCompany.Attribute("BankName").Value;
Company.BankAccount = elemCompany.Attribute("BankAccount").Value;
Company.IssuerName = elemCompany.Attribute("IssuerName").Value;
foreach (XElement xContractor in elemContractors.Elements("Contractor"))
{
Contractor contractor = new Contractor();
contractor.Id = Int32.Parse(xContractor.Attribute("Id").Value);
contractor.FullName = xContractor.Attribute("FullName").Value;
contractor.NIP = xContractor.Attribute("NIP").Value;
contractor.Street = xContractor.Attribute("Street").Value;
contractor.BuldingNo = xContractor.Attribute("BuldingNo").Value;
contractor.PostalCode = xContractor.Attribute("PostalCode").Value;
contractor.City = xContractor.Attribute("City").Value;
Contractors.Add(contractor);
}
foreach (XElement xPaymentMethod in elemPaymentMethods.Elements("PaymentMethod"))
{
PaymentMethod paymentMethod = new PaymentMethod();
paymentMethod.Id = Int32.Parse(xPaymentMethod.Attribute("Id").Value);
paymentMethod.Name = xPaymentMethod.Attribute("Name").Value;
paymentMethod.DueDate = Int32.Parse(xPaymentMethod.Attribute("DueDate").Value);
PaymentMethods.Add(paymentMethod);
}
foreach (XElement xUnitOfMeasures in elemUnitOfMeasures.Elements("UnitOfMeasure"))
{
UnitOfMeasure unitOfMeasure = new UnitOfMeasure();
unitOfMeasure.Id = Int32.Parse(xUnitOfMeasures.Attribute("Id").Value);
unitOfMeasure.Name = xUnitOfMeasures.Attribute("Name").Value;
unitOfMeasure.ShortName = xUnitOfMeasures.Attribute("ShortName").Value;
UnitOfMeasures.Add(unitOfMeasure);
}
foreach (XElement xItems in elemItems.Elements("Item"))
{
Item item = new Item();
item.Id = Int32.Parse(xItems.Attribute("Id").Value);
item.Name = xItems.Attribute("Name").Value;
//item.UnitOfMeasure =;
item.UnitPrice = Decimal.Parse(xItems.Attribute("UnitPrice").Value);
item.VatRate = Decimal.Parse(xItems.Attribute("VATRate").Value);
Items.Add(item);
}
//}
//catch (Exception)
//{
// return false;
//}
return(true);
}
