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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
public void Delete(int id)
{
sqladapter = new SQLSpAdapter("DelPosition");
sqladapter.AddSqlParameter("@idposition", id);
sqladapter.ExecNonQuery();
}
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();
}