public bool IsExisted(TimeslotMappingInfo info) { //db.Open(); String query = "select count(*) from TimeslotMapping " + " where RowNo = @RowNo "; var obj = (List <int>)db.Query <int>(query, info, transaction); //db.Close(); return(obj[0] > 0); }
public void Update(TimeslotMappingInfo info) { string query = " UPDATE [dbo].[TimeslotMapping] SET " + " [TimeSlotCode] = @TimeSlotCode " + ", [Description] = @Description " + " where RowNo = @RowNo "; db.Execute(query, info, transaction); }
public void Insert(TimeslotMappingInfo info) { string query = "INSERT INTO [dbo].[TimeslotMapping] ( [TimeSlotCode] " + ",[RowNo] " + ",[Description] " + ") " + "VALUES ( @TimeSlotCode " + ",@RowNo " + ",@Description " + ") "; db.Execute(query, info, this.transaction); }