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(); }