public static bool Delete(SchedReservation usr)
{
const string GET_DELETE = @"delete [tbSChedReservation] WHERE AmenityNo = @AmenityNo";
SqlCommand com = new SqlCommand(GET_DELETE);
com.Parameters.Add(new SqlParameter("@AmenityNo", usr.AmenityNo));
return(SqlManager.ExecuteNonQuery(com));
}
public static bool Update(SchedReservation usr)
{
const string GET_UPDATE = @"update [tbSchedReservation] set AmenityNo= @AmenityNo, Rate = @Rate WHERE AmenityNo = @AmenityNo";
SqlCommand com = new SqlCommand(GET_UPDATE);
com.Parameters.Add(new SqlParameter("@AmenityNo", usr.AmenityNo));
com.Parameters.Add(new SqlParameter("@Rate", usr.Rate));
return(SqlManager.ExecuteNonQuery(com));
}
public static SchedReservation GetAmenityNo(string ano)
{
const string GET_RECORD = @"SELECT AmenityNo,StartTime,EndTIme,Rate FROM [tbSchedReservation] WHERE AmenityNo = @AmenityNo";
SchedReservation ret = default(SchedReservation);
SqlCommand com = new SqlCommand(GET_RECORD);
com.Parameters.Add(new SqlParameter("@AmenityNo", ano));
ret = SqlManager.Select <SchedReservation>(com).First();
return(ret);
}
//public static bool Modify(SchedReservation usr)
//{
// if (usr.Id == 0)
// return Insert(usr);
// else
// return Update(usr);
//}
public static bool Insert(SchedReservation usr)
{
const string GET_INSERT = @"insert [tbSchedReservation] (AmenityNo,StartTime, EndTIme, Rate) values (@AmenityNo ,getdate(), getdate(), @Rate )";
SqlCommand com = new SqlCommand(GET_INSERT);
com.Parameters.Add(new SqlParameter("@AmenityNo", usr.AmenityNo));
com.Parameters.Add(new SqlParameter("@StartTime", usr.StartTime));
com.Parameters.Add(new SqlParameter("@EndTIme", usr.EndTIme));
com.Parameters.Add(new SqlParameter("@Rate", usr.Rate));
return(SqlManager.ExecuteNonQuery(com));
}