/*public static int ExecuteInsertType(BusinessLayer.Type type) * { * SqlConnection conn; * SqlCommand cmd; * * using (conn = new SqlConnection(GetConnectionString())) * { * try * { * string sql = "INSERT INTO TypeId (Name) VALUES (@Name)"; * //string sql = "sp_InsertBookInfo"; * * conn.Open(); * * using (cmd = new SqlCommand(sql, conn)) * { * * SqlParameter[] param = new SqlParameter[1]; * * param[0] = new SqlParameter("@Name", System.Data.SqlDbType.VarChar, 20); * * param[0].Value = type.Name; * * foreach (SqlParameter p in param) * { * cmd.Parameters.Add(p); * } * * cmd.CommandType = System.Data.CommandType.Text; * return (int)cmd.ExecuteNonQuery(); * } * } * catch (SqlException ex) * { * return ex.ErrorCode; * } * } * }*/ public static int InsertBorrow(BusinessLayer.Borrow borrow) { string sql = "INSERT INTO Borrow (StudentId, BookId, TakenDate) VALUES (@StudentId, @BookId, @TakenDate)"; DateTime thisDay = DateTime.Today; using (SqlConnection conn = new SqlConnection(GetConnectionString())) { SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@StudentId", SqlDbType.Int); cmd.Parameters.Add("@BookId", SqlDbType.Int); cmd.Parameters.Add("@TakenDate", SqlDbType.Date); cmd.Parameters["@StudentId"].Value = borrow.StudentId; cmd.Parameters["@BookId"].Value = borrow.BookId; cmd.Parameters["@TakenDate"].Value = thisDay.ToString("yyyy-MM-dd HH:mm:ss"); try { conn.Open(); return(cmd.ExecuteNonQuery()); } catch (Exception ex) { Console.WriteLine(ex.Message); return(-1); } } }
public static int UpdateBorrow(BusinessLayer.Borrow borrow) { string sql = "UPDATE Borrow SET BroughtDate = GETDATE() WHERE StudentId = @StudentId AND BookId = @Bookid"; using (SqlConnection conn = new SqlConnection(GetConnectionString())) { SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@StudentId", borrow.StudentId); cmd.Parameters.AddWithValue("@BookId", borrow.BookId); try { conn.Open(); return(cmd.ExecuteNonQuery()); } catch (Exception ex) { Console.WriteLine(ex.Message); return(-1); } } }