/*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);
}
}
}
