public async void Update(Manufacturers item)
{
//IspContext.Items.Update(item);
await IspContext.SaveChangesAsync();
//throw new System.NotImplementedException();
}
public static int getVaccineID()
{
IManufacturersStorage pManufacturersStorage = new ManufacturersStorage();
Manufacturers myManufacturers = CreateManufacturersForTest(
"供应商",
"浙江温州",
"17733117779",
"2013-06-30",
"2016-06-30");
Manufacturers createdManufacturers =
pManufacturersStorage.CreateManufacturers(myManufacturers);
IVaccineStorage pVaccineStorage = new VaccineStorage();
Vaccine myVaccine = CreateVaccineForTest(
"狂犬疫苗",
"处方",
createdManufacturers.ManufacturersID,
"68.00",
"45");
Vaccine createdVaccine =
pVaccineStorage.CreateVaccine(myVaccine);
return(createdVaccine.VaccineID);
}
public ActionResult Edit(int id)
{
TeamsMapper teamsMapper = new TeamsMapper();
Teams team = teamsMapper.SelectTeam(id);
if (!(User.IsInRole("Admin") || ButtonEnable.TeamsEdit(team.UserId, new UsersMapper().SelectUser(User.Identity.Name))))
{
TempData["message-error"] = "Nemáte oprávnění provádět tyto změny";
return(RedirectToAction("Detail", "Teams", new { id = team.Id }));
}
team.State = States.FindForTeam(team);
team.Manufacturer = Manufacturers.FindForTeam(team);
ViewBag.Name = team.Name;
ViewBag.States = new StatesMapper().SelectAll();
((Collection <States>)ViewBag.States).Insert(0, new States().EmptyState());
ViewBag.Manufacturers = new ManufacturersMapper().SelectAll();
((Collection <Manufacturers>)ViewBag.Manufacturers).Insert(0, new Manufacturers().EmptyManufacturer());
ViewBag.IfTeam = User.Identity.IsAuthenticated && ButtonEnable.TeamsEdit(team.UserId, new UsersMapper().SelectUser(User.Identity.Name));
return(View(team));
}
public List <Manufacturers> BindAllManufacturers()
{
List <Manufacturers> manufacturersListObj = new List <Manufacturers>();
using (SqlConnection)
{
SqlCmd.CommandText = "select ManufacturersID, ManufacturersName from Table_Manufacturers";
SqlConnection.Open();
SqlDataReader sqlDataReaderObj = SqlCmd.ExecuteReader();
if (sqlDataReaderObj.HasRows)
{
Int16 serial = 0;
while (sqlDataReaderObj.Read())
{
Manufacturers manufacturerObj = new Manufacturers();
manufacturerObj.SerialID = ++serial;
manufacturerObj.ManufacturerID = sqlDataReaderObj["ManufacturersID"].ToString();
manufacturerObj.ManufacturerName = sqlDataReaderObj["ManufacturersName"].ToString();
manufacturersListObj.Add(manufacturerObj);
}
}
sqlDataReaderObj.Close();
}
return(manufacturersListObj);
}
public ActionResult Edit(Teams team)
{
TeamsMapper teamsMapper = new TeamsMapper();
Teams teamFromDb = teamsMapper.SelectTeam(team.Id);
if (!(User.IsInRole("Admin") || ButtonEnable.TeamsEdit(teamFromDb.UserId, new UsersMapper().SelectUser(User.Identity.Name))))
{
TempData["message-error"] = "Nemáte oprávnění provádět tyto změny";
return(RedirectToAction("Detail", "Teams", new { id = team.Id }));
}
if (ModelState.IsValid)
{
teamsMapper.Edit(team);
TempData["message-success"] = "Tým byl zmeněn";
return(RedirectToAction("Detail", "Teams", new { id = team.Id }));
}
TempData["message-error"] = "Při zpracování se stala chyba";
team.State = States.FindForTeam(team);
team.Manufacturer = Manufacturers.FindForTeam(team);
ViewBag.Name = team.Name;
ViewBag.States = new StatesMapper().SelectAll();
((Collection <States>)ViewBag.States).Insert(0, new States().EmptyState());
ViewBag.Manufacturers = new ManufacturersMapper().SelectAll();
((Collection <Manufacturers>)ViewBag.Manufacturers).Insert(0, new Manufacturers().EmptyManufacturer());
return(View(team));
}
public JsonResult GetManu(long id)
{
try
{
var obj = _manuBusiness.GetById(id);
if (obj != null)
{
Manufacturers objentity = new Manufacturers();
objentity.ManuId = obj.Id;
objentity.ManuName = obj.ManufacturerName;
objentity.icon = obj.Icon;
objentity.Description = obj.Description;
objentity.Order = obj.Order;
return(Json(objentity, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(0));
}
}
catch (Exception)
{
//Write log
throw;
}
}
public void phoneTypeChecker(Manufacturers manu)
{
if (manu == Manufacturers.HTC)
{
HTCFactory H = new HTCFactory();
factory = H;
CheckProducts(factory);
}
else if (manu == Manufacturers.Nokia)
{
NokiaFactory N = new NokiaFactory();
factory = N;
CheckProducts(factory);
}
else if (manu == Manufacturers.Samsung)
{
SamsungFactory S = new SamsungFactory();
factory = S;
CheckProducts(factory);
}
void CheckProducts(IPhoneFactory factory)
{
factory.GetSmart();
factory.GetDumb();
}
}
private void ManufacturerEdit_Load(object sender, EventArgs e)
{
int id = int.Parse(lblId.Text);
Manufacturers manufacturer = db.Manufacturers.Find(id);
txtName.Text = manufacturer.Name;
}
async Task ExecuteLoadManufacturersCommand()
{
if (IsBusy)
{
return;
}
IsBusy = true;
try
{
Manufacturers.Clear();
var items = await restService.GetResponse <List <Manufacturer> >(Constants.urlApi + "manufacturers", true);
foreach (var item in items)
{
Manufacturers.Add(item);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
finally
{
IsBusy = false;
}
}
public void Execute(CreateProductDto request)
{
try
{
var query = Context.Products
.Where(p => p.product_id == request.Id)
.FirstOrDefault();
query.category_id = request.CategoryId;
query.description = request.Description;
query.name = request.Name;
query.price = request.Price;
DeleteManufacturers.RemoveExistingProductManufacturers(request);
DeleteSuppliers.RemoveExistingProductSuppliers(request);
Context.SaveChanges();
Manufacturers.Execute(request, (int)request.Id);
Suppliers.Execute(request, (int)request.Id);
Context.SaveChanges();
}
catch (CustomException e)
{
throw new CustomException("Doslo je do greske prilikom konekcije!");
}
}
public void Load()
{
Customers.Load();
Manufacturers.Load();
Products.Load();
Orders.Load();
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
if (!string.IsNullOrEmpty(Nametbx.Text) && !string.IsNullOrEmpty(Countrytbx.Text) &&
!string.IsNullOrEmpty(Citytbx.Text) && !string.IsNullOrEmpty(Streettbx.Text) &&
!string.IsNullOrEmpty(NumHousetbx.Text) && !string.IsNullOrEmpty(NumCartbx.Text) &&
int.TryParse(NumCartbx.Text, out int idCar) && int.TryParse(NumHousetbx.Text, out int idNumh))
{
Manufacturers manufacturers = new Manufacturers()
{
Name_Manufacturer = Nametbx.Text,
Country_Manufacturer = Countrytbx.Text,
City_Manufacturer = Citytbx.Text,
Street_Manufacturer = Streettbx.Text,
HouseNumber_Manufacturer = int.Parse(NumHousetbx.Text),
CodeProduct_Manufacturer = int.Parse(NumCartbx.Text)
};
carSaleEntities.Manufacturers.Add(manufacturers);
carSaleEntities.SaveChanges();
ManufacturersWindow.dataGrid.ItemsSource = carSaleEntities.Manufacturers.ToList();
this.Hide();
}
else
{
MessageBox.Show("Проверьте вводимые данные!", "Ошибка", MessageBoxButton.OK);
}
}
public void UpdateProductsList(IEnumerable <Product> products)
{
Products.Clear();
Manufacturers.Clear();
FillProducts(products);
NotifyPropertyChanged("Products");
}
public List <Manufacturers> BindAllManufacturers()
{
List <Manufacturers> manufacturersListObj = new List <Manufacturers>();
try
{
SqlCmd.CommandText = "select ManufacturersID, ManufacturersName from Table_Manufacturers";
SqlConnection.Open();
SqlDataReader sqldataReaderObj = SqlCmd.ExecuteReader();
if (sqldataReaderObj.HasRows)
{
while (sqldataReaderObj.Read())
{
Manufacturers manufacturersObj = new Manufacturers();
//manufacturersObj.ID = (int)sqldataReaderObj["ID"];
manufacturersObj.ManufacturerID = sqldataReaderObj["ManufacturersID"].ToString();
manufacturersObj.ManufacturerName = sqldataReaderObj["ManufacturersName"].ToString();
manufacturersListObj.Add(manufacturersObj);
}
}
sqldataReaderObj.Close();
}
catch (Exception ex)
{
}
finally
{
SqlConnection.Close();
}
return(manufacturersListObj);
}
public string getManufacturer()
{
Random rnd = new Random();
Manufacturers manufact = new Manufacturers();
return(manufact.Manufacturer[rnd.Next(0, 8)]);
}
public async Task <ActionResult <Manufacturers> > PostManufacturers(Manufacturers manufacturers)
{
_context.Manufacturers.Add(manufacturers);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetManufacturers", new { id = manufacturers.ManufacturerID }, manufacturers));
}
public async Task <IActionResult> PutManufacturers(int id, Manufacturers manufacturers)
{
if (id != manufacturers.ManufacturerID)
{
return(BadRequest());
}
_context.Entry(manufacturers).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ManufacturersExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
Manufacturers IManufacturersManager.ReadManufacturers(
IManufacturersStorage pStorage,
int pManufacturersID)
{
Manufacturers response = null;
try
{
#region Verify argument
Verify.ArgumentNotNull(pStorage, "pStorage");
Verify.ArgumentNotSpecified(
pManufacturersID <= 0,
"pManufacturersID");
#endregion
response =
pStorage.ReadManufacturers(pManufacturersID);
}
catch (Exception ex)
{
ExceptionHandler.DealWithException(ex);
}
return(response);
}
public void ManufacturersUpdateSuccessFive()
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
Manufacturers myManufacturers = CreateManufacturersForTest(
"供应商4",
"浙江温州4",
"17733117779",
"2013-06-30",
"2016-06-30");
Manufacturers createdManufacturers =
manufacturersStorage.CreateManufacturers(myManufacturers);
Assert.AreNotEqual(
0,
createdManufacturers.ManufacturersID,
string.Format("Could not create Manufacturers:{0}",
createdManufacturers.ManufacturersID));
myManufacturers.ManufacturersDoe = Convert.ToDateTime("2016-06-30");
manufacturersStorage.UpdateManufacturers(myManufacturers);
Manufacturers updatedManufacturers = manufacturersStorage.ReadManufacturers(
createdManufacturers.ManufacturersID);
AssertManufacturersItemEqual(myManufacturers, updatedManufacturers);
}
private static void AssertManufacturersItemEqual(
Manufacturers pManufacturers,
Manufacturers pCreatedManufacturers)
{
Assert.AreEqual(
pManufacturers.ManufacturersID,
pCreatedManufacturers.ManufacturersID,
string.Format("ManufacturersID isn't equal!"));
Assert.AreEqual(
pManufacturers.ManufacturersName,
pCreatedManufacturers.ManufacturersName,
string.Format("ManufacturersName isn't equal!"));
Assert.AreEqual(
pManufacturers.ManufacturersSite,
pCreatedManufacturers.ManufacturersSite,
string.Format("ManufacturersSite isn't equal!"));
Assert.AreEqual(
pManufacturers.ManufacturersPhone,
pCreatedManufacturers.ManufacturersPhone,
string.Format("ManufacturersPhone isn't equal!"));
Assert.AreEqual(
pManufacturers.ManufacturersDom,
pCreatedManufacturers.ManufacturersDom,
string.Format("ManufacturersDom isn't equal!"));
Assert.AreEqual(
pManufacturers.ManufacturersDoe,
pCreatedManufacturers.ManufacturersDoe,
string.Format("ManufacturersDoe isn't equal!"));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Address")] Manufacturers manufacturers)
{
if (id != manufacturers.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(manufacturers);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ManufacturersExists(manufacturers.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(manufacturers));
}
public async Task <IActionResult> OnPostAsync(int id)
{
Manufacturers = await _db.Delete(id);
TempData["SuccessMessage"] = $"Запись \"{Manufacturers.Name}\" успешно удалена";
return(RedirectToPage("./Index"));
}
private void btnModfiy_Click(object sender, EventArgs e)
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
Manufacturers manufacturers = new Manufacturers();
if (textManufacturersName.Text.Trim() == "" || textManufacturersSite.Text.Trim() == "" ||
textManufacturersPhone.Text.Trim() == "" || dtpManufacturersDom.Text.Trim() == "" ||
dtpManufacturersDoe.Text.Trim() == "")
{
MessageBox.Show("请双击需要修改的记录！");
}
else
{
manufacturers.ManufacturersName = textManufacturersName.Text;
manufacturers.ManufacturersSite = textManufacturersSite.Text;
manufacturers.ManufacturersPhone = textManufacturersPhone.Text;
manufacturers.ManufacturersDom = Convert.ToDateTime(dtpManufacturersDom.Text);
manufacturers.ManufacturersDoe = Convert.ToDateTime(dtpManufacturersDoe.Text);
manufacturers.ManufacturersID = Convert.ToInt32(dgvManufacturers[0, dgvManufacturers.CurrentCell.RowIndex].Value.ToString());
manufacturersStorage.UpdateManufacturers(manufacturers);
MessageBox.Show("更新成功！");
textManufacturersName.Text = "";
textManufacturersSite.Text = "";
textManufacturersPhone.Text = "";
dtpManufacturersDom.Text = "";
dtpManufacturersDoe.Text = "";
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
IManufacturersStorage manufacturersStorage = new ManufacturersStorage();
Manufacturers manufacturers = new Manufacturers();
if (textManufacturersName.Text.Trim() == "" || textManufacturersSite.Text.Trim() == "" ||
textManufacturersPhone.Text.Trim() == "" || dtpManufacturersDom.Text.Trim() == "" ||
dtpManufacturersDoe.Text.Trim() == "")
{
MessageBox.Show("请输入全部信息，不要有遗漏。");
}
else
{
manufacturers.ManufacturersName = textManufacturersName.Text.Trim();
manufacturers.ManufacturersSite = textManufacturersSite.Text.Trim();
manufacturers.ManufacturersPhone = textManufacturersPhone.Text.Trim();
manufacturers.ManufacturersDom = Convert.ToDateTime(dtpManufacturersDom.Text.Trim());
manufacturers.ManufacturersDoe = Convert.ToDateTime(dtpManufacturersDoe.Text.Trim());
manufacturersStorage.CreateManufacturers(manufacturers);
MessageBox.Show("增加成功！");
textManufacturersName.Text = "";
textManufacturersSite.Text = "";
textManufacturersPhone.Text = "";
dtpManufacturersDom.Text = "";
dtpManufacturersDoe.Text = "";
}
}
public async Task <Manufacturers> Add(Manufacturers NewManuf)
{
_context.Manufacturers.Add(NewManuf); //добавляем новый объект
await _context.SaveChangesAsync(); //отправляем запрос к БД на добавление
return(NewManuf);
}
public override void SetModel(dynamic entity)
{
try
{
if (entity is ManufacturersEnter)
{
ManufacturersEnter data = (ManufacturersEnter)entity;
BindingFromModel(data, this);
DoEvents();
Status.IsNewInstance = false;
Status.IsModify = false;
Status.IsSaved = false;
}
if (entity is Manufacturers)
{
Manufacturers data = (Manufacturers)entity;
BindingFromModel(data, this);
DoEvents();
Status.IsNewInstance = false;
Status.IsModify = false;
Status.IsSaved = false;
}
//await Dispatcher.InvokeAsync(new Action(QueryDetails), System.Windows.Threading.DispatcherPriority.Background);
}
catch (Exception ex)
{
setErrortoModel(this, ex);
}
}
public void UpdateProductsList()
{
try
{
Products.Clear();
Manufacturers.Clear();
VehicleEngine vehicleEngine = UserConfiguration.GetUserConfiguration().SelectedVehicleEngine;
Category category = UserConfiguration.GetUserConfiguration().SelectedCategory;
if (vehicleEngine != null && category != null)
{
try
{
vehiclePart = storeService.VehiclePartService.GetVehiclePart(
vehicleEngine, category);
FillProducts(storeService.ProductService.GetProductsByVehiclePart(vehiclePart));
NotifyPropertyChanged("Products");
}
catch (Exception e)
{
WindowProvider.NotifyWindow(e.Message);
}
}
else
{
WindowProvider.NotifyWindow("Автомобиль не выбран");
}
}
catch (Exception e)
{
WindowProvider.NotifyWindow(e.Message);
}
}
public async Task <Manufacturers> Update(Manufacturers updatedManuf)
{
_context.Attach(updatedManuf).State = EntityState.Modified; //уведомляем EF, что состояние объекта изменилось
await _context.SaveChangesAsync(); //отправляем запрос к БД на изменение
return(updatedManuf);
}
public async Task <IActionResult> OnPostAsync()
{
if (!ModelState.IsValid)
{
return(Page());
}
try
{
Manufacturers = await _db.Update(Manufacturers);
}
catch (DbUpdateConcurrencyException)
{
if (!_db.ManufacturersExists(Manufacturers.Id))
{
return(NotFound());
}
else
{
throw;
}
}
TempData["SuccessMessage"] = $"Запись \"{Manufacturers.Name}\" успешно обновлена";
return(RedirectToPage("./Index"));
}
private void InitCommands()
{
RemoveGoodCommand = new RelayCommand(x =>
{
goodService.Remove(SelectedGood);
Goods.Remove(SelectedGood);
});
RemoveCategoryCommand = new RelayCommand(x =>
{
categoryService.Remove(SelectedCategory);
Categories.Remove(SelectedCategory);
});
RemoveManufacturerCommand = new RelayCommand(x =>
{
manufacturerService.Remove(SelectedManufactirer);
Manufacturers.Remove(SelectedManufactirer);
});
AddUpdateGoodCommand = new RelayCommand(x =>
{
AddUpdateGood dlg = new AddUpdateGood();
dlg.ShowDialog();
var good = new GoodDTO
{
GoodName = GoodViewModelProxy.Proxy.GoodName,
GoodCount = GoodViewModelProxy.Proxy.GoodCount,
Price = GoodViewModelProxy.Proxy.GoodPrice,
CategoryId = categoryService.GetAll().FirstOrDefault(y => y.CategoryName == GoodViewModelProxy.Proxy.GoodCategory).CategoryId,
ManufacturerId = manufacturerService.GetAll().FirstOrDefault(y => y.ManufacturerName == GoodViewModelProxy.Proxy.GoodManufacturer).ManufacturerId
};
var result = goodService.CreateOrUpdate(good);
Goods.Add(result);
});
AddUpdateCategoryCommand = new RelayCommand(x =>
{
AddUpdateCategoryView dlg = new AddUpdateCategoryView();
dlg.ShowDialog();
var category = new CategoryDTO
{
CategoryName = CategoryViewModelProxy.Proxy.CategoryName
};
var result = categoryService.CreateOrUpdate(category);
Categories.Add(result);
});
AddUpdateManufacturerCommand = new RelayCommand(x =>
{
AddUpdateManufactorerView dlg = new AddUpdateManufactorerView();
dlg.ShowDialog();
var manufactorer = new ManufacturerDTO
{
ManufacturerName = ManufacturerModelProxy.Proxy.ManufacturerName
};
var result = manufacturerService.CreateOrUpdate(manufactorer);
Manufacturers.Add(result);
});
}
public RobotSystem(string name, Manufacturers manufacturer, IO io, Plane basePlane, Mesh environment)
{
this.Name = name;
this.Manufacturer = manufacturer;
this.IO = io;
this.BasePlane = basePlane;
this.Environment = environment;
}
internal RobotCell(string name, Manufacturers manufacturer, List<MechanicalGroup> mechanicalGroups, IO io, Plane basePlane, Mesh environment) : base(name, manufacturer, io, basePlane, environment)
{
this.MechanicalGroups = mechanicalGroups;
this.DisplayMesh = new Mesh();
foreach (var group in mechanicalGroups)
{
DisplayMesh.Append(group.Robot.DisplayMesh);
foreach (var external in group.Externals) DisplayMesh.Append(external.DisplayMesh);
}
this.DisplayMesh.Transform(this.BasePlane.ToTransform());
}
internal Mechanism(string model, Manufacturers manufacturer, double payload, Plane basePlane, Mesh baseMesh, IEnumerable<Joint> joints, bool movesRobot)
{
this.model = model;
this.Manufacturer = manufacturer;
this.Payload = payload;
this.BasePlane = basePlane;
this.BaseMesh = baseMesh;
this.Joints = joints.ToArray();
this.MovesRobot = movesRobot;
this.DisplayMesh = CreateDisplayMesh();
// Joints to radians
for (int i = 0; i < Joints.Length; i++)
{
Joints[i].Range = new Interval(DegreeToRadian(Joints[i].Range.T0, i), DegreeToRadian(Joints[i].Range.T1, i));
}
SetStartPlanes();
}
public Products(
string name,
string description,
decimal price,
Categories category,
Manufacturers manufacturer,
int quantity,
bool isFeatured,
bool isRecent,
bool isBestSeller,
string shortDescription)
{
Name = name;
Description = description;
Price = price;
Category = category;
Manufacturer = manufacturer;
Quantity = quantity;
IsFeatured = isFeatured;
IsRecent = isRecent;
IsBestSeller = isBestSeller;
ShortDescription = shortDescription;
}
internal RobotArm(string model, Manufacturers manufactuer, double payload, Plane basePlane, Mesh baseMesh, Joint[] joints) : base(model, manufactuer, payload, basePlane, baseMesh, joints, false) { }
internal Track(string model, Manufacturers manufacturer, double payload, Plane basePlane, Mesh baseMesh, Joint[] joints, bool movesRobot) : base(model, manufacturer, payload, basePlane, baseMesh, joints, movesRobot) { }
public virtual void ChangeManufacturer(Manufacturers manufacturer)
{
if (manufacturer != null && Manufacturer != manufacturer)
{
Manufacturer = manufacturer;
}
}
