Пример #1
0
 public void Update(Position position)
 {
     sqladapter = new SQLSpAdapter("UpPosition");
     sqladapter.AddSqlParameter("@idposition", position.IdPosition);
     sqladapter.AddSqlParameter("@PositionName", position.Position1);
     sqladapter.ExecNonQuery();
 }
 public void Update(UnitOfMeasure _object)
 {
     spAdapter = new SQLSpAdapter("UpUnitOfMeasure");
     spAdapter.AddSqlParameter("@idUnitOfMeasure", _object.IdUnitOfmeasure);
     spAdapter.AddSqlParameter("@Names", _object.Names);
     spAdapter.ExecNonQuery();
 }
Пример #3
0
 public void Create(Ingredients _object)
 {
     spAdapter = new SQLSpAdapter("AddIngredients");
     spAdapter.AddSqlParameter("@Manufacturing", _object.Manufacturing);
     spAdapter.AddSqlParameter("@RawMaterials", _object.RawMaterials);
     spAdapter.AddSqlParameter("@Quantity", _object.Quantity);
     spAdapter.ExecNonQuery();
 }
 public void Create(FinishedProducts _object)
 {
     spAdapter = new SQLSpAdapter("AddFinishedProducts");
     spAdapter.AddSqlParameter("@Names", _object.Names);
     spAdapter.AddSqlParameter("@UnitOfMeasure", _object.UnitOfMeasure);
     spAdapter.AddSqlParameter("@Summ", _object.Summ);
     spAdapter.AddSqlParameter("@Quantity", _object.Quantity);
     spAdapter.ExecNonQuery();
 }
Пример #5
0
 public void Update(Budget budget)
 {
     sqladapter = new SQLSpAdapter("UpBudget");
     sqladapter.AddSqlParameter("@idBudget", budget.IdBudget);
     sqladapter.AddSqlParameter("@budgetsum", budget.BudgetSum);
     sqladapter.AddSqlParameter("@Prosent", budget.Prosent);
     sqladapter.AddSqlParameter("@ProsentSalary", budget.ProsentSalary);
     sqladapter.ExecNonQuery();
 }
 public void Create(ProductSales _object)
 {
     spAdapter = new SQLSpAdapter("AddProductSales");
     spAdapter.AddSqlParameter("@FinishedProduct", _object.FinishedProduct);
     spAdapter.AddSqlParameter("@Quantity", _object.Quantity);
     spAdapter.AddSqlParameter("@Date", _object.Date);
     spAdapter.AddSqlParameter("@Employees", _object.Employees);
     spAdapter.ExecNonQuery();
 }
 public void Create(LoanRepayment _object)
 {
     sqladapter = new SQLSpAdapter("AddLoanRepayment");
     sqladapter.AddSqlParameter("@creditId", _object.CreaditId);
     sqladapter.AddSqlParameter("@monthForPay", _object.MonthForPay);
     sqladapter.AddSqlParameter("@yearForPay", _object.YearForPay);
     sqladapter.AddSqlParameter("@dateofPay", _object.DateOfPay);
     sqladapter.ExecNonQuery();
 }
 public void Create(Manufacture _object)
 {
     spAdapter = new SQLSpAdapter("AddManufacture");
     spAdapter.AddSqlParameter("@Production", _object.Production);
     spAdapter.AddSqlParameter("@Quantity", _object.Quantity);
     spAdapter.AddSqlParameter("@Date", _object.Date);
     spAdapter.AddSqlParameter("@Employees", _object.Employees);
     spAdapter.ExecNonQuery();
 }
 public void Update(RawMaterials _object)
 {
     spAdapter = new SQLSpAdapter("UpRawMaterials");
     spAdapter.AddSqlParameter("@idRawMaterials", _object.IdRawMaterials);
     spAdapter.AddSqlParameter("@Names", _object.Names);
     spAdapter.AddSqlParameter("@UnitOfMeasure", _object.UnitOfMeasure);
     spAdapter.AddSqlParameter("@Summ", _object.Summ);
     spAdapter.AddSqlParameter("@Quantity", _object.Quantity);
     spAdapter.ExecNonQuery();
 }
Пример #10
0
 public void Create(PurchaseOfCheese _object)
 {
     spAdapter = new SQLSpAdapter("AddPurchaseOfCheese");
     spAdapter.AddSqlParameter("@Rawmaterials", _object.RawMaterials);
     spAdapter.AddSqlParameter("@Quantity", _object.Quantity);
     spAdapter.AddSqlParameter("@Summ", _object.Summ);
     spAdapter.AddSqlParameter("@Date", _object.Date);
     spAdapter.AddSqlParameter("@Employees", _object.Employees);
     spAdapter.ExecNonQuery();
 }
Пример #11
0
 public void Create(Employees employees)
 {
     sqladapter = new SQLSpAdapter("AddEmployee");
     sqladapter.AddSqlParameter("@FullName", employees.FullName);
     sqladapter.AddSqlParameter("@Position", employees.Position);
     sqladapter.AddSqlParameter("@Salary", employees.Salary);
     sqladapter.AddSqlParameter("@Address", employees.Address);
     sqladapter.AddSqlParameter("@Phonenumber", employees.PhoneNumber);
     sqladapter.ExecNonQuery();
 }
Пример #12
0
 public void Create(Credits credits)
 {
     sqladapter = new SQLSpAdapter("AddCredits");
     sqladapter.AddSqlParameter("@name", credits.Name);
     sqladapter.AddSqlParameter("@creditAmount", credits.CreaditAmount);
     sqladapter.AddSqlParameter("@interestRate", credits.InterestRate);
     sqladapter.AddSqlParameter("@creditTerm", credits.CreditTerm);
     sqladapter.AddSqlParameter("@dateOfIssue", credits.DateOfIssue);
     sqladapter.ExecNonQuery();
 }
 public void Update(LoanRepayment loanRepayment)
 {
     sqladapter = new SQLSpAdapter("UpLoanRepayment");
     sqladapter.AddSqlParameter("@id", loanRepayment.IdLoanRepayment);
     sqladapter.AddSqlParameter("@creditId", loanRepayment.CreaditId);
     sqladapter.AddSqlParameter("@monthForPay", loanRepayment.MonthForPay);
     sqladapter.AddSqlParameter("@yearForPay", loanRepayment.YearForPay);
     sqladapter.AddSqlParameter("@dateofPay", loanRepayment.DateOfPay);
     sqladapter.ExecNonQuery();
 }
Пример #14
0
 public void Delete(int id)
 {
     spAdapter = new SQLSpAdapter("DelIngredients");
     spAdapter.AddSqlParameter("@idIngredients", id);
     spAdapter.ExecNonQuery();
 }
 public void Delete(int id)
 {
     spAdapter = new SQLSpAdapter("DelUnitOfMeasure");
     spAdapter.AddSqlParameter("@idUnitOfMeasure", id);
     spAdapter.ExecNonQuery();
 }
 public void Create(UnitOfMeasure _object)
 {
     spAdapter = new SQLSpAdapter("AddUnitOfMeasure");
     spAdapter.AddSqlParameter("@Names", _object.Names);
     spAdapter.ExecNonQuery();
 }
Пример #17
0
 public void Create(Position position)
 {
     sqladapter = new SQLSpAdapter("AddPosition");
     sqladapter.AddSqlParameter("@PositionName", position.Position1);
     sqladapter.ExecNonQuery();
 }
 public void Delete(int id)
 {
     spAdapter = new SQLSpAdapter("DelRawMaterials");
     spAdapter.AddSqlParameter("@idRawMaterials", id);
     spAdapter.ExecNonQuery();
 }
Пример #19
0
 public void Delete(int id)
 {
     sqladapter = new SQLSpAdapter("DelCredits");
     sqladapter.AddSqlParameter("@id", id);
     sqladapter.ExecNonQuery();
 }
 public void Delete(int id)
 {
     sqladapter = new SQLSpAdapter("DelLoanRepayment");
     sqladapter.AddSqlParameter("@id", id);
     sqladapter.ExecNonQuery();
 }
Пример #21
0
 public void Delete(int id)
 {
     spAdapter = new SQLSpAdapter("DelPurchaseOfCheese");
     spAdapter.AddSqlParameter("@idPurchaseOfCheese", id);
     spAdapter.ExecNonQuery();
 }
 public void Delete(int id)
 {
     spAdapter = new SQLSpAdapter("DelManufacture");
     spAdapter.AddSqlParameter("@idManufacture", id);
     spAdapter.ExecNonQuery();
 }
Пример #23
0
 public void Delete(int id)
 {
     sqladapter = new SQLSpAdapter("DelPosition");
     sqladapter.AddSqlParameter("@idposition", id);
     sqladapter.ExecNonQuery();
 }
Пример #24
0
 public void Delete(int id)
 {
     sqladapter = new SQLSpAdapter("DelEmployee");
     sqladapter.AddSqlParameter("@idemployees", id);
     sqladapter.ExecNonQuery();
 }
 public void Delete(int id)
 {
     spAdapter = new SQLSpAdapter("DelFinishedProducts");
     spAdapter.AddSqlParameter("@idfinishedProducts", id);
     spAdapter.ExecNonQuery();
 }