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