public static List <RoomSetupModel> ToRoomSetup(DbDataReader readers) { if (readers == null) { return(null); } var models = new List <RoomSetupModel>(); while (readers.Read()) { var model = new RoomSetupModel { Id = Convert.ToInt32(readers["Id"]), RoomNo = Convert.IsDBNull(readers["RoomNo"]) ? string.Empty : Convert.ToString(readers["RoomNo"]), Description = Convert.IsDBNull(readers["Description"]) ? string.Empty : Convert.ToString(readers["Description"]), BuildingName = Convert.IsDBNull(readers["BuildingName"]) ? string.Empty : Convert.ToString(readers["BuildingName"]), BuildingId = Convert.ToInt32(readers["BuildingId"]), IsRack = Convert.IsDBNull(readers["IsRack"]) ? (bool?)null : Convert.ToBoolean(readers["IsRack"]) }; models.Add(model); } return(models); }
public ResponseModel Save(RoomSetupModel model) { var err = string.Empty; const string sql = @"IF NOT EXISTS(SELECT TOP 1 * FROM RoomSetup WHERE Id=@Id) BEGIN INSERT INTO RoomSetup(RoomNo,BuildingId,Description,IsRack) VALUES(@RoomNo,@BuildingId,@Description,@IsRack) END ELSE BEGIN UPDATE RoomSetup SET RoomNo=@RoomNo,BuildingId=@BuildingId,Description=@Description,IsRack=@IsRack WHERE Id=@Id END"; var queryParamList = new QueryParamList { new QueryParamObj { ParamName = "@Id", ParamValue = model.Id }, new QueryParamObj { ParamName = "@RoomNo", ParamValue = string.IsNullOrEmpty(model.RoomNo)?null:model.RoomNo }, new QueryParamObj { ParamName = "@BuildingId", ParamValue = model.BuildingId }, new QueryParamObj { ParamName = "@Description", ParamValue = string.IsNullOrEmpty(model.Description)?null:model.Description }, new QueryParamObj { ParamName = "@IsRack", ParamValue = model.IsRack } }; DBExecCommandEx(sql, queryParamList, ref err); return(new ResponseModel { Success = string.IsNullOrEmpty(err) }); }
public IHttpActionResult Save([FromBody] RoomSetupModel model) { return(Ok(_roomSetup.Save(model))); }