public int Insert(OkPneuTire tire) { SchoolDatabase db = new SchoolDatabase(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_INSERT); PrepareCommand(command, tire); int ret = db.ExecuteNonQuery(command); db.Close(); return ret; }
public int Insert(StoredWheels st) { SchoolDatabase db = new SchoolDatabase(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_INSERT); PrepareCommand(command, st); int ret = db.ExecuteNonQuery(command); db.Close(); return ret; }
//public int Delete(int id) //{ // Database db = new Database(connectionString); // db.Connect(); // SqlCommand command = db.CreateCommand(SQL_DELETE); // command.Parameters.Add(new SqlParameter("@p_id", SqlDbType.Int)); // command.Parameters["@p_id"].Value = id; // int ret = db.ExecuteNonQuery(command); // db.Close(); // return ret; //} public int Insert(Customer cust) { if (!FindCustomerByEmail(cust.email)) { SchoolDatabase db = new SchoolDatabase(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_INSERT); PrepareCommand(command, cust); int ret = db.ExecuteNonQuery(command); db.Close(); return ret; } else return -2; }
protected void Button1_Click(object sender, EventArgs e) { if (DoUpdate) { strBuilCommand.Append(" where @p_id = id"); SchoolDatabase db = new SchoolDatabase(); db.Connect(); string tmp = strBuilCommand.ToString(); SqlCommand command = db.CreateCommand(tmp); PrepareCommand(command, emp); int ret = db.ExecuteNonQuery(command); db.Close(); } Response.Redirect("~/Employees/ListEmployee.aspx"); }
public int Exit(Contract con) { SchoolDatabase db = new SchoolDatabase(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_EXIT); command.Parameters.Add(new SqlParameter("@p_GarageNumber", SqlDbType.SmallInt)); command.Parameters["@p_GarageNumber"].Value = con.GarageNumber; command.Parameters.Add(new SqlParameter("@p_Payment", SqlDbType.SmallInt)); command.Parameters["@p_Payment"].Value = con.Payment; command.Parameters.Add(new SqlParameter("@p_VAT", SqlDbType.Bit)); command.Parameters["@p_VAT"].Value = con.VAT; int ret = db.ExecuteNonQuery(command); db.Close(); return ret; }
public int Arrival(Contract con) { SchoolDatabase db = new SchoolDatabase(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_ARRIVAL); command.Parameters.Add(new SqlParameter("@p_CustomerID", SqlDbType.Int)); command.Parameters["@p_CustomerID"].Value = con.CustomerId; command.Parameters.Add(new SqlParameter("@p_EmployeesID", SqlDbType.Int)); command.Parameters["@p_EmployeesID"].Value = con.EmployeesId; command.Parameters.Add(new SqlParameter("@p_GarageNumber", SqlDbType.SmallInt)); command.Parameters["@p_GarageNumber"].Value = con.GarageNumber; int ret = db.ExecuteNonQuery(command); db.Close(); return ret; }
public bool UnstoreTires(int id, int EmployeeID) { SchoolDatabase db = new SchoolDatabase(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_UNSTORE); command.Parameters.Add(new SqlParameter("@p_id", SqlDbType.Int)); command.Parameters["@p_id"].Value = id; command.Parameters.Add(new SqlParameter("@p_Unstore_id", SqlDbType.Int)); command.Parameters["@p_Unstore_id"].Value = EmployeeID; int ret = db.ExecuteNonQuery(command); db.Close(); if (ret == 1) return true; else return false; }
public int Update(Customer cust) { SchoolDatabase db = new SchoolDatabase(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_UPDATE); PrepareCommand(command, cust); int ret = db.ExecuteNonQuery(command); db.Close(); return ret; }