public void RenameunitMeasure(UnitMeasure unitMeasure, string newName)
{
if (unitMeasure == null)
{
throw new ArgumentNullException("unitMeasure");
}
if (string.IsNullOrWhiteSpace(unitMeasure.Name) || string.IsNullOrWhiteSpace(unitMeasure.Name.Sanitise().Trim()))
{
throw new Exception("Invalid UnitMeasure name!!!");
}
unitMeasure.Name = unitMeasure.Name.Sanitise().Trim();
using (var context = new DataManagementContext())
{
var selectedUnitMeasures =
context.UnitMeasures.SingleOrDefault(u => u.UnitMeasureCode == unitMeasure.UnitMeasureCode);
if (selectedUnitMeasures == null)
{
throw new Exception("The UnitMeasure record was not found in the database.");
}
if (selectedUnitMeasures.Name == newName)
{
return;
}
selectedUnitMeasures.Name = newName;
context.SaveChanges();
}
}
///<summary>
/// Returns a Typed BillOfMaterials Entity with mock values.
///</summary>
static public BillOfMaterials CreateMockInstance_Generated(TransactionManager tm)
{
BillOfMaterials mock = new BillOfMaterials();
mock.StartDate = TestUtility.Instance.RandomDateTime();
mock.EndDate = TestUtility.Instance.RandomDateTime();
mock.BomLevel = TestUtility.Instance.RandomShort();
mock.PerAssemblyQty = (decimal)TestUtility.Instance.RandomShort();
mock.ModifiedDate = TestUtility.Instance.RandomDateTime();
//OneToOneRelationship
Product mockProductByComponentId = ProductTest.CreateMockInstance(tm);
DataRepository.ProductProvider.Insert(tm, mockProductByComponentId);
mock.ComponentId = mockProductByComponentId.ProductId;
//OneToOneRelationship
Product mockProductByProductAssemblyId = ProductTest.CreateMockInstance(tm);
DataRepository.ProductProvider.Insert(tm, mockProductByProductAssemblyId);
mock.ProductAssemblyId = mockProductByProductAssemblyId.ProductId;
//OneToOneRelationship
UnitMeasure mockUnitMeasureByUnitMeasureCode = UnitMeasureTest.CreateMockInstance(tm);
DataRepository.UnitMeasureProvider.Insert(tm, mockUnitMeasureByUnitMeasureCode);
mock.UnitMeasureCode = mockUnitMeasureByUnitMeasureCode.UnitMeasureCode;
// create a temporary collection and add the item to it
TList <BillOfMaterials> tempMockCollection = new TList <BillOfMaterials>();
tempMockCollection.Add(mock);
tempMockCollection.Remove(mock);
return((BillOfMaterials)mock);
}
public ActionResult DeleteConfirmed(int id)
{
UnitMeasure unitMeasure = db.UnitMeasure.Find(id);
int idUser = (int)Session["idUser"];
int idCompany = (int)Session["idCompany"];
using (var trans = db.Database.BeginTransaction())
{
try
{
unitMeasure.DeactivateUnitMeasure();
db.SaveChanges();
Log log = new Log
{
Who = idUser,
UnitMeasureId = id,
New = "DISABLED",
Old = "ACTIVATED",
CompanyId = unitMeasure.CompanyId
};
db.Log.Add(log);
db.SaveChanges();
trans.Commit();
TempData["confirm"] = "SUCCESSFUL DELETE";
}
catch
{
trans.Rollback();
ViewBag.error = "ERROR 500, TRAY AGAIN, IF THE ERROR PERSIST CONTACT THE SYSTEM SUPPLIER";
}
return(RedirectToAction("Index"));
}
}
///<summary>
/// Update the Typed BillOfMaterials Entity with modified mock values.
///</summary>
static public void UpdateMockInstance_Generated(TransactionManager tm, BillOfMaterials mock)
{
mock.StartDate = TestUtility.Instance.RandomDateTime();
mock.EndDate = TestUtility.Instance.RandomDateTime();
mock.BomLevel = TestUtility.Instance.RandomShort();
mock.PerAssemblyQty = (decimal)TestUtility.Instance.RandomShort();
mock.ModifiedDate = TestUtility.Instance.RandomDateTime();
//OneToOneRelationship
Product mockProductByComponentId = ProductTest.CreateMockInstance(tm);
DataRepository.ProductProvider.Insert(tm, mockProductByComponentId);
mock.ComponentId = mockProductByComponentId.ProductId;
//OneToOneRelationship
Product mockProductByProductAssemblyId = ProductTest.CreateMockInstance(tm);
DataRepository.ProductProvider.Insert(tm, mockProductByProductAssemblyId);
mock.ProductAssemblyId = mockProductByProductAssemblyId.ProductId;
//OneToOneRelationship
UnitMeasure mockUnitMeasureByUnitMeasureCode = UnitMeasureTest.CreateMockInstance(tm);
DataRepository.UnitMeasureProvider.Insert(tm, mockUnitMeasureByUnitMeasureCode);
mock.UnitMeasureCode = mockUnitMeasureByUnitMeasureCode.UnitMeasureCode;
}
public void AddUnitMeasure(UnitMeasure unitMeasure)
{
if (unitMeasure == null)
{
throw new ArgumentNullException("unitMeasure");
}
if (string.IsNullOrWhiteSpace(unitMeasure.Name))
{
throw new Exception("Invalid UnitMeasure name!!!");
}
unitMeasure.Name = unitMeasure.Name.Trim().Sanitise();
using (var context = new DataManagementContext())
{
if (context.UnitMeasures.Any(m => m.Name == unitMeasure.Name))
{
throw new Exception("A unitMeasure with the supplied name already exists.");
}
var newUnitMeasures = new Models.Inventory.UnitMeasure
{
UnitMeasureCode = unitMeasure.UnitMeasureCode,
Name = unitMeasure.Name
};
context.UnitMeasures.Add(newUnitMeasures);
context.SaveChanges();
}
}
public IHttpActionResult PostUnitMeasure(UnitMeasure unitMeasure)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.UnitMeasure.Add(unitMeasure);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (UnitMeasureExists(unitMeasure.UnitMeasureCode))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = unitMeasure.UnitMeasureCode }, unitMeasure));
}
/// <summary>
/// Deep load all UnitMeasure children.
/// </summary>
private void Step_03_DeepLoad_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
int count = -1;
mock = CreateMockInstance(tm);
mockCollection = DataRepository.UnitMeasureProvider.GetPaged(tm, 0, 10, out count);
DataRepository.UnitMeasureProvider.DeepLoading += new EntityProviderBaseCore <UnitMeasure, UnitMeasureKey> .DeepLoadingEventHandler(
delegate(object sender, DeepSessionEventArgs e)
{
if (e.DeepSession.Count > 3)
{
e.Cancel = true;
}
}
);
if (mockCollection.Count > 0)
{
DataRepository.UnitMeasureProvider.DeepLoad(tm, mockCollection[0]);
System.Console.WriteLine("UnitMeasure instance correctly deep loaded at 1 level.");
mockCollection.Add(mock);
// DataRepository.UnitMeasureProvider.DeepSave(tm, mockCollection);
}
//normally one would commit here
//tm.Commit();
//IDisposable will Rollback Transaction since it's left uncommitted
}
}
public void RemoveUnitMeasure(UnitMeasure unitMeasure)
{
if (unitMeasure == null)
{
throw new ArgumentNullException("unitMeasure");
}
if (string.IsNullOrWhiteSpace(unitMeasure.Name) || string.IsNullOrWhiteSpace(unitMeasure.Name.Sanitise()))
{
throw new Exception("Invalid unitMeasure name!!!");
}
unitMeasure.Name = unitMeasure.Name.Trim().Sanitise();
using (var context = new DataManagementContext())
{
var selectedUnitMeasure = context.UnitMeasures.SingleOrDefault(u => u.UnitMeasureCode == unitMeasure.UnitMeasureCode);
if (selectedUnitMeasure == null)
{
throw new Exception("The UnitMeasure record was not found in the database");
}
try
{
context.UnitMeasures.Remove(selectedUnitMeasure);
context.SaveChanges();
}
catch (Exception)
{
throw new Exception("Could not remove the selected unitMeasure because it has associated Products.");
}
}
}
public IHttpActionResult PutUnitMeasure(string id, UnitMeasure unitMeasure)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != unitMeasure.UnitMeasureCode)
{
return(BadRequest());
}
db.Entry(unitMeasure).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!UnitMeasureExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
///<summary>
/// Update the Typed ProductVendor Entity with modified mock values.
///</summary>
static public void UpdateMockInstance_Generated(TransactionManager tm, ProductVendor mock)
{
mock.AverageLeadTime = TestUtility.Instance.RandomNumber();
mock.StandardPrice = TestUtility.Instance.RandomShort();
mock.LastReceiptCost = TestUtility.Instance.RandomShort();
mock.LastReceiptDate = TestUtility.Instance.RandomDateTime();
mock.MinOrderQty = TestUtility.Instance.RandomNumber();
mock.MaxOrderQty = TestUtility.Instance.RandomNumber();
mock.OnOrderQty = TestUtility.Instance.RandomNumber();
mock.ModifiedDate = TestUtility.Instance.RandomDateTime();
//OneToOneRelationship
Product mockProductByProductId = ProductTest.CreateMockInstance(tm);
DataRepository.ProductProvider.Insert(tm, mockProductByProductId);
mock.ProductId = mockProductByProductId.ProductId;
//OneToOneRelationship
UnitMeasure mockUnitMeasureByUnitMeasureCode = UnitMeasureTest.CreateMockInstance(tm);
DataRepository.UnitMeasureProvider.Insert(tm, mockUnitMeasureByUnitMeasureCode);
mock.UnitMeasureCode = mockUnitMeasureByUnitMeasureCode.UnitMeasureCode;
//OneToOneRelationship
Vendor mockVendorByVendorId = VendorTest.CreateMockInstance(tm);
DataRepository.VendorProvider.Insert(tm, mockVendorByVendorId);
mock.VendorId = mockVendorByVendorId.VendorId;
}
private void MakeSum(IEnumerable <ReportLineViewModel> group, ReportLineViewModel lic)
{
//qtty in base unit of measure
double qttySum = group.Sum(x => x.Quantity * x.UnitMeasure.ToBaseConversion);
//UMFamily umFamily = appvm.ProductsOC.Single(x => x.Id == lic.Product.Id).UMFamily;
var invSVC = ServiceContainer.GetService <IInventoryService>();
//quantity
UnitMeasure bestUM = invSVC.GetBestUM(lic.Product.UMFamily, qttySum);
lic.UnitMeasure = bestUM;
lic.Quantity = qttySum / bestUM.ToBaseConversion;
//basic quantity
double ep = lic.Product.EdiblePart;
UnitMeasure realUM = invSVC.GetBestUM(lic.Product.UMFamily, qttySum / ep);
lic.RealUnitMeasure = realUM;
lic.RealQuantity = qttySum / ep / realUM.ToBaseConversion;
//cost
lic.Cost = group.Sum(x => x.Cost);
lic.RealCost = lic.Cost / (decimal)ep;
}
void UpdateCostResult()
{
UnitMeasure qttyUM = AllUMs.Single(x => x.Id == umId);
UnitMeasure resultUM = AllUMs.Single(x => x.Id == resultUMid);
CostResult = price / (decimal)qtty / (decimal)(qttyUM.ToBaseConversion / resultUM.ToBaseConversion);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
HttpContext.Current.Session["ListOfIngredients"] = new List <Ingredient>();
List <Category> categories = Category.getCategories();
foreach (Category category in categories)
{
ddlCategory.Items.Add(new ListItem(category.name, category.id.ToString()));
}
ddlCategory.Items.Add(new ListItem("Other", (-1).ToString()));
List <UnitMeasure> unitMeasures = UnitMeasure.getUnitMeasures();
foreach (UnitMeasure unitMeasure in unitMeasures)
{
ddlUnitMeasure.Items.Add(new ListItem(unitMeasure.name, unitMeasure.id.ToString()));
}
List <Ingredient> ingredients = Ingredient.getAllIngredientsName();
ddlIngredient.Items.Add(new ListItem(String.Empty, String.Empty));
foreach (Ingredient ingredient in ingredients)
{
ddlIngredient.Items.Add(new ListItem(ingredient.name, ingredient.id.ToString()));
}
}
}
///<summary>
/// Update the Typed UnitMeasure Entity with modified mock values.
///</summary>
static public void UpdateMockInstance(TransactionManager tm, UnitMeasure mock)
{
UnitMeasureTest.UpdateMockInstance_Generated(tm, mock);
// make any alterations necessary
// (i.e. for DB check constraints, special test cases, etc.)
SetSpecialTestData(mock);
}
/// <summary>
/// Check the foreign key dal methods.
/// </summary>
private void Step_10_FK_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
UnitMeasure entity = CreateMockInstance(tm);
bool result = DataRepository.UnitMeasureProvider.Insert(tm, entity);
Assert.IsTrue(result, "Could Not Test FK, Insert Failed");
}
}
public IHttpActionResult GetUnitMeasure(string id)
{
UnitMeasure unitMeasure = db.UnitMeasure.Find(id);
if (unitMeasure == null)
{
return(NotFound());
}
return(Ok(unitMeasure));
}
public virtual BOUnitMeasure MapEFToBO(
UnitMeasure ef)
{
var bo = new BOUnitMeasure();
bo.SetProperties(
ef.UnitMeasureCode,
ef.ModifiedDate,
ef.Name);
return(bo);
}
public virtual UnitMeasure MapBOToEF(
BOUnitMeasure bo)
{
UnitMeasure efUnitMeasure = new UnitMeasure();
efUnitMeasure.SetProperties(
bo.ModifiedDate,
bo.Name,
bo.UnitMeasureCode);
return(efUnitMeasure);
}
/// <summary>
/// Test methods exposed by the EntityHelper class.
/// </summary>
private void Step_20_TestEntityHelper_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
mock = CreateMockInstance(tm);
UnitMeasure entity = mock.Copy() as UnitMeasure;
entity = (UnitMeasure)mock.Clone();
Assert.IsTrue(UnitMeasure.ValueEquals(entity, mock), "Clone is not working");
}
}
private void OnSaveUnit(UnitMeasure um)
{
if (UnitMeasures.Contains(um, new UnitIdComparer()))
{
UnitMeasures.FirstOrDefault(p => p.ID == um.ID).Update(um);
}
else
{
OnCreateUnit(um);
}
}
///<summary>
/// Returns a Typed UnitMeasure Entity with mock values.
///</summary>
static public UnitMeasure CreateMockInstance(TransactionManager tm)
{
// get the default mock instance
UnitMeasure mock = UnitMeasureTest.CreateMockInstance_Generated(tm);
// make any alterations necessary
// (i.e. for DB check constraints, special test cases, etc.)
SetSpecialTestData(mock);
// return the modified object
return(mock);
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(RedirectToAction("Error500", "Error"));
}
try
{
int idUser = Session["idUser"] != null ? (int)Session["idUser"] : 0;
int permission = Session["permission"] != null ? (int)Session["permission"] : 0;
int idCompany = Session["permission"] != null ? (int)Session["idCompany"] : 0;
string userName = Session["permission"] != null ? (string)Session["username"] : null;
if (Check.IsLogOn(idUser, permission, idCompany, userName))
{
UnitMeasure unitMeasure = db.UnitMeasure.Find(id);
if (unitMeasure == null)
{
return(RedirectToAction("Error404", "Error"));
}
if (Check.IsSuperAdmin(permission))
{
ViewBag.CompanyId = new SelectList(db.Company, "IdCompany", "NameCompany");
}
else if (Check.IsSupervisor(permission) && idCompany == unitMeasure.CompanyId)
{
Company company = db.Company.Where(c => c.IdCompany == idCompany).FirstOrDefault();
List <Company> companies = new List <Company>();
companies.Add(company);
ViewBag.CompanyId = new SelectList(companies, "IdCompany", "NameCompany", idCompany);
}
else
{
TempData["error"] = "YOU DO NOT HAVE PERMISSION";
return(RedirectToAction("Index"));
}
return(View(unitMeasure));
}
else
{
TempData["error"] = "YOU ARE NOT LOGGED IN";
return(RedirectToAction("LogIn", "Employees"));
}
}
catch
{
return(RedirectToAction("Error500", "Error"));
}
}
// PUT api/awbuildversion/5
public void Put(UnitMeasure value)
{
var GetActionType = Request.Headers.Where(x => x.Key.Equals("ActionType")).FirstOrDefault();
if (GetActionType.Key != null)
{
if (GetActionType.Value.ToList()[0].Equals("DELETE"))
adventureWorks_BC.UnitMeasureDelete(value);
if (GetActionType.Value.ToList()[0].Equals("UPDATE"))
adventureWorks_BC.UnitMeasureUpdate(value);
}
}
public bool UnitMeasureExists(UnitMeasure unitMeasure)
{
try
{
return(_ctx.UnitMeasures.Any(c => c.UnitMeasureName == unitMeasure.UnitMeasureName && c.UnitMeasureId != unitMeasure.UnitMeasureId));
}
catch (Exception ex)
{
_logger.LogError($"Failed in UnitMeasureExists: {ex}");
return(false);
}
}
public IngredientViewModel(double qtty, UnitMeasure um, Product prod, Action onModified)
{
this.quantity = qtty;
this.umId = um.Id;
this.productId = prod.Id;
this.productName = prod.Name;
this.onModified = onModified;
UpdateAvailableUMs();
UpdateCost();
}
/// <summary>
/// Serialize the mock UnitMeasure entity into a temporary file.
/// </summary>
private void Step_06_SerializeEntity_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
mock = CreateMockInstance(tm);
string fileName = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "temp_UnitMeasure.xml");
EntityHelper.SerializeXml(mock, fileName);
Assert.IsTrue(System.IO.File.Exists(fileName), "Serialized mock not found");
System.Console.WriteLine("mock correctly serialized to a temporary file.");
}
}
private async Task <bool> BeUniqueByName(ApiUnitMeasureRequestModel model, CancellationToken cancellationToken)
{
UnitMeasure record = await this.unitMeasureRepository.ByName(model.Name);
if (record == null || (this.existingRecordId != default(string) && record.UnitMeasureCode == this.existingRecordId))
{
return(true);
}
else
{
return(false);
}
}
private void MakeSum(IEnumerable <ReportLineViewModel> group, ReportLineViewModel lic)
{
//qtty in base unit of measure
double tempQuantity = group.Sum(x => x.Quantity * x.UnitMeasure.ToBaseConversion);
//UMFamily umFamily = appvm.ProductsOC.Single(x => x.Id == lic.Product.Id).UMFamily;
var invSVC = ServiceContainer.GetService <IInventoryService>();
UnitMeasure bestUM = invSVC.GetBestUM(lic.Product.UMFamily, tempQuantity);
lic.UnitMeasure = bestUM;
lic.Quantity = tempQuantity / bestUM.ToBaseConversion;
}
public void MapBOToEF()
{
var mapper = new DALUnitMeasureMapper();
var bo = new BOUnitMeasure();
bo.SetProperties("A", DateTime.Parse("1/1/1987 12:00:00 AM"), "A");
UnitMeasure response = mapper.MapBOToEF(bo);
response.ModifiedDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
response.Name.Should().Be("A");
response.UnitMeasureCode.Should().Be("A");
}
public void MapEFToBO()
{
var mapper = new DALUnitMeasureMapper();
UnitMeasure entity = new UnitMeasure();
entity.SetProperties(DateTime.Parse("1/1/1987 12:00:00 AM"), "A", "A");
BOUnitMeasure response = mapper.MapEFToBO(entity);
response.ModifiedDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
response.Name.Should().Be("A");
response.UnitMeasureCode.Should().Be("A");
}
private void ShowDeleteConfirm(object sender, RoutedEventArgs e)
{
UnitMeasure um = (UnitMeasure)this.UnitGrid.SelectedItem;
MessageBoxResult result = MessageBox.Show(this, "Вы уверенны, что хотите удалить единицу измерения \"" + um.Name + "\"?", "Подтверждение", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
Button btn = (Button)sender;
MainWindowViewModel context = (MainWindowViewModel)btn.DataContext;
context.DeleteUnitCommand.Execute(um);
SortUnitMeasures(sender, e);
}
}
/// <summary>
/// Create a new UnitMeasure object.
/// </summary>
/// <param name="unitMeasureCode">Initial value of UnitMeasureCode.</param>
/// <param name="name">Initial value of Name.</param>
/// <param name="modifiedDate">Initial value of ModifiedDate.</param>
public static UnitMeasure CreateUnitMeasure(string unitMeasureCode, string name, global::System.DateTime modifiedDate)
{
UnitMeasure unitMeasure = new UnitMeasure();
unitMeasure.UnitMeasureCode = unitMeasureCode;
unitMeasure.Name = name;
unitMeasure.ModifiedDate = modifiedDate;
return unitMeasure;
}
/// <summary>
/// There are no comments for UnitMeasure in the schema.
/// </summary>
public void AddToUnitMeasure(UnitMeasure unitMeasure)
{
base.AddObject("UnitMeasure", unitMeasure);
}
// POST api/awbuildversion
public void Post(UnitMeasure value)
{
adventureWorks_BC.UnitMeasureAdd(value);
}
