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 Update(FinishedProducts _object)
{
spAdapter = new SQLSpAdapter("UpFinishedProducts");
spAdapter.AddSqlParameter("@idfinishedProducts", _object.IdFinishedProducts);
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 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 Update(Credits credits)
{
sqladapter = new SQLSpAdapter("UpCredits");
sqladapter.AddSqlParameter("@id", credits.IdCredits);
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(ProductSales _object)
{
spAdapter = new SQLSpAdapter("UpProductSales");
spAdapter.AddSqlParameter("@idProductSales", _object.IdProductSales);
spAdapter.AddSqlParameter("@FinishedProduct", _object.FinishedProduct);
spAdapter.AddSqlParameter("@Quantity", _object.Quantity);
spAdapter.AddSqlParameter("@Summ", _object.Summ);
spAdapter.AddSqlParameter("@Date", _object.Date);
spAdapter.AddSqlParameter("@Employees", _object.Employees);
spAdapter.ExecNonQuery();
}
public void Update(Employees employees)
{
sqladapter = new SQLSpAdapter("UpEmployee");
sqladapter.AddSqlParameter("@idemployees", employees.IdEmployees);
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 IEnumerable <Position> GetList()
{
sqladapter = new SQLSpAdapter("GetPosition");
sqladapter.ExecReader();
foreach (var row in sqladapter.baggage)
{
positions.Add(new Position()
{
IdPosition = Convert.ToByte(row[0]),
Position1 = row[1].ToString()
});
}
return(positions);
}
public List <Years> getYears()
{
sqladapter = new SQLSpAdapter("GetYears");
sqladapter.ExecReader();
foreach (var row in sqladapter.baggage)
{
month.Add(new Years()
{
IdYears = Convert.ToByte(row[0]),
YearsName = Convert.ToInt32(row[1])
});
}
return(month);
}
public List <Month> getMonths()
{
sqladapter = new SQLSpAdapter("getMonth");
sqladapter.ExecReader();
foreach (var row in sqladapter.baggage)
{
month.Add(new Month()
{
IdMonth = Convert.ToByte(row[0]),
MonthName = row[1].ToString()
});
}
return(month);
}
public IEnumerable <UnitOfMeasure> GetList()
{
spAdapter = new SQLSpAdapter("GetUnitOfMeasure");
spAdapter.ExecReader();
foreach (var row in spAdapter.baggage)
{
units.Add(new UnitOfMeasure()
{
IdUnitOfmeasure = Convert.ToInt32(row[0]),
Names = row[1].ToString()
});
}
return(units);
}
public IEnumerable <Budget> GetList()
{
Budget budget;
sqladapter = new SQLSpAdapter("GetBudget");
sqladapter.ExecReader();
foreach (var row in sqladapter.baggage)
{
budget = new Budget();
budget.IdBudget = Convert.ToInt32(row[0]);
budget.BudgetSum = Convert.ToDouble(row[1]);
budget.Prosent = Convert.ToByte(row[2]);
budget.ProsentSalary = Convert.ToByte(row[3]);
budgets.Add(budget);
}
return(budgets);
}
public IEnumerable <Credits> GetList()
{
sqladapter = new SQLSpAdapter("GetCredits");
sqladapter.ExecReader();
foreach (var row in sqladapter.baggage)
{
credits.Add(new Credits()
{
IdCredits = Convert.ToInt16(row[0]),
Name = row[1].ToString(),
CreaditAmount = Convert.ToDecimal(row[2]),
InterestRate = Convert.ToByte(row[3]),
CreditTerm = Convert.ToInt16(row[4]),
DateOfIssue = Convert.ToDateTime(row[5]),
MonthlyPayment = Convert.ToDecimal(row[6]),
Fine = Convert.ToDecimal(row[7])
});
}
return(credits);
}
public IEnumerable <Employees> GetList()
{
Employees st;
sqladapter = new SQLSpAdapter("GetEmployee"); //Указываем имя ХП
sqladapter.ExecReader();
foreach (var row in sqladapter.baggage)
{
st = new Employees();
st.PositionNavigation = new Position();
st.IdEmployees = Convert.ToInt16(row[0]);
st.FullName = row[1].ToString();
st.Position = Convert.ToByte(row[2]);
st.Salary = Convert.ToDecimal(row[3]);
st.Address = row[4].ToString();
st.PhoneNumber = row[5].ToString();
st.PositionNavigation.Position1 = row[6].ToString();
employees.Add(st);
}
return(employees);
}
public IEnumerable <FinishedProducts> GetList()
{
FinishedProducts fp;
spAdapter = new SQLSpAdapter("GetFinishedProducts");
spAdapter.ExecReader();
foreach (var row in spAdapter.baggage)
{
fp = new FinishedProducts();
fp.UnitOfMeasureNavigation = new UnitOfMeasure();
fp.IdFinishedProducts = Convert.ToInt32(row[0]);
fp.Names = row[1].ToString();
fp.Quantity = Convert.ToDouble(row[2]);
fp.Summ = Convert.ToDecimal(row[3]);
fp.UnitOfMeasure = Convert.ToByte(row[4]);
fp.UnitOfMeasureNavigation.IdUnitOfmeasure = Convert.ToByte(row[5]);
fp.UnitOfMeasureNavigation.Names = row[6].ToString();
finishedProducts.Add(fp);
}
return(finishedProducts);
}
public IEnumerable <RawMaterials> GetList()
{
RawMaterials rw;
spAdapter = new SQLSpAdapter("GetRawMaterials");
spAdapter.ExecReader();
foreach (var row in spAdapter.baggage)
{
rw = new RawMaterials();
rw.UnitOfMeasureNavigation = new UnitOfMeasure();
rw.IdRawMaterials = Convert.ToByte(row[0]);
rw.Names = row[1].ToString();
rw.UnitOfMeasure = Convert.ToByte(row[2]);
rw.Quantity = Convert.ToDouble(row[3]);
rw.Summ = Convert.ToDecimal(row[4]);
rw.UnitOfMeasureNavigation.IdUnitOfmeasure = Convert.ToByte(row[5]);
rw.UnitOfMeasureNavigation.Names = row[6].ToString();
rawMaterials.Add(rw);
}
return(rawMaterials);
}
public IEnumerable <Ingredients> GetList()
{
Ingredients ing;
spAdapter = new SQLSpAdapter("GetIngredients");
spAdapter.ExecReader();
foreach (var row in spAdapter.baggage)
{
ing = new Ingredients();
ing.ManufacturingNavigation = new FinishedProducts();
ing.RawMaterialsNavigation = new RawMaterials();
ing.IdIngredients = Convert.ToInt16(row[0]);
ing.Manufacturing = Convert.ToInt32(row[1]);
ing.RawMaterials = Convert.ToInt16(row[2]);
ing.Quantity = Convert.ToDouble(row[3]);
ing.ManufacturingNavigation.IdFinishedProducts = Convert.ToByte(row[4]);
ing.ManufacturingNavigation.Names = row[5].ToString();
ing.RawMaterialsNavigation.IdRawMaterials = Convert.ToByte(row[6]);
ing.RawMaterialsNavigation.Names = row[7].ToString();
ingredients.Add(ing);
}
return(ingredients);
}
public IEnumerable <Manufacture> GetList()
{
Manufacture pr;
spAdapter = new SQLSpAdapter("GetManufacture");
spAdapter.ExecReader();
foreach (var row in spAdapter.baggage)
{
pr = new Manufacture();
pr.ProductionNavigation = new FinishedProducts();
pr.EmployeesNavigation = new Employees();
pr.IdManufacture = Convert.ToInt16(row[0]);
pr.Production = Convert.ToInt32(row[1]);
pr.Quantity = Convert.ToDouble(row[2]);
pr.Date = Convert.ToDateTime(row[3]);
pr.Employees = Convert.ToInt16(row[4]);
pr.ProductionNavigation.IdFinishedProducts = Convert.ToInt32(row[5]);
pr.ProductionNavigation.Names = row[6].ToString();
pr.EmployeesNavigation.IdEmployees = Convert.ToInt16(row[7]);
pr.EmployeesNavigation.FullName = row[8].ToString();
productions.Add(pr);
}
return(productions);
}
public void Create(Position position)
{
sqladapter = new SQLSpAdapter("AddPosition");
sqladapter.AddSqlParameter("@PositionName", position.Position1);
sqladapter.ExecNonQuery();
}
public void Delete(int id)
{
spAdapter = new SQLSpAdapter("DelManufacture");
spAdapter.AddSqlParameter("@idManufacture", id);
spAdapter.ExecNonQuery();
}
public void Delete(int id)
{
spAdapter = new SQLSpAdapter("DelIngredients");
spAdapter.AddSqlParameter("@idIngredients", id);
spAdapter.ExecNonQuery();
}
public void Delete(int id)
{
sqladapter = new SQLSpAdapter("DelLoanRepayment");
sqladapter.AddSqlParameter("@id", id);
sqladapter.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 Delete(int id)
{
sqladapter = new SQLSpAdapter("DelPosition");
sqladapter.AddSqlParameter("@idposition", 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("DelRawMaterials");
spAdapter.AddSqlParameter("@idRawMaterials", id);
spAdapter.ExecNonQuery();
}
public void Delete(int id)
{
spAdapter = new SQLSpAdapter("DelFinishedProducts");
spAdapter.AddSqlParameter("@idfinishedProducts", id);
spAdapter.ExecNonQuery();
}
public void Delete(int id)
{
sqladapter = new SQLSpAdapter("DelEmployee");
sqladapter.AddSqlParameter("@idemployees", id);
sqladapter.ExecNonQuery();
}
public void Delete(int id)
{
sqladapter = new SQLSpAdapter("DelCredits");
sqladapter.AddSqlParameter("@id", id);
sqladapter.ExecNonQuery();
}
