public static bool Delete(EquipReservation eqp)
{
const string GET_DELETE = @"delete [tbEquipReservation] WHERE RefNo = @RefNo";
SqlCommand com = new SqlCommand(GET_DELETE);
com.Parameters.Add(new SqlParameter("@RefNo", eqp.RefNo));
return(SqlManager.ExecuteNonQuery(com));
}
/*
* public static bool Modify(Equipment eqp)
* {
* if (eqp.EquipmentNo == 0)
* return Insert(eqp);
* else
* return Update(eqp);
* }
*/
public static bool Insert(EquipReservation eqp)
{
const string GET_INSERT = @"insert [tbEquipReservation] (EquipNo,Quantity,RefNo) values (@EquipNo, @Quantity, @RefNo)";
SqlCommand com = new SqlCommand(GET_INSERT);
com.Parameters.Add(new SqlParameter("@EquipNo", eqp.EquipNo));
com.Parameters.Add(new SqlParameter("@Quantity", eqp.Quantity));
com.Parameters.Add(new SqlParameter("@RefNo", eqp.RefNo));
return(SqlManager.ExecuteNonQuery(com));
}
public static bool Update(EquipReservation eqp)
{
const string GET_UPDATE = @"update [tbEquipReservation] set EquipNo= @EquipNo, Quantity= @Quantity, RefNo= @RefNo WHERE EquipNo = @EquipNo";
SqlCommand com = new SqlCommand(GET_UPDATE);
com.Parameters.Add(new SqlParameter("@EquipNo", eqp.EquipNo));
com.Parameters.Add(new SqlParameter("@Quantity", eqp.Quantity));
com.Parameters.Add(new SqlParameter("@RefNo", eqp.RefNo));
return(SqlManager.ExecuteNonQuery(com));
}
public static EquipReservation Get(string eno)
{
const string GET_RECORD = @"SELECT EquipNo,Quantity,RefNo FROM[tbEquipReservation] order by EquipNo WHERE EquipNo = @EquipNo";
EquipReservation ret = default(EquipReservation);
SqlCommand com = new SqlCommand(GET_RECORD);
com.Parameters.Add(new SqlParameter("@EquipNo", eno));
ret = SqlManager.Select <EquipReservation>(com).First();
return(ret);
}
